用DDE导出数据出现问题，清指教

shiyiming

我在用DDE 导出数据出现问题，程序如下
[code:a9bb3]data a;
input height;
cards;
10
20
30
;
run;
filename recrange dde 'excel|[jjg.xls]  sheet1! r1c1:r4c1' notab;

data _null_;
set a;
file recrange;
put height;
run;[/code:a9bb3]


但是出现如下提示
ERROR: Physical file does not exist, excel|[jjg.xls]  sheet1! r1c1:r4c1.
NOTE: The SAS System stopped processing this step because of errors.
可是我的文件名和路径都对啊！请指教。

shiyiming

可能原因：

1) 将引号中多余的空格去掉，如下
filename recrange dde 'excel|[jjg.xls]sheet1!r1c1:r4c1' notab;

2)运行之前，必须打开jjg.xls。

shiyiming

多谢子豹兄。
还有一问题也是这方面的。

filename sas2xl dde 'excel|system';
data _null_;/*creat a new excel workbook*/
file sas2xl;
  put '[new(1)]';
  put '[save.as(''c:\dataset\newxl'')]';
  run;

NOTE: The file SAS2XL is:
      DDE Session,
      SESSION=excel|system,RECFM=V,LRECL=256

ERROR: DDE session not ready.
FATAL: Unrecoverable I/O error detected in the execution of the data step program.
       Aborted during the EXECUTION phase.