This is the program for the 2010 Joint Statistical Meetings in Vancouver, British Columbia.

Abstract Details

Activity Number: 246
Type: Contributed
Date/Time: Monday, August 2, 2010 : 2:00 PM to 3:50 PM
Sponsor: Section on Statistical Consulting
Abstract - #307466
Title: A Time-Saving SAS Macro to Facilitate Data Import from Excel
Author(s): Alan C. Elliott*+ and Linda S. Hynan
Companies: UT Southwestern Medical Center and UT Southwestern Medical Center
Address: 5323 Harry Hines Blvd, Dallas, TX, 75390,
Keywords: Data cleaning ; Data entry ; Data dictionary ; SAS Macro ; Range checking ; Excel

In this data-centric world, statisticians in research environments are often faced with the time-consuming task of preparing data sets for analysis. In our medical research environment; data provided by colleagues are most commonly in Excel format. These data sets may contain hundreds of variables. This paper describes a time-saving SAS macro that utilizes information in a data dictionary file to create the SAS program statements needed to define variable names, labels, and formats; assign missing values; and to perform basic data range checks. The SAS program created by the macro can then be used to import data from an Excel file and to create a SAS data set that includes appropriate formats, labels, and missing value assignments. In addition, the program produces a report that indicates out of range values (for either continuous or categorical data) found in the data set.

The address information is for the authors that have a + after their name.
Authors who are presenting talks have a * after their name.

Back to the full JSM 2010 program

2010 JSM Online Program Home

For information, contact or phone (888) 231-3473.

If you have questions about the Continuing Education program, please contact the Education Department.