When working in SAS Enterprise Guide, you can access data from the metadata libraries. When you make changes to the datasets in the meta library, such as adding or modifying columns, or even deleted datasets, the metadata library does not have the data…
Building custom measures for OLAP cubes
In one minute (and 10 seconds, but are you measuring that?) you can add a custom measure (also known as calculated members) to your OLAP cube. Watch this video to create a simple calculation multiplying units * price. Remember that this mechanism is no…
NOTE: Hash Tables, An Introduction
In my recent series of articles on testing I used the hash table to provide a means to write/update a table from within a DATA step without demanding changes to the DATA statement, etc. I’ve had some very kind feedback on the series, plus some reques…
Mmm… Dr. G and the M&Ms
“Do you really serve M&Ms every Wednesday? Tell us the story!” clamored a wide-eyed class after sampling the M&Ms lighting up the breakout area. Seeing how hard they worked on their exercises, it seemed ok to have a slight diversion from …
A new way to draw maps in SAS
SAS’s ODS Graphics technology brought the concept of layer into data visualization. We can use those SG procedures to do many tricks. Previously in SAS, a map has to be drawn from its GMAP procedure. Now we can simply use 3-4 lines of codes to sketc…
SAS 9.3
Why is SAS 9.3 so big? Wait, not big. Massive. Huge.