(I am back and saw Robert suggest.) I conclude that in 9.3.2 this problem does not occur more as ods results=on; ods html ; * in case of doubt; proc sql;select * from dictionary.destinations; quit; ods results off; * ods listing close; ods tagsets.excelxp file="d:\temp\tworeally.xls" style=sasweb ; ods tagsets.excelxp options(sheet_name='parameters'); proc print data=sashelp.class noobs;run;quit; ods tagsets.excelxp options(sheet_name='pen_r'); proc print data=sashelp.air noobs; run;quit; ods tagsets.excelxp close; i obtain only one file and the sql is returning the open destination in 9.3... by default
... View more