Title: Creating an Easy to Use, Dynamic, Flexible Summary Table Macro with P-Values in SAS ® for Research Studies
Abstract: SAS Macros are useful and can save time with routine, repetitive tasks such as creating customized tables in situations when the exact same table is needed repeatedly, but the data changes. However, often flexibility is desired so that the same macro can be used to create similar but not identical tables for different research studies, within the same study or to allow one to quickly accommodate requested changes. This paper presents an easy to use, flexible, dynamic summary table macro that includes p-values. This macro incorporates flexible features that the user specifies through macro parameters: the number and type of row variables, the number of columns, the type of tests one would like p-values from, and the spacing of the table. Currently chi-squared tests, Fisher's exact tests, ANOVA F-tests and t-tests are available and any combination of these can be used. The macro also has dynamic features. The macro automatically provides the column totals, the number of missing values, and assigns SAS formats to the column variable based on the dataset. The macro will also automatically pull in the correct p-value for t-tests depending on whether or not the variances are equal. It is also extremely easy to use. The user simply enters 18 parameter values and a nice looking rtf summary table is produced. Not only can the macro be used immediately for many different types of situations and saves time, but it is also written in a modular format so that one can easily add to it. Users must know the general idea of a SAS macro and how to run one.
Publication Year: 2014
Publication Date: 2014-01-01
Language: en
Type: article
Access and Citation
Cited By Count: 2
AI Researcher Chatbot
Get quick answers to your questions about the article from our AI researcher chatbot