How to import XML file from website

[damiankowalik]

Hi everyone,

I encountered a problem while importing XML file from website. Code:

filename test url 'https://www.nbp.pl/kursy/xml/a027z190207.xml';
libname test xml;

proc copy in=test out=work; 
run;

proc print;
run;

The code above causes an error:

As I understand the problem is with handshake/certification. To handle it I found a new source that uses api:

filename test url 'http://api.nbp.pl/api/exchangerates/tables/A/?format=xml';
libname test xml;

proc copy in=test out=work; 
run;

proc print;
run;

It causes an error suggesting usin XMLMap. Would you be able to help? I know that it could be done in Python or R, but I would really like to use SAS on this. Thank you in advance.

[ChrisBrooks]

Do you have the XML Mapper application installed? If you do or can install it then you'll find it normally makes creating an XML Map quite an easy process. If not then you'll have to hand-craft one yourself but you'd need to understand how the XML is structured and how you want it to be represented in your Sas Data Set which is a bit more challenging.

There's a good paper on it here -> https://www.lexjansen.com/nesug/nesug10/ff/ff14.pdf which is from 2010 but I don't think the Mapper application has changed much if at all since then.