How to read multiple excel sheets from a single excel file
at once????
Answer Posted / paul
we can read by a simple libname access method:
eg:
libname exlbook 'd:\excel file location\file name.xls';
proc copy in=exlbook out=work;
run;
/*here i am coying the entire excel workbook to work library
in sas, so we can get all sheets at a time.
if we use proc import we can import a single sheet at a time
By the above method we can dump all table from a MS-access database or oracle database or any other db.
only we have to change the connection details, i.e.,
excel --> file name with path
access --> db name with path
oracle/any other RDBMS --> user=***, password=****,
path=**** or host=****
another advantage of this method is :
the library will not occupy any memory on hard disc
it only acts as a repository which save memory and
processing time */
Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How would you define the end of a macro?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
Which date function advances a date, time or datetime value by a given interval?
what is the basic structure sas administrator? : Sas-administrator
how many types prompting framework can be broken down to? : Sas-bi
Name and describe few sas character functions that are used for data cleaning in brief.
where to use sas business intelligence? : Sas-bi
How to include or exclude specific variables in a data set?
which date function advances a date, time or datetime value by a given interval? : Sas programming
What will calendar procedure do?
what are all the reports you generated in your recent project?
How do dates work in SAS data?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
Explain data step in SAS
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?