Date:         Fri, 1 Jul 2005 09:16:12 -0400
Reply-To:     "Bross, Dean S" <dean.bross@VA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Bross, Dean S" <dean.bross@VA.GOV>
Subject:      Re: DDE opening an Excel file problem
Comments: To: Avi <aviben@BEZEQINT.NET.IL>
Content-Type: text/plain; charset="us-ascii"

Try using a character variable to build the DDE command before
putting the final command through DDE.

This is untested.  Most was copied from your original routine.

data _null_;
             length aaa $ 100 ;
             aaa=&ddd;
file comma1;

*CHANGE THIS STATEMENT ;
*put &ddd;
put aaa ;


run;


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Avi
Sent: Friday, July 01, 2005 6:54 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: DDE opening an Excel file problem

Hi
I have a program that should open an Excel file . For various reasons,
the file name is splitted into 2 parts. The following programs refuses
to open the file as it seems that the PUT satement doen't work well with
the || operator. Could you help?

filename comma1 dde 'excel|system';


%let ccc='[open("C:\word\Ness\Divisions\';

%let bbb='test1.xls")]' ;

%let ddd=&ccc||&bbb;


data _null_;


file comma1;

put &ddd;



run;

Thanks a lot

Avi