Date: Fri, 23 Jun 2000 09:11:46 -0400
Reply-To: "Bross, Dean S" <dean.bross@MAIL.VA.GOV>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Bross, Dean S" <dean.bross@MAIL.VA.GOV>
Subject: Re: Proc Export
Content-Type: text/plain; charset="iso-8859-1"
I'll give you one possible suggestion.
You could have the SAS export wizard convert a test
file into CSV format. This will feed directly into
EXCEL although it doesn't have all the features
available in EXCEL.
The export wizard does its work by generating
SAS code and running it. So you can just press
the recall button and this will give you the code
to build into your own SAS run. The result will
be a noninteractive conversion, but only to CSV.
The CSV file does have to be loaded into EXCEL
Another possibility is to use DDE. This is not
hard once you learn how to do it, but it is a
little bit more difficult to learn than the
> -----Original Message-----
> From: Nick Paszty [mailto:npaszty@ORGANIC.COM]
> Sent: Thursday, June 22, 2000 4:29 PM
> To: SAS-L@LISTSERV.UGA.EDU
> Subject: Proc Export
> Is there a way to non interactively load output from SAS into
> Excel without
> having Access to PC file formats? I know that there is a
> proc export that
> writes out to an Excel file but do you need Access to PC file
> formats to
> have this functionality or is it simply a part of Base SAS
> export procedure?