Whilst New Year’s resolutions are still in our minds, I’m thinking about my training plans for 2012. One key element of my plan is attendance of SAS Global Forum in April, but at the other end of the scale is my choice of professional reading material …
Category: SAS
SAS Management Console 9.3 Password Indication
You’ve probably encountered this issue too. As an administrator you just want to know whether someone has stored a password in metadata or not. You don’t want to know the actual password, just whether there’s one there or not, because…
SAS OLAP Cubes: Using PROC SQL and MDX to Query OLAP Cubes
SAS PROC SQL has a lot of neat ways you can extract and manipulate data. In my experience, SAS users typically write PROC SQL to query SAS datasets or relational tables in databases. You can also…
[[ This is a content summary only. Visit my webs…
SAS Info Map: Change Source Table Names from Klingonese to English
I love the way some data tables get named. After a while you begin to learn the patterns – but geez sometimes I think a true alien was involved. The names are cryptic and when the tables are…
[[ This is a content summary only. Visit my web…
SAS Info Map: Change Source Table Names from Klingonese to English
I love the way some data tables get named. After a while you begin to learn the patterns – but geez sometimes I think a true alien was involved. The names are cryptic and when the tables are…
[[ This is a content summary only. Visit my web…
Benchmarking of the CUSUM function in SAS/IML
Cumulative sums can be obtained in SAS’s DATA step by the RETAIN statement. As the codes below, a new variable of the cumulative values will be returned by DATA step’s implicit DO loop.
data one;
do i = 1 to 1e6;
z = ranuni(0);
o…
NOTE: Programming for Job Security (Golden Oldies)
This post ends the series of golden oldies. Looking through past conference papers has revealed many interesting nuggets. I was interested to read SAS co-founder John Sall’s paper on PROC MATRIX, the forerunner of SAS/IML. This paper was presented at…
NOTE: Keeping Track of Defects
I recently stumbled across an article on David Biesack’s Peer Revue blog regarding SAS’s defect tracking process. David provides a detailed and extensive insight into how the guys and girls in Cary (and beyond) deal with defects, from beginning to end….