importing multiple xls files into a dataset

[deleted_user]

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

Cheers
ALT

[Cynthia_sas]

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]

[deleted_user]

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.

[Cynthia_sas]

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

[deleted_user]

Thanks, its easier when you know what you have to ask for.