| Date: | Sat, 25 Jun 2005 03:03:39 +0530 |
|---|
| Reply-To: | "Prakash, Badrish (GE Consumer Finance, consultant)"
<badrish.prakash@GECIS.GE.COM> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | "Prakash, Badrish (GE Consumer Finance, consultant)"
<badrish.prakash@GECIS.GE.COM> |
|---|
| 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.
Badrish
-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of
david
Sent: Sat, 25/Jun/2005 01:08
To: SAS-L@LISTSERV.UGA.EDU
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;
> RUN;
>
> Hamani.
i can not use dde as all code must be submitted via a SAS server.
any other suggestions?
thanks
david
| 
