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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.