Utility Macros

Utilities for data manipulation

• Univariate.sas (rev=3): Calculates summary statistics for specified variables. Updated 3/26/08.
• quartiles.sas (rev=3): Creates quartile versions of continuous variables. Updated 3/26/08.
• residsqr.sas (rev=1): Calculate the average studentized residuals within each 10-percentile. Updated 4/22/08.
• NPar1way.sas: (rev 2) Combines output from Univariate with non-parametric p-values and organizes results.
• TransposeMany.sas (rev=1): Contains a long2wide and wide2long macro for transposing many variables at once.
• delta.sas : Creates a dataset with the changes from baseline or time=T. (More Deltas.doc)

Macro Tools/Utilities

• words.sas (rev=1): Counts the words in a string (used only for byvars where shortcut lists not allowed). This is taken directly from p256 of the SAS Macro manual.
• Varlist.sas (rev=2): takes a shortcut list of SAS variables as input and returns the expanded list of variable names.
• RefDummy.sas (rev=1): Finds the reference values for categorical variables and creates dummy variables. Updated 4/22/08.
• dummy.sas (rev=1): Creates dummy variables for categorical variables. Updated 4/22/08.
• NextWord.sas Function that returns the first word from a list. (More NextWord.doc)
• RunPrograms.sas Executes a list of SAS programs. (More RunPrograms.doc)
• GetVarList.sas Returns a list of all the Numeric or Character variables in a dataset. (More GetVarList.doc)
• ReplayGraphs.sas Replay graphs from a catalog to put several on one page. (More ReplayGraphs.doc)

Variable or parameter checking macros

• CheckVar.sas (rev=1): Checks that needed variables exist in a particular data set.
• CheckData.sas: Function that checks the existence of a dataset. (More CheckData.doc)
• CheckVariab.sas: Function that checks the existence of a variable. (More CheckVariab.doc)
• CheckVariabs.sas: Function that checks the existence of a list of variables. (More CheckVariabs.doc)
• CheckNumVar.sas: Function that checks the existence of a numeric variable. (More CheckNumVar.doc)
• CheckNumVars.sas: Function that checks the existence of a list of numeric variables. (More CheckNumVars.doc)
• CheckStr.sas: Function that checks if a parameter is in a specified list. (More CheckStr.doc)
• CheckNumber.sas: Function that checks if a parameter is numeric. (More CheckNumber.doc)