OK. Here is an example. libname a1 excel 'c:\a1.xls' getnames=yes;
libname a2 excel 'c:\a2.xls' getnames=yes;
data sheet1;
set a1.'Sheet1$'n a2.'Sheet1$'n;
run;
data sheet2;
set a1.'Sheet2$'n a2.'Sheet2$'n;
run;
proc export data=sheet1 outfile='c:\main.xls' dbms=xls ;
sheet='Sheet1'; putnames=yes; run;
proc export data=sheet2 outfile='c:\main.xls' dbms=xls ;
sheet='Sheet2'; putnames=yes; run;
libname _all_ clear;
Ksharp
... View more
