Need to find all of the errors and warnings in your SAS Log quickly? Unleash the following while inside the log’s directory while on any *nix based OS. egrep ‘(ERROR:|WARNING)’ I save a lot of time scanning the 10,000+ line log files some of the automated jobs create.
Category: SAS
Best Practices: Letting SAS Enterprise Guide Write MDX Code
SAS Enterprise Guide is a VERY useful client tool for SAS development and data analysis. One the best features is the ability to see the SAS code generated from different tasks. In addition to viewing the Base SAS code used to perform different tasks, you can also view MDX code written to create certain measures, members, and sets in OLAP Cubes. Adding Simple Measures from SAS Enterprise Guide Let’s start by creating a simple measure for a Rolling 3 Months of Sales using my SGF2011 cube: Create a time series measure: Enter the parameters: Specify the format: The next screen summarizes the parameters entered into this wizard. You can see the MDX written here as well. Click ‘Finish’ to define the measure. You should see the measure in your cube output. Right click anywhere on the grid output to ‘Edit View’ > ‘Edit with MDX Editor’. This is the output you should see in the MDX Editor: The measure can then be defined in the cube globally by putting the MDX code in the SAS program which builds the cube (if applicable) or through SAS OLAP Cube Studio. This same method can be used to view the MDX code generated […]
Pitfalls of the LAG function
In the immortal words of Britney Spears: Oops! I did it again. At least, I’m afraid that I did. I think I might have helped a SAS student with a homework assignment, or perhaps provided an answer in preparation for a SAS certification exam. Or maybe it was a legitimate […]
NOTE: Coding "Missing Values" (Golden Oldies)
My mini-series of hints and tips from past decades would not be complete without a contribution from the SAS-L mailing list – the 25 years old list server that continues to provide immense value to SAS practitioners worldwide. Joined by the c…
NOTE: Analytics 2012 Conference Series, Germany, 14-15 June
The turn of a New Year is a good time to be thinking about your training plans for the year. Training can take several forms, it doesn’t have to be limited to classroom sessions. Think more broadly. Are there any SAS-related books, or IT-related books …
NOTE: Booked for SAS Global Forum 2012
I’ve just booked my trip to SAS Global Forum (SGF) 2012. Sadly my kids go back to school on the very day that SGF starts – Monday 23rd April – so they won’t be coming with me to Walt Disney World in Florida.
I don’t recall booking so many different tr…
Career: New Year’s Resolution – Get a New Job
LinkedIn for SAS Professionals – Part 1 Linked In is fast becoming a great place for SAS recruiters and SAS candidates to meet. If you are looking for a job, here are some tips to spiff up your Linked In profile to get the SAS programming job of your…
Web Report Studio: Where are the row numbers?
There are times when you need row numbers on your report. Maybe you are ranking items and you want to be clear that the list is ranked or maybe you have a report viewer who only feels the report is complete when the numbers are present. To add row numb…