Category: SAS

Read a sheet from an Excel file

 
Yet another useful not-a-trick.
One of the great things about SAS is the accessibility and completeness of the documentation.  However, occasionally lapses in the completeness do come up. 
One example is in importing data.  A primary …

Using SAS Enterprise Guide to run programs in batch

SAS Enterprise Guide is best known as an interactive interface to SAS, but did you know that you can use it to run batch-style programs as well?

SAS Enterprise Guide has always offered an automation object model, which allows you to use scripting…

To attach() or not attach(): that is the question

R objects that reside in other R objects can require a lot of typing to access. For example, to refer to a variable x in a dataframe df, one could type df$x. This is no problem when the dataframe and variable names are short, but can become burdensom…

Support vector machine for classification in SAS by R

I just recently discovered endless fun to synchronize SAS and R to do something meaningful. Yep, I am a SAS programmer: during the day time, I use SAS for money; at the evening, I use R for fun. It is always exciting to hook up them together. How abo…

Using SAS Enterprise Guide to run programs in batch

SAS Enterprise Guide is best known as an interactive interface to SAS, but did you know that you can use it to run batch-style programs as well? SAS Enterprise Guide has always offered an automation object model, which allows you to use scripting langu…

NOTE: PROC DELETE and Other Hits From the Past

Thanks for all your good wishes with regard to passing the magic 300 subscribers watermark. Needless to say, the number plummeted the day after I posted! I feel sure it’ll recover in time.

Thanks also to those who have responded to other recent posts….

NOTE: SAS Professionals Convention 2011 – Registration is Open

I mentioned in a recent post that SAS Professionals Convention 2011 would be held between July 12 – 14 in Marlow. The SAS events web site has now been updated with this year’s details. You can register for the event, and also respond to the call for pa…

Windows 7 Problem Steps Recorder

I was recently introduced to the Windows 7 Problem Steps Recorder (PSR). Wow, it’s a well-hidden nugget of gold in Windows! Have you ever had the task of recording the steps you took in Windows? Perhaps to describe a problem, or maybe to create so…