Back in September, I shared performance help for SAS 9 users who run on Windows 2008. At that time, I promised more insights from Margaret Crevar. Your next installment has arrived! For all the SAS customers running on AIX (5, 6, or 7), please note…
Tag: Uncategorized
Self-assessments for SAS training courses
We all know SAS offers a rich variety of resources that help users to continuously build their skills. However one of the biggest questions plaguing SAS users is ‘where do I begin’ or ‘what’s next’. Considering the vast array of options t…
A SAS options viewer for SAS Enterprise Guide
On the heels of the release of the popular SAS macro variable viewer from last month, I’m providing another custom task that I hope will prove just as useful. This one is a SAS options viewer, similar in concept to the OPTIONS window in SAS display manager. You can download […]
What’s the difference between 0 and -0?
My daughter’s math lessons this year have included the concept of negative numbers (that is, numbers less than zero, not numbers that have a bad attitude). She has used number lines such as this one to help her while she completes her homework: Notice that in this number line, there […]
Too many pies can be hard to digest
On his SAS and R blog, Ken K. recently posted an example of a visualization technique called “small multiples”. In this exercise, Ken shows the programming technique for replicating a particular series of pie charts in R as well as in SAS. It’s a useful exercise to learn from, but […]
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…
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 …
OLAP users can fall into the abyss of detail data
OLAP cube developers might have noticed that the amount of time required to generate any aggregation (including the NWAY) can negatively impact their productivity. Developers remove the NWAY aggregation (following the sample screens in a prior post) to…