Date:         Sun, 17 Oct 2010 07:28:34 -0700
Reply-To:     Arthur Tabachneck <art297@NETSCAPE.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Arthur Tabachneck <art297@NETSCAPE.NET>
Subject:      Re: DDE Save As Problem
Content-Type: text/plain; charset=ISO-8859-1

Buddi,

Your code works correctly on my system, although I was only able to
test it using the xls extension for office 2003.  I'm not familiar
with the newer versions of Excel as yet.

The only potential problem I noticed in your code was that you refer
to a wrk directory.  Does such a directory exist or had you meant to
type work?

Art
--------------
On Oct 17, 7:37 am, Buddi <venumadhav.gadir...@gmail.com> wrote:
> Hi,
>
> I have written the below code to copy created data in to a template
> that has graph, and save it as different excel sheet. when i just save
> it, it is getting saved and code is working fine...but when I save as
> with different name, it is throwing error that is not easy to
> understand for me. please help me in this.
>
> options noxwait noxsync;
> X ' "C:\Program Files\Microsoft Office\Office12\excel.exe " ';
>
> data _null_;
> x = sleep(10);
> run;
>
> FILENAME commands DDE "EXCEL|SYSTEM";
>
> data _null_;
> file commands;
> PUT "[OPEN(""C:\Temp\Reports\AHTTemplate.xlsx"")]";
> x=sleep(3);
> run;
>
> FILENAME ddedata DDE
> "excel|[AHTTemplate.xlsx]AHT!r2c2:r13c3"
> RECFM=V LRECL=25000
> notab;
>
> FILENAME DDECMDS DDE "EXCEL|SYSTEM";
>
> data _null_;
> set wrk.aht_care;
> file ddedata;
> put avg_AHT '09'x avg_sal '09'x;
> run;
>
> FILENAME DDECMDS DDE "EXCEL|SYSTEM";
>
> DATA _null_;
> FILE DDECMDS;
> x=sleep(3);
> put '[error(false)]';
> PUT '[SAVE.as("C:\Temp\ahtcare.xlsx")]';
> PUT " [quit()] ";
> run;
>
> filename ddecmds clear;
> filename ddedata clear;
>
> error : ERROR 22-322: Syntax error, expecting one of the following: a
> name, an integer constant,
>               arrayname, #, $, &, (, +, /, //, :, ;, ?, @, @@,
> OVERPRINT, _ALL_, _BLANKPAGE_,
>               _ODS_, _PAGE_, ~.