Read multiple file at a time?
I have a piece of code. But it will read sheet one by one. i mean i have to call the macro with my particular sheet name.
is there another way i can read all sheet at a time and create one dataset?
%Macro Due_Cal(sheet);
Proc import out= Due_date
Datafile = 'E:\Bank Data Model\project bank\Loan_Congo_Banking.xls'
Dbms = Excel;
Sheet = "&sheet";
Getnames = yes;
run;
%mend Due_Cal;
% Due_Cal (Kinshasa);
Are all the sheets in the excel file the same format?
Can you save your .xls file as .xlsx file?
What sas version do you use?
If your input was a .xlsx file and all your sheets the same format then you could use a code like:
libname myxl xlsx '<path and name>.xlsx';
data want;
set myxl.<sheet1_name>
myxl.<sheet2_name>
...
; run;
sas 9.2 .
windows platform.
microsoft excel 10.
i will try your methd and let u know sir..
Thnaks for the valuable time...
Great advice, use the xlsx engine, but you must have SAS 9.4. To note, you can simply copy so you don't need to type in each one:
libname myxl xlsx '<path and name>.xlsx'; proc copy in=myxl out=work; run; libname myxl clear;
Don't forget to clear the file ref afterwards.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.