How to read multiple excel sheets from a single excel file at once????

Categories >> Software >> Data Warehouse >> SAS
Suggest New Category

How to read multiple excel sheets from a single excel file
at once????

Question Posted / gajari rao

7 Answers
16849 Views
HCL, Verinon Technology Solutions, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to read multiple excel sheets from a single excel file at once????..

Answer / sravan

Using libname statement.

Libname <lib_name> excel 'file_specification';

Is This Answer Correct ?

5 Yes

0 No

How to read multiple excel sheets from a single excel file at once????..

Answer / vinodnagesh

BY USING DDE TRIPLET

Is This Answer Correct ?

4 Yes

2 No

How to read multiple excel sheets from a single excel file at once????..

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

How to read multiple excel sheets from a single excel file at once????..

Answer / srinivas krishnan

BY USING DDE TRIPLET

Is This Answer Correct ?

0 Yes

1 No

How to read multiple excel sheets from a single excel file at once????..

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

How to read multiple excel sheets from a single excel file at once????..

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

How to read multiple excel sheets from a single excel file at once????..

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

Post New Answer