Date: Tue, 17 Jul 2001 13:07:10 -0400
Reply-To: Dave Brewer <david.brewer@UC.EDU>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Dave Brewer <david.brewer@UC.EDU>
Organization: University of Cincinnati, ECE/CS News Server
Subject: Re: Creating Excel Spreadsheets from SAS
Content-Type: text/plain; charset=us-ascii
Thanks for responding so quickly. Where do I find Koen's paper?
"Brittain, James" wrote:
> Look up Koen Vyverman's paper on DDE with Excel. There is a great macro
> that allows exactly what you are asking. I just joined the world of DDE
> through this paper and I though it was great.
> Jim Brittain
> -----Original Message-----
> From: Dave Brewer [mailto:david.brewer@UC.EDU]
> Sent: Tuesday, July 17, 2001 12:31 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Creating Excel Spreadsheets from SAS
> I would like to create one .xls file (Excel 2000 or 97, doesn't matter)
> from SAS that will contain multiple spreadsheets (or tabs). I am able
> to use PROC EXPORT to create the .xls file, but all I can create from
> this is just one spreadsheet.
> I have three different datasets (YR1, YR2, YR3) that I plan on exporting
> to Excel as one .xls file, but three (3) tabs (spreadsheets). I am
> unclear as to how to get this task accomplished. Any suggestions would
> be greatly appreciated.