Showing posts with label SAS Macro. Show all posts
Showing posts with label SAS Macro. Show all posts
Friday, March 20, 2015

SAS Macro to Print Record Counts for All Tables in a Library

›
/*----- PRINT RECORD COUNTS OF ALL TABLES IN LIBRARY -----*/ /* Looping code from Paper 93-26 by Edward Moore: http://www2.sas.com/procee...
Wednesday, March 18, 2015

SAS Macro to Import CSV Files into SAS

›
/*********************************************************** IMPORT CSV files into SAS Work Library June 10, 2011 http://sastipsbyhal.bl...
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...
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...
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...
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...
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....