SAS Tips by Hal

A SAS user's site featuring a free SAS date calculator, a free SAS datetime calculator (JavaScript), code snippets, and brief discussions

Tuesday, January 31, 2012

PROC SQL: Select Values into Macro Variables

In SAS, it is possible to select/save values into macro variables within PROC SQL. Here are some examples: One Variable (Summarized) PRO...

Friday, December 9, 2011

SAS User who needs to use R?

Are you a SAS user who needs to get something done in R? Instead of learning R, consider using some of the SAS <-> R resources availa...

Friday, November 4, 2011

Importing Multiple Spreadsheets in SAS for Windows

What if you had to integrate data from a large number of spreadsheets scattered throughout a Windows file directory, including a number of ...

Tuesday, August 30, 2011

SAS Macro to Import Excel Files into SAS

/*********************************************************** IMPORT EXCEL files into SAS -works with both xls and xlsx files -assumes all...

Thursday, July 21, 2011

New feature in SAS 9.3 - LIBNAME statement to connect to JMP dataset

New feature in SAS 9.3: LIBNAME JMP associates a libref with a JMP data table and enables you to read and write JMP data tables. http:...

View web version

Powered by Blogger.