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

Jim,

Thanks for responding so quickly.  Where do I find Koen's paper?

Dave

"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
>
> Greetings,
>
> 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.
>
> TIA.
> Dave
> david.brewer@uc.edu