topic Re: error while reading xml file in SAS Programming

error while reading xml file

vraj1 — Tue, 02 Jan 2018 12:57:22 GMT

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;

Re: error while reading xml file

RW9 — Tue, 02 Jan 2018 13:09:38 GMT

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.

Re: error while reading xml file

Kurt_Bremser — Tue, 02 Jan 2018 15:02:53 GMT

Probable cause: your SAS is not configured for UTF support, but the XML contains UTF characters.

Re: error while reading xml file

NK — Fri, 30 Nov 2018 04:11:22 GMT

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