Collaboration

Methodologies for Converting Microsoft Excel Spreadsheets to SAS Datasets

Download Now Free registration required

Executive Summary

SAS version 9 offers many new features to handle the conversions from SAS to Excel and back again. Excel is often used as a data entry vehicle, thus making these conversions to SAS necessary. The paper can now control the cosmetic features of the output to Excel using the ODS tagsets, making the end product much more production-ready. There are many creative uses for converting to and from Excel. This paper was intended to inform the SAS user of many new features available to do these conversions. For a more comprehensive reference for ODS tagsets please see the SAS online documentation. There are also many excellent papers on this subject.

  • Format: PDF
  • Size: 89.3 KB