SAS Utilities

All utilities were created and tested using SAS 9.2+ on Windows 7.

Program Name Description Download
CreateDatasetListing Creates a well formatted listing for a given data set. html / sas
CreateDirectory Creates a new directory on file system. html / sas
EstablishDDELink Macro utility to establish DDE Link with Excel before allowing program execution to continue. Terminates program execution if connection is not established within 10 seconds. html / sas
ExcelClose Macro utility to close Excel application with option to save. html / sas
ExcelOpen Macro utility to open Excel application or specific Excel file. Terminates program execution if process takes longer than 10 seconds. html / sas
FindCommonVariables List variables appearing in both of two given data sets. html / sas
GetObsCount Return the number of observations in a given data set. html / sas
GetPwd Print present working directory to log. html / sas
GetVarCount Return the number of variables in a given data set. html / sas
ImportDataFile Import data file as fixed width character data with automatic input variable naming. html / sas
ListDatasetVariables Print dataset variables names to log as a vertical list. html / sas
ListMacroDefinitions List all macro names as defined in the current program in the log. html / sas
ListOpenDestinations Print open ODS destinations to the log. html / sas
RemoveDuplicates Macro utility to remove duplicate observations from a dataset. Shows row number in original data set where duplicates occurred. html / sas
StopProgram Terminate program execution for development purposes. html / sas
WordClose Macro utility to close Word application with option to save. html / sas
WordOpen Macro utility to open Word application or specific Word file. Terminates program execution if process takes longer than 10 seconds. html / sas

Powered by peut-publier

©2020 Matt Trzcinski