These are some of my favourite papers from SAS Global Forum 2012 last month. I didn’t to get to see as many papers in person as I’d originally planned; we were very busy at our Metacoda stand. So it was great that the papers had already bee…
Tag: SAS 9.3
New Book: The 50 Keys to Learning SAS Stored Processes
At the SAS® Global Forum 2012 last month I picked up a copy of “The 50 Keys to Learning SAS Stored Processes“, the latest book from the dynamic writing duo, Tricia Aanderud & Angela Hall. As it happens, my partner Michelle also wo…
Sneak Peek at our new Effective Permissions Explorers
This post is a sneak peek at a couple of effective permissions explorers that we are putting into the next version of our Metacoda Security Plug-ins. We’ll also be demoing these at the SAS Global Forum 2012 in Orlando next week, so if you’r…
SAS & IWA: Reviewing SPNs
My last post was about configuring additional Service Principal Names (SPNs) in Active Directory to support the use of Integrated Windows Authentication (IWA) in a SAS® platform installation that uses host name aliases in preference to physical ho…
SAS & IWA: Host Name Aliases and SPNs
I’m quite keen on using host name aliases, rather than their physical host names, when referring to machines in SAS® platform installations. It does however mean a little extra configuration is required when using Integrated Windows Authenti…
SAS Management Console over SSH
I was asked recently how to get SAS® Management Console to remotely access a SAS metadata server using SSH tunnels. In the absence of a VPN connection to your network, SSH can be an alternative for SAS Management Console access to a remote SAS met…
Improving on a SAS programming pattern
Earlier this week I described a common programming pattern in the SAS macro language. The pattern sets up a loop for processing each distinct value of a classification variable. The program uses the PROC SQL SELECT INTO feature to populate SAS macro variables. The effect: you can roll your own […]
How many observations were processed by that last step?
A well-formed WHERE statement or subsetting IF can narrow down the output of your SAS DATA step. The SAS log does a good job of telling you how many records were processed by the action. For example, let’s look at this simple DATA step with my “poor man’s random sample”, […]