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…
Tag: Uncategorized
Computer Science is not just for basement dwellers
When I was a teenager in the 1980s I purchased my first computer: a TI-99/4A. (Wow, TI’s version numbers are more confusing than ours!) I had several friends who had other brands of computers, including the TRS-80 (affectionately known as the “trash 80”) and the Commodore 64. Despite our divisions […]
What’s a good first SAS® training course?
SAS curriculum includes more than 100 SAS, JMP and statistical courses offered in the traditional classroom setting, on-site at your location, in the Live Web classroom, or Self-Paced e-Learning, all aimed at improving user performance and skills using…
Just-in-time data prep in SAS Enterprise Guide
On this blog, I’ve delivered a few tips about using SAS formats to stratify your data values “in place” without having to actually change your data. The most recent example addressed date and datetime variables. My previous examples included simple SAS programs that you can run in SAS display manager […]
Inspecting SAS macro variables in SAS Enterprise Guide
The SAS macro variable “inspector” is a custom task that plugs into SAS Enterprise Guide 4.3. You can use it to view the current values for all SAS macro variables that are defined within your SAS session. You can also evaluate “immediate” macro expressions in a convenient quick view window. […]
Jedi SAS Tricks: Building a Name Suffix variable list
If you’ve taken one of my SAS classes you may recall “Mark’s 3 rules of programming”, the first of which is “Lazy programmers are GOOD programmers.” One of the things I love about best about SAS programming is the plethora of functions an…
Take SAS program editor abbreviations to the next level
Rick posted a tip today about using abbreviations in the SAS program editor window (often referred to as the “enhanced editor”). Defining abbreviations is a great way to save keystrokes and re-use “templates” of code that you’ve squirreled away. (One of Rick’s readers also picked up on the tip, and […]
Do you mind if we dance with your DATEs (or DATETIMEs)?
I’ve been working with date-time data on a recent project, and I’ve come across a few SAS programs that have “opportunity for improvement” when it comes time to create reports. (Or maybe I haven’t, and I contrived this entire blog post so that I could reference one of my favorite […]