Date:         Wed, 5 Feb 2003 20:49:44 -0500
Reply-To:     Amy Lavis <alavis@DFMC.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Amy Lavis <alavis@DFMC.ORG>
Subject:      Export multiple sas datasets to one excel file

Hi,

I'm trying to write a procedure to export multiple sas datasets into one
excel file with either several worksheets. I tried the wizard and got this
but can't seem to figure out how to add more than one sas file to the same
excel table. For example, I would like to export test1 - test10 into one
test.xls with 10 worksheets.

PROC EXPORT DATA= WORK.test
            OUTFILE= "C:\My Documents\test.xls"
            DBMS=EXCEL2000 REPLACE ;
RUN;

I've done it before but forgot the syntax.