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

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...
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...
‹
›
Home
View web version
Powered by Blogger.