Expand All OLAP Levels in Web Report Studio

When viewing OLAP cubes in Web Report Studio, there comes a time when the user might want to view all the levels within the hierarchy, without the cumbersome process of selecting and expanding each individual item. In 9.2, there is a quick solution. Wh…

Thanks LabSug!

Thank you Los Angeles Basin SAS User Group for listening to my talk on SAS MACRO: Beyond The Basics.The room provided by RAND was excellent. Everything was well organized and the day went without a hitch. The audience was very engaged and had great q…

Glossary of SAS Terms

Q: I would like to have a glossary of technical terms.

A: Almost every book or book series contain a glossary of terms related to product or topic being documented. SAS documentation includes a Base SAS Glossary. This glossary a great place to ge…

Get where condition into the output

The where statement is a powerful and useful tool for subsetting on the fly.  But one problem with it is that the output doesn’t show the conditioning.  This is a little macro I wrote to correct this problem:%macro where(wherest, titleline);w…