Preparing Real World Data in Excel Sheets for Statistical Analysis

  title={Preparing Real World Data in Excel Sheets for Statistical Analysis},
  author={Volker Harm and Schering Pharma},
This paper collects a set of techniques of importing Excel sheets and creating keys to prepare the data for statistical analysis using proc import and macro variables. The data stem from a real world problem that arose due to a possible production or transport problem. Main topics that came up were: How to name lists of variables in a set of sheets? How to preserve contents of labels in a readable form? How to import character columns with some numerical values? How to eliminate superfluous… CONTINUE READING


Publications referenced by this paper.

Renaming All Variables in a SAS Data Set using the Information from PROC SQL ́s Dictionary Tables

Ravi, Prasad
  • SUGI
  • 2003

Similar Papers

Loading similar papers…