XML LIBNAME reading data from URL

[olearczuk]

Hi,

i am attempting to read data in XML format from URL:

https://danepubliczne.imgw.pl/api/data/synop/format/xml

Unfortunately I can't method presented below to work.

http://documentation.sas.com/?docsetId=engxml&docsetTarget=n1d4p29qcfovrxn1k4nalh0bz4n6.htm&docsetVe...

My code is following

filename imgw url 'https://danepubliczne.imgw.pl/api/data/synop/format/xml';
filename map 'C:\imgw_map.map';
libname imgw xmlv2 xmlmap=map access=readonly;
data xml;
set imgw.item;
run;
proc contents data=xml;quit;

imgw_map was created in SAS XML Mapper using 'AutoMap using XML' on a download data file.

Code doesn't return any errors, imgw library is created with 2 files, but unfortunately those sets are empty (no observations).

Surprisingly using nearly identical code, but for downloaded data gives correct results.

filename imgw 'C:\imgw_synop.xml';
filename map 'C:\imgw_map.map';
libname imgw xmlv2 xmlmap=map access=readonly;
data xml;
set imgw.item;
run;
proc contents data=xml;quit;

Data set is frequently updated (weather data) and I would like my data to update itself automatically without manual downloads.

I am using SAS 9.4 in Enterprise Guide 7.11.

best regards.

[Satish_Parida]

The URL is a service returning the data which your browser is displaying.

To capture the data you have to use either proc http or proc soap.

I have added a code snippet for your reference.

filename resp "&WORKING_DIR./output.xml";
proc http 
url="&URL_ADVERSE." 
out=resp
METHOD='GET';
run;

Please let us know if it worked for you.

[KevinViel]

Great tip! This helped me a lot right now.