Preparing Real World Data in Excel Sheets for Statistical Analysis

@inproceedings{Harm2007PreparingRW,
  title={Preparing Real World Data in Excel Sheets for Statistical Analysis},
  author={Volker Harm and Schering Pharma},
  year={2007}
}
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

References

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…