I’ve been doing a lot of file manipulation recently (hence my observations on INFILE’s FILEVAR). I’ve become a great fan of SYSTASK for executing operating system commands. The key element to SYSTASK’s capabilities is that it can execute commands …
Tag: SAS
NOTE: With SYSTASK, Even Men Can Multi-Task!
I’ve been doing a lot of file manipulation recently (hence my observations on INFILE’s FILEVAR). I’ve become a great fan of SYSTASK for executing operating system commands. The key element to SYSTASK’s capabilities is that it can execute commands …
Desktop Files for Launching SAS Apps on Ubuntu
Whilst I often use the command line on Linux, it’s also nice to have icons in the menus to start SAS® applications like SAS Management Console and SAS Display Manager. These days I mostly use GNOME Do as an application launcher (its a bit like Quicksilver for Mac OS X). Naturally I like to be […]
NOXCMD: NO eXternal CoMmanDs!
SAS® platform administrators can get quite familiar with the SAS NOXCMD option, usually when someone asks why their programs that used to work (in a different SAS version or execution environment) are now failing. Perhaps the programs ran ok with SAS Enterprise Guide 4.1 using a SAS 9.1.3 server but now fail with SAS Enterprise […]
sas7bdat database reader update
An earlier post (1216) introduced a compatibility study (i.e. reverse engineering) of the sas7bdat database file format. The code and documentation for this are here: http://github.com/biostatmatt/sas7bdat. I’ve recently restructured the code as an R package, and added some functionality. Look for the sas7bdat package on the CRAN. Also, the read.sas7bdat code has been ported to […]
Favourite Platform Admin Papers from SAS Global Forum 2011
These are some of my favourite papers from SAS Global Forum 2011. As a platform administrator and metadata fan I am obviously biased to a specific subset of papers. I’m sure there were many other great papers at the conference, but these are the ones that I liked the most based on my own interests. […]
R for SAS and SPSS Users, A Review
If you’ve followed me for any length of time, you’ll know that I’m bullish on good data analysis. I am not a programmer by training but, through a variety of projects, I’ve found a solid understanding of data manipulation has … Continue reading →
NOTE: Reading Multiple Files (with irregular names)
I was introduced to the INFILE statement’s FILEVAR parameter recently. It seems it’s a great way to read multiple files into a DATA step. Hitherto I had tended to use a widlcard in the FILEREF.
To read multiple files with similar names, you can simply…