| 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 |
|---|
|
| 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
| 
