11-18-2015 07:54 PM
I'm using SAS 9.2
When using the ExcelXp tagset, when I place a '/' in the SHEET_NAME, it is replaced by a space in the XML file. Is there a way to avoid this?
ods tagsets.ExcelXP path="C:\" file="my report.xml" style=Journal;
ods tagsets.ExcelXP options(sheet_name="Mostly 3/4 or Better" sheet_interval='None');
proc report data=sashelp.class headline missing nowd split='^^^';
ods tagsets.ExcelXP close;
Thanks in advance!
11-18-2015 08:32 PM
This is a drawback in excel sheet naming convention, which is the reason why you cannot have that special character
There are few rules when naming worksheets.
11-18-2015 08:40 PM
If you are not on the latest tagset version v1.131, download it from here and check if you still get the same problem: