|Date: ||Sat, 25 Jun 2005 03:03:39 +0530|
|Reply-To: ||"Prakash, Badrish (GE Consumer Finance, consultant)"
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||"Prakash, Badrish (GE Consumer Finance, consultant)"
|Subject: ||Re: SAS to excel.|
|Content-Type: ||text/plain; charset="iso-8859-1"|
I guess what David meant was that he is rsubmitting the SAS codes to a server that doesn't have Excel.. and hence not able to execute DDE.
One of the probable solutions is to export the data as a CSV/TXT.. and download it on the local machine and let an Excel Macro handle the output formatting.
Please let know if that helps.
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of
Sent: Sat, 25/Jun/2005 01:08
Subject: Re: SAS to excel.
Elmaache, Hamani wrote:
> If understood your question, I think the following code can help you,
> but you should first open 'yourexcel' and name a sheet 'namesex ':
> FILENAME ddedata DDE 'excel|H:\temp\yourexcel\namesex !r8c1:r20c3';
> DATA _NULL_;
> FILE ddedata;
> set sashelp.class;
> PUT sex age name;
i can not use dde as all code must be submitted via a SAS server.
any other suggestions?