topic Re: Read XML URL from SAS EG in SAS Enterprise Guide

Read XML URL from SAS EG

JuanDaniel — Tue, 13 Feb 2018 17:47:33 GMT

Hi masters!

I'm trying to read an XML from an external URL, the code that i use is like this:

filename Archive url 'https://myURL?$format=xml'
User="USER" pass="PASS";
filename SXLEMAP 'C:\mapa.map';
libname Archive xml92 xmlmap=SXLEMAP access=readonly;

Well this code works properly and I have tables in the library but when I try to filter the table with a query i get the error:

ERROR: Some code points did not transcode.
occurred at or near line 1, column 954035
ERROR: XML parsing error. Please verify that the XML content is well-formed.

I create the map file with SAS XML mapper and the automatic option.

Kind regards

Re: Read XML URL from SAS EG

ChrisHemedinger — Tue, 13 Feb 2018 17:54:51 GMT

Instead of running queries directly on the XML libname, I'd use DATA step to create a copy as a SAS data set. Then run your filter on that.

data myxml;
  set Archive.myxml;
run;

Re: Read XML URL from SAS EG

JuanDaniel — Tue, 13 Feb 2018 19:22:48 GMT

Thanks @ChrisHemedinger

But i tried with the data step and I get the same error.

Kind regards

Re: Read XML URL from SAS EG

ChrisHemedinger — Tue, 13 Feb 2018 19:33:41 GMT

Might be an encoding mismatch. If you can use UTF-8 encoding in your SAS session, you might have better luck. Or take a look at the XML file (the column where the error was flagged) and see if it's an aberration -- something like a curly quote or some other character that really shouldn't be there. I'd use Notepad++ for something like that.

Re: Read XML URL from SAS EG

JuanDaniel — Tue, 13 Feb 2018 21:27:27 GMT

@ChrisHemedinger How can i use the UTF-8 in my SAS session?

I think i dont have 954035 colunms :S

Kind regards

Re: Read XML URL from SAS EG

ChrisHemedinger — Tue, 13 Feb 2018 22:20:51 GMT

I suspect that your XML file is being read as a huge 1-line mass, and the column number is really a character position. That's why I suggested Notepad++ -- it can handle large files and you can navigate to the 954,035th character position, see what's there.

Re: Read XML URL from SAS EG

JuanDaniel — Tue, 13 Feb 2018 22:41:34 GMT

Thanks!! @ChrisHemedinger

I change the encoding for the SAS session and it works!!!

Kind regards

Re: Read XML URL from SAS EG

JuanDaniel — Wed, 14 Feb 2018 10:51:30 GMT

@ChrisHemedinger

The change for use the encoding UTF-8 in the file sasv9.cfg affects to all sessions, there is any way to force only one project to UTF-8 encoding or for only one dataset?

Kind Regards