Category: SAS

Rename all vars in a dataset using SASHELP

*Create a temporary dataset… DSN;data dsn;a=1;b=2;c=3;d=4;e=5;f=6;run;%macro test(lib,dsn);*/1)*/ data _null_;&nbsp &nbsp &nbsp set sashelp.vtable(where=(libname=”&LIB” and memname=”&DSN”));&nbsp &nbsp &nbsp call symput(‘nvars’,nvar);run;*/2)*/ data …

Resources for Solaris and Active Directory Integration

A while back I worked with a client to implement Active Directory (AD) integration for a number of Solaris containers that made up their SAS platform. The main benefit of this was to allow all of the SAS users to use their Windows (Active Directory) credentials, the same ones they use to log into their […]

Installing VirtualBox Guest Additions in Ubuntu

What, you might be wondering, is a post about VirtualBox and Ubuntu doing on a blog that is primarily about SAS® platform administration and metadata? The answer to that question is that VirtualBox and Ubuntu are both platforms where I run SAS for the purposes of development, testing and exploration/learning. So, whilst not specifically related […]

Sudo with no password prompt

DISCLAIMER: This is definitely not recommended for any type of real environment that you rely on to be secure, but sometimes when you are setting up demo/sandpit/throwaway environments you want to be able to execute commands on Linux as root using sudo without getting prompted for your password. You could just work in a root […]

Improving customer loyalty with attrition modeling

Customer retention is a vital concern to many industries including financial services, telecommunications, healthcare and insurance. Many organizations use data mining and analytics to analyze customer behavior to learn attrition risk factors mos…

Look before you buy: peek at your data details before opening

Are you afraid of big commitments? Do you like to shop around thoroughly before making a purchase decision? I can’t help you with most of Life’s Big Choices, but I can help you in one way: I can show you how to learn more about your data set bef…

NOTE: BI Clients V4.3 Available; SAS in Microsoft Outlook (SAS Central)

Version 4.3 of the SAS BI clients was released in the last couple of days. Read more in the What’s Different (Planning for Maintenance) page on the SAS web site.

Not only did I miss SAS Global Forum this year, but I also missed the announcem…