I get the below error message when reading xml file.
Is it something i am missing
ERROR: Some code points did not transcode.
occurred at or near line 69, column 311
ERROR: XML parsing error. Please verify that the XML content is well-formed.
Please help
filename SXLELIB 'C:\CTgovAE.xml';
filename SXLEMAP 'C:\CTGovMap.map';
libname SXLELIB xmlv2 xmlmap=SXLEMAP access=READONLY;
data add;
set SXLELIB.primary_outcome;
run;
I would imagine - though can only guess as I have no information to work with - that at line 69, column 311, there is a character that does not fit into the character set you are using, or that your XML is not a proper XML file. The former would be my guess, look at the file in textpad or using a hex editor, you will likely find a strange symbol there.
Probable cause: your SAS is not configured for UTF support, but the XML contains UTF characters.
Copy the ine 69, column 311 and paste on notepad++. Change the encoding to ANSI. You will notice special character in it. Also check config..
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
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.
Ready to level-up your skills? Choose your own adventure.