Date: Thu, 7 Oct 1999 17:50:16 GMT
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Organization: Deja.com - Before you buy.
Subject: Re: SAS to excel ?
Under VMS, this task can be accomplished rather simply by
creating separate CSV (comma separated values) files for each SAS
Then using the "copy" command under VMS, you can concatenate all of
files into 1 large CSV file. Now, when combining these files; every
starting the the 2nd file will be a "dummy" file with a couple of blank
creating the separation between each table.
Under VMS, the copy command would be like this:
copy file1 file2 file3 file4 file5 file6 ... filen
File filen would be the 1 file which holds all the other previous CSV
file2, file4, file6, etc would be the empty (2 blank lines) file for
I am sure other operating systems have similar OS "copy" commands if I
As for creating the CSV files from SAS datasets, there is a macro on my
"www.sasconsig.com" under "tips and techniques" which will dump any SAS
to a csv file. You are welcome to use it.
In article <firstname.lastname@example.org>,
> Dear friends,
> I have a following problem. In my sas program, lots of tables
> generated. I need to export them into excel. I have a sas to dbf
> it will create one dbf file for each table. However, I like to have
> 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
> to some AF application or macro that will help me to achieve this ?
> Hongjie Wang
Charles Patridge - PDPC, Ltd.
172 Monce Road - Burlington, CT 06013
860-673-9278 or 860-675-9026
Sent via Deja.com http://www.deja.com/
Before you buy.