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
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 ;
I've done it before but forgot the syntax.