How to read multiple excel sheets from a single excel file
at once????
- 7 Answers
- 16983 Views
- HCL, Verinon Technology Solutions, I also Faced
- E-Mail Answers
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
explain the function of substr in sas? : Sas-administrator
Explain by-group processing?
How necessary is it to be creative in your work?
How do you use the do loop if you don’t know how many times you should execute the do loop?
How do dates work in sas?
How many data types are there in SAS?
Intern stastical programmer written test
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
what are input dataset and output dataset options? : Sas programming
what is sas metadata server? : Sas-di
describe how to adjust the performance of data integrator? : Sas-di
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
How are numeric and character missing values represented internally?
What are SAS/ACCESS and SAS/CONNECT?
