Date:         Fri, 23 Jun 2000 16:25:22 +0200
Reply-To:     Poul Ravn Sørensen <poulravn1@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Poul Ravn Sørensen <poulravn1@HOTMAIL.COM>
Organization: Customer at Tele Danmark Erhverv
Subject:      Re: Proc Export

I have several programs doing the conversion by DDE. It works this way:

Have SAS open Excel (start (excel myfile.xls);) and declare a filename
pointing to the sheet in the *.xls file that you want to write to.

Then use the file statement to open the filename for the put statement

Finally use the put statement as appropriate to write anyting you want. Use
the '09'x separator to have Excel skip from one cell to the next.

Its all in the 'SAS for Windows companion and probably also in a technote on
their website.

Regards

Poul

Nick Paszty wrote in message
<4.3.1.2.20000622132800.00adc170@po1-sf2.organic.com>...
>Hello.
>
>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?
>
>Thanks,
>
>Nick