OS2Rules,
Did you ever get this resolved?
Hi:
We must have but for the life of me I can't figure what we did....
If I remember (or figure it out again), I'll let you know.
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?
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.
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?
Thank you
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.