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
- 18638 Views
- HCL, Verinon Technology Solutions, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sravan
Using libname statement.
Libname <lib_name> excel 'file_specification';
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / rajesh
First you have to split the excel sheets and write the
program in macros and use the dde triplet.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / 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 |
Answer / ashish
%macro pim(sheet);
proc import out= payment
datafile = 'E:SAS DOCprojectCredit Banking.xls'
dbms = Excel;
sheet = "&sheet";
getnames = yes;
run;
%mend piim;
%pim(Customer Acqusition);
%pim(Spend);
%pim(Repayment);
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / lucylu
%macro read_moresheets(ifile, lib);
libname ixls excel &ifile;
proc sql;
select memname into :ds1 - :ds100
from sashelp.vtable
where libname = "IXLS" and index(memname,'$') = 0
;
quit;
%put _user_;
%do i = 1 %to &sqlobs;
data &lib..&&ds&i;
set ixls.&&ds&i;
run;
%end;
%mend;
%read_moresheets("C:\Ongoing\CallActivity.xls", work);
| Is This Answer Correct ? | 1 Yes | 3 No |
What is the purpose of trailing @ and @@? How do you use them?
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
how can get the first and last observations in a dataset using Proc SQl?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too
What other SAS features do you use for error trapping and data validation?
What report output formats can you generate using SAS?
Hi Friends, My name is Priya,am new to this Forum. am looking for SAS Platform Administration Interview Questions.I searched every where but I couldn't find any where.please can anyone help me with the FAQ's. It would be a great favor to me if you can email the Interview Questions to priyafeb84@gmail.com
what is fact table and factless table?
how do you read binary data in sas?
what r the job openings SAS for fresher graduates !
What sas features do you use to check errors and data validation?
Teradata 
