Interested to Buy Any Domain ? << Click Here >> for more details...
How to read multiple excel sheets from a single excel file
at once????
- 7 Answers
- 18871 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
what is sas application server? : Sas-di
How do you test for missing values?
what is change analysis in sas di ? : Sas-di
What are types of transport files?
What is the use of the %include statement?
If a variable contains only numbers, can it be a character data type?
What is proc sort?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
What sas features do you use to check errors and data validation?
what is program data vector? : Sas-administrator
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
Mention what is SAS data set?
What do the PUT and INPUT functions do?
what is sas database server? : Sas-di
