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, July 6, 2012

Sample "Where" Clauses for Finding Dates in Text Fields

›
The following where clauses use SAS PRXMatch functions and simple Perl regular expressions to help find dates within SAS dataset text fi...
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...
‹
›
Home
View web version
Powered by Blogger.