02-16-2011 10:25 AM
02-16-2011 11:13 AM
02-16-2011 01:24 PM
02-16-2011 01:40 PM
02-21-2011 05:26 AM
01-12-2015 11:46 AM
We kept getting a table error trying to open the xml file in excel. We figured it was the two extended ascii characters (éó) in the data. If we changed them to a normal e and o the xml file would open just fine. But then I finally figured out if I changed the first line of the XML file to this:
<?xml version="1.0" encoding="ISO-8859-1"?>
then the XML file opened just fine with the two accented characters in the file.
I tried adding encoding="ISO-8859-1" to the SAS TAGSETS.EXCELXP line but it didn't show up in the first line of the XML output.
So how do we get the encoding to show up in the first line of the XML output?
01-26-2015 04:04 PM
Now we can't get the TRADEMARK symbol to display in Excel. The XML file opens up just fine but it won't display the trademark symbol in excel.
If I change the first line of the XML file in a text editor to: <?xml version="1.0" encoding="ISO-8859-1"?>
It then displays the trademark when opened with Excel.
03-03-2016 07:42 AM
Have the same issue that adding the encoding="ISO-8859-1" with ODS TAGSETS EXCELXP (SAS z/OS 9.1.3) will NOT
create the Excel with the encoding added on the first XML line. The file looks weird then.
Adding the encoding on the first line the file gets open by Excel.
How to add the encoding attribute to the first XML line?