Import multiple Excel worksheets in one datastep? 1

[ad2]

Hi,

I have several worksheets in the Excel source file. Is there a way to import each in one datastep and then merge?

I've tried the following but it only imports the first worksheet:

<code>
proc import datafile="C:\data.xls"
out=customers
dbms=excel replace;
SHEET="'1$'";
SHEET="'2$'";
run;
</code>

Thanks

 

[ad2]

I've found a good example at:

http://www2.sas.com/proceedings/sugi31/034-31.pdf

I modified this code and it works fine.

--Ad2