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

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:...

Wednesday, July 6, 2011

How to create a SAS date from "YYYY-MM-DD HH:MM:SS"

Problem How to pull a SAS date from a text field formatted as YYYY-MM-DD HH:MM:SS. Solution data myTable; set myTable; informat date...

Friday, June 10, 2011

SAS Macro to Import Tab-Delimited Files into SAS

/*********************************************************** IMPORT TAB-DELIMITED text files into SAS June 10, 2011 http://sastipsbyhal....

View web version

Powered by Blogger.