Be a code poet laureate

The next time you write a DATA step, try to express it in iambic pentameter.  Or instead of a SAS macro function, how about a SAS macro sonnet?  (Or, for the more base among you, a limerick?) That’s the spirit behind the code {poems} project.  You write a poem in […]

Use GREPLAY to create multiple graphs per page

Desired result:This sample program uses PROC GREPLAY together with macro code to dynamically replay a specific number of graphs per page.The graphics output in the Results tab was produced using SAS® 9.2. Submitting the sample code with releases of SA…

OLAP Cube Studio: Looking at PROC OLAP Code

If you have never worked with OLAP code – then you might be curious how it works and what it looks like. Some developers use SAS OLAP Cube Studio to start their cube building process since it saves some of the typing required. Let’s review some of the code. [Adv Users: check out Steve’s posts about OLAP Code] Exporting PROC OLAP Code There are two methods to export your cube to a SAS program from SAS OLAP Cube Studio. Use Method 1 after you have added custom measurements. Click cube name > Export Code. The Export Code window appears. Use Method 2 after you have completed the Cube Designer wizard. Click the Export Code button. The Export Code window appears. From the Export Code window you can select if you want standard (long) OLAP procedure code or the shorten code. Either way – just add the path and program name. [More at SAS Support about when to use short/long form. ] Under the Hood After opening the BUILD_GA_BLOGSITE.sas program in Enterprise Guide, you see how the OLAP procedure code appears. You can learn to code your own cubes, just by reviewing how the OLAP wizard wrote the code. For instance, […]

NOTE: B&D to be Acquired by Sopra

One of the UK’s largest independant providers of SAS skills, Business & Decision UK, is to be acquired by the Sopra Group. Jointly announced with the same press release (B&D, Sopra) on the 13th February, the transaction is expected to be comple…