Date: Thu, 7 Oct 1999 17:50:16 GMT
Reply-To: charles_s_patridge@MY-DEJA.COM
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: charles_s_patridge@MY-DEJA.COM
Organization: Deja.com - Before you buy.
Subject: Re: SAS to excel ?
Dear Honjie,
Under VMS, this task can be accomplished rather simply by
creating separate CSV (comma separated values) files for each SAS
dataset.
Then using the "copy" command under VMS, you can concatenate all of
these
files into 1 large CSV file. Now, when combining these files; every
other file
starting the the 2nd file will be a "dummy" file with a couple of blank
rows, thus
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
files and
file2, file4, file6, etc would be the empty (2 blank lines) file for
separation.
I am sure other operating systems have similar OS "copy" commands if I
remember
correctly.
As for creating the CSV files from SAS datasets, there is a macro on my
website
"www.sasconsig.com" under "tips and techniques" which will dump any SAS
dataset
to a csv file. You are welcome to use it.
Good Luck,
Chuck Patridge
In article <0.1cd579fe.252dfaa8@aol.com>,
Hongjiew@AOL.COM wrote:
> 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
>
--
Charles Patridge - PDPC, Ltd.
172 Monce Road - Burlington, CT 06013
860-673-9278 or 860-675-9026
Charles_S_Patridge@prodigy.net www.sasconsig.com
Sent via Deja.com http://www.deja.com/
Before you buy.
