[ods tagsets.excelxp]Is it possible to set newfile=none by default ?

[phil27]

Hello,

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 ?

Thanks.

[Cynthia_sas]

Hi,

  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);

run;

proc print data=sashelp.shoes(obs=2);

run;

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.

cynthia