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
|
Abstract:
|
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 jsm@amstat.org or phone (888) 231-3473.
If you have questions about the Continuing Education program, please contact the Education Department.