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.
2 Figure 1 is an Example for the Multi-Sheet Work Book, with variables STUDY ID SUBJECT ID DRUGNAME START DATE, There are three Sheets with names Source1 Source2 Source3, Each of the Sheet
Loading..
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: