Transcription of NESUG 2011 Coders' Corner ABSTRACT - Lex Jansen
{{id}} {{{paragraph}}}
Example: barber
NESUG 2011 Coders' Corner ABSTRACT - Lex Jansen
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.
3 /***PART2 THE ABOVE MACRO VARIABLE TOT IS USE TO RUN A DO LOOP SO THAT WE HAVE TO CREATE NAMES OF THE VARIABLES****/ %do i= 1 %to &tot; /*Create macro variables to store names of variables for ...
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
Related search queries
Without PROC SQL and, WITHOUT PROC SQL AND THE MACRO LANGUAGE, Macro language, PROC SQL, SQL Procedure: User's Guide, SAS Macro, Calculating Statistics Using PROC, Calculating Statistics Using PROC MEANS, PROC, Advanced Subqueries In PROC SQL, For OS/390, VM, VSE, System do the work! Automate your SAS