11-09-2011 05:34 AM
I have the v1.116 version of the ods tagsets.excelxp.
On my computer without newfile=none option in the ods call, all the results are produced in the same file.
On a collegue's computer without this option newfile=none, a new file is created for each proc call.
Is it possible to set the option newfile=none by default once, without modifying all calls to ods tagsets.excelxp in my programs ?
11-09-2011 10:32 AM
The default for NEWFILE is NONE, unless it has been changed for a particular destination. If your colleague closes SAS and reboots and does a simple invocation:
ods _all_ close;
ods tagsets.excelxp file='testit.xml';
proc print data=sashelp.class(obs=2);
proc print data=sashelp.shoes(obs=2);
ods tagsets.excelxp close;
Is there 1 output file or 2??? The above code should only produce 1 result file, which, when opened with Excel, should be 1 workbook containing 2 worksheets. If your colleague gets 2 result files (after closing SAS and rebooting), then my recommendation would be to open a track with Tech Support.