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
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.