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…
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…