The SAS Output Delivery System and reporting techniques

importing multiple xls files into a dataset

Reply
N/A
Posts: 0

importing multiple xls files into a dataset

Hi
has anyone tried to import multiple xls files into a dataset .. all the xls files are of the same format.

Cheers
ALT
SAS Super FREQ
Posts: 8,869

Re: importing multiple xls files into a dataset

Posted in reply to deleted_user
Hi:
This is not an ODS or a BASE Reporting procedure question.

This syntax works for me in SAS 9, but for more help, you should contact Tech Support.

cynthia

[pre]
** both sheets have the same column names;
** I did not rename the sheets, so I have to use the alternate naming convention;
** and treat the names of the sheets as a name literal.;

libname mywb excel "c:\temp\twosheets.xls";

proc contents data=mywb._all_;
run;

data newfile;
set mywb.'Sheet1$'n
mywb.'Sheet2$'n ;
run;

proc print data=newfile;
run;

libname mywb clear;
[/pre]
N/A
Posts: 0

Re: importing multiple xls files into a dataset

Posted in reply to Cynthia_sas
Hi,
I wanted to try your code.

But I got the message:
1 libname mywb excel "D:\PRIPL\Projects\GliclTest\Final.xls";
ERROR: The product with which the engine EXCEL is associated is either not licensed for your system or the product license has expired. Please
contact your SAS installation representative.

Can you please tell me for what module do I have to have a license? SAS/ACCESS or something else, so that I can ask for it.

I got license for these products:
Base Product, SAS/STAT, SAS/GRAPH, SAS/FSP, SAS/LAB, SAS/INSIGHT.
SAS Super FREQ
Posts: 8,869

Re: importing multiple xls files into a dataset

Posted in reply to deleted_user
It sounds like you need the SAS/Access for PC File formats product. Tech Support or your company (internal) SAS rep can help you with this.

cynthia
N/A
Posts: 0

Re: importing multiple xls files into a dataset

Posted in reply to Cynthia_sas
Thanks, its easier when you know what you have to ask for.
Ask a Question
Discussion stats
  • 4 replies
  • 158 views
  • 0 likes
  • 2 in conversation