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.
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.