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

Wednesday, June 13, 2012

SAS Macro to Import all Worksheets of an XLSX file

›
/* SAS Macro to import all worksheets of an XLSX file */ /* http://sastipsbyhal.blogspot.com/ */ /* Extra required software includes...
Thursday, May 17, 2012

Example Libname Statement to Connect to a local MySQL Database

›
Example SAS libname statement to connect to a local MySQL database: libname mys mysql user= your-username password= your-password databa...
Tuesday, March 13, 2012

SAS Macro to Export All Datasets in Library as SPSS Files

›
/********************************************* Export all datasets in library as SPSS Looping code from Paper 93-26 by Edward Moore: htt...

Example Libname Statement to Connect to a Password-Protected Microsoft Access MDB File

›
Example SAS libname statement to connect to a password-protected MDB file: LIBNAME myLib "\\filepath\database.mdb" DBPW="yo...
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...
‹
›
Home
View web version
Powered by Blogger.