|
|
楼主

楼主 |
发表于 2008-10-28 22:45:41
|
只看该作者
a simple DDE error
error
"ERROR: Physical file does not exist, EXCEL|SYSTEM."
my program is
options noxwait noxsync;
X "'C:\Program Files\Microsoft Office\Office\EXCEL.exe'";
DATA _NULL_;
X = SLEEP(3);
RUN;
FILENAME commands DDE 'EXCEL|SYSTEM';
%macro report(path=,outname=);
data _null_;
file commands;
PUT '[OPEN("C:\project\AMX103\05.Modeling\05.03.Other\20081028_dde\temp.xls")]';
run;
FILENAME report DDE "Excel|[temp.xls]sheet1!R7C1:R150C15" NOTAB LRECL=100000;
data random;
do i=1 to 100;
x=ranuni(i);
y=10+x;
z=x-10;
put x y z;
end;
run;
DATA report;
set random;
file report;
put x y z;
run;
data _null_;
file commands;
put "[Save.as(""&Path.\&outname..xls"")]";
put "[Close]";
run;
%mend report;
%report(path=C:\project\AMX103\05.Modeling\05.03.Other\20081028_dde,outname=temp2);
Thanks |
|