Transcription of NESUG 2011 Coders' Corner ABSTRACT
{{id}} {{{paragraph}}}
Example: bankruptcy
NESUG 2011 Coders' Corner ABSTRACT
1 READING multiple SHEETS FROM excel USING SAS Sandeep Kottam, Programmer consultant, Independent Consultant, NJ. Sree Lakshmi K Tripuraneni, Programmer consultant, Purdue Pharma, Stamford, CT. ABSTRACT : When importing data from Microsoft excel into SAS you can use the IMPORT Wizard, PROC IMPORT, ODBC, PROC DBLOAD, PROC ACCESS, DDE (Dynamic Data Exchange). When multiple worksheets need to be imported, it adds more complexity. We have to specify the different sheet names by hard coding, so that the sheet names are visible to the SAS system. In most of the multi-sheet situations, the number of worksheets, sheet names happens to be different, and sometimes the column names in sheets are too messy to be used. This paper describes how to read in multiple sheets from a work book, append the datasets created by importing sheets.
1 READING MULTIPLE SHEETS FROM EXCEL USING SAS® Sandeep Kottam, Sr.Statistical/SDTM Programmer consultant, Independent Consultant, NJ. Sree Lakshmi K Tripuraneni, Sr.Statistical Programmer consultant, Purdue Pharma, Stamford, CT.
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: