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.
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.
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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.