Date:         Sat, 9 Oct 1999 09:11:53 -0700
Reply-To:     "Alyssa K. McLoney" <sariswife@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Alyssa K. McLoney" <sariswife@YAHOO.COM>
Organization: MindSpring Enterprises
Subject:      Re: SAS to excel ?

Hong I wrote my own macro to use DDE with SAS 7 (can't wait until 10/24 for
Version 8 :-) ) to work with excel 97.  This way I dump what I want into a
single workbook.




Hongjie Wang wrote in message <0.1cd579fe.252dfaa8@aol.com>...
>Dear friends,
>I have a following problem. In my sas program, lots of tables (datasets)
are
>generated. I need to export them into excel. I have a sas to dbf macro.
But,
>it will create one dbf file for each table. However, I like to have all the
>tables stored in one excel file. The structure could be one table per
sheet,
>or all in the same sheet with some space in-between. Could someone refer me
>to some AF application or macro that will help me to achieve this ?
>
>Thanks.
>
>Hongjie Wang
>hongjiew@aol.com