Online Program Home
  My Program

Abstract Details

Activity Number: 293 - SPEED: Computing, Graphics, and Programming Statistics
Type: Contributed
Date/Time: Tuesday, August 1, 2017 : 8:30 AM to 10:20 AM
Sponsor: Section for Statistical Programmers and Analysts
Abstract #323437 View Presentation
Title: A SAS Macro to Create Summary Tables
Author(s): Amy Gravely* and Barbara Clothier
Companies: VA Medical Center and CCDOR MVAHCS
Keywords: SAS ; Macro ; Summary Table ; Flexible ; Dynamic ; Transparent

SAS Macros are useful and can save time with routine, repetitive tasks such as creating customized tables in situations when the exact same table structure 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 can include p-values, if the user desires. This type of table is often seen as the first table in published research articles. The macro incorporates flexible features that the user specifies through macro parameters such as the number and type of row variables, the tests one would like p-values from, the spacing of the table, the style and whether or not to show missing values. The macro also has dynamic features so it automatically provides the column totals, grabs the formats itself, and will automatically pull the correct p-value for t-tests depending on whether or not the variances are equal.

Authors who are presenting talks have a * after their name.

Back to the full JSM 2017 program

Copyright © American Statistical Association