A colleague is a devotee of confidence intervals. To him, the CI have the magical property that they are immune to the multiple comparison problem– in other words, he feels its OK to look at a bunch of 95% CI and focus on the ones that appear to exc…
Category: SAS
SAS and VBA (5) : replace values quickly
SAS and VBA both have their unique and quick ways to replace values in one or multiple columns.
VBA
VBA has a wonderful function Replace for several columns or regions, where the changes are likely to be happened.
Sub Replace()
With Columns(…
Three must have SAS freebies
“I want everything!” said a student when I paused to ask my SAS Programming 1 class what else they wanted to learn. Seriously! You want me to share everything I know in three days? The student came back with… “Well okay, what about those freebies …
SAS and VBA (3) : fill missing values with last valid observation
In many data management routines, it is common to fill the missing values with the last valid one. For example, we want to maintain the patient visit log about several patients, which records their weight for each visit. Given these patients’ absence…
SAS and VBA (3) : lower triangle multiplication table
Flow control and looping is a very important aspect for any programming language. To see how to index a particular value in the languages’ default data type, creating a lower triangle multiplication table looks like a good test, since it is a simp…
Watch and learn: Save time with Task Templates
In this SAS Add-In for Microsoft Office Tip, instructor Rob McAfee teaches how to save steps with Task Templates. Using Task Templates saves you time and ensures consistency when you are creating several similar reports and analysis. A Task Templat…
SAS and VBA (1) : cross tabulation and bar chart
No other tools can challenge Excel’s stance in the data analysis world. I didn’t spot many computers that are not installed with it, and I assume that everybody who faces a computer during work has to use it sometime. With the power of VBA, it is a…
The SAS Macro Language: Powerful as a Corvette!
I love the power of my Corvette and the power of the SAS macro language. That is why, for the past 12 months, when not driving my Corvette, I put my heart and soul into the challenging task of updating our SAS Macro Language 2 course, soliciting inpu…