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
Hongjie Wang wrote in message <firstname.lastname@example.org>...
>I have a following problem. In my sas program, lots of tables (datasets)
>generated. I need to export them into excel. I have a sas to dbf macro.
>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
>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 ?