XML LIBNAME reading data from URL

olearczuk — Wed, 11 Jul 2018 13:42:11 GMT

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&docsetVersion=9.4&locale=pl

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.

Re: XML LIBNAME reading data from URL

Satish_Parida — Thu, 02 Aug 2018 11:33:23 GMT

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.

Re: XML LIBNAME reading data from URL

KevinViel — Tue, 25 Jan 2022 03:17:38 GMT

Great tip! This helped me a lot right now.

topic XML LIBNAME reading data from URL in SAS Programming

XML LIBNAME reading data from URL

Re: XML LIBNAME reading data from URL

Re: XML LIBNAME reading data from URL