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..
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.