我有一段code,自己定义了两个宏变量path和new_filename,可以用x命令时,因为外面必须有一个单引号,所以没办法解析这两个宏变量,有什么办法能解决么???
%let path = C:\Users\weix10\Desktop\New folder\;
%let new_filename = aaa.xlsx;
options noxwait noxsync;
x ' "&path.&new_filename." ';
%macro dde_worksheet_delete(iWorksheet=);
filename cmdexcel dde 'excel|system';
data _null_;
file cmdexcel;
put '[error(false)]';
put "%str([workbook.delete(%"&iWorksheet%")])";
put '[error(true)]';
put '[save()]';
put '[quit()]'
run;
filename cmdexcel clear;
%mend;
%dde_worksheet_delete(iWorksheet=Sheet1);