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