Desktop productivity for business analysts and programmers

Read XML URL from SAS EG

Accepted Solution Solved
Reply
Contributor
Posts: 73
Accepted Solution

Read XML URL from SAS EG

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


Accepted Solutions
Solution
‎02-13-2018 05:40 PM
Community Manager
Posts: 3,452

Re: Read XML URL from SAS EG

Posted in reply to JuanDaniel

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.

View solution in original post


All Replies
Community Manager
Posts: 3,452

Re: Read XML URL from SAS EG

[ Edited ]
Posted in reply to JuanDaniel

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;
Contributor
Posts: 73

Re: Read XML URL from SAS EG

Posted in reply to ChrisHemedinger

Thanks @ChrisHemedinger

 

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

 

Kind regards

Solution
‎02-13-2018 05:40 PM
Community Manager
Posts: 3,452

Re: Read XML URL from SAS EG

Posted in reply to JuanDaniel

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.

Contributor
Posts: 73

Re: Read XML URL from SAS EG

Posted in reply to ChrisHemedinger

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

 

I think i dont have 954035 colunms Smiley Frustrated

 

Kind regards

Community Manager
Posts: 3,452

Re: Read XML URL from SAS EG

Posted in reply to JuanDaniel

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.

Contributor
Posts: 73

Re: Read XML URL from SAS EG

Posted in reply to ChrisHemedinger

@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

 

Contributor
Posts: 73

Re: Read XML URL from SAS EG

Posted in reply to ChrisHemedinger

Thanks!! @ChrisHemedinger

 

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

 

Kind regards

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 280 views
  • 1 like
  • 2 in conversation