topic Re: importing multiple xls files into a dataset in ODS and Base Reporting

importing multiple xls files into a dataset

deleted_user — Wed, 10 Oct 2007 04:39:48 GMT

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

Cheers
ALT

Re: importing multiple xls files into a dataset

Cynthia_sas — Wed, 10 Oct 2007 14:23:00 GMT

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]

Re: importing multiple xls files into a dataset

deleted_user — Thu, 11 Oct 2007 09:20:18 GMT

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.

Re: importing multiple xls files into a dataset

Cynthia_sas — Thu, 11 Oct 2007 14:53:46 GMT

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

Re: importing multiple xls files into a dataset

deleted_user — Fri, 12 Oct 2007 06:17:35 GMT

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