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

phil27 — Wed, 09 Nov 2011 10:34:52 GMT

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.

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

Cynthia_sas — Wed, 09 Nov 2011 15:32:05 GMT

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

topic [ods tagsets.excelxp]Is it possible to set newfile=none by default ? in ODS and Base Reporting

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

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