topic Re: How to pull an XML file? in SAS Programming

How to pull/generate an XML file?

jei — Tue, 14 Jun 2016 03:59:48 GMT

Hi!

I would like to ask if SAS have a tool to pull an XML file automatically OR are there scripts that can pull the XML file?

Thank you!

Re: How to pull an XML file?

Reeza — Tue, 14 Jun 2016 02:41:12 GMT

What do you mean by 'pull an XML file'? Are you trying to read it into a dataset?

If so, try the XML Mapper tool.

http://support.sas.com/documentation/cdl/en/engxml/64990/HTML/default/viewer.htm#n10gcahtsna7r7n1rbn3wcxk6zbh.htm

Re: How to pull an XML file?

jei — Tue, 14 Jun 2016 03:01:30 GMT

Hi @Reeza,

I already used an XML Mapper but what we want is to generate the XML file so that the data will update automatically

Re: How to pull an XML file?

Ksharp — Tue, 14 Jun 2016 03:04:53 GMT

filename xx temp;
libname xx xmlv2 '/folders/myfolders/LabReviewMicroSampleData.xml'  automap=replace xmlmap=xx;
proc copy in=xx out=work;
run;

Re: How to pull an XML file?

Reeza — Tue, 14 Jun 2016 03:49:09 GMT

So you have an XML file that your adding to? Please explain in detail what your trying to do. The terminology isn't clear to me, but XML isn't my area. However, I have used SAS to both create and read XML file.

Re: How to pull an XML file?

jei — Tue, 14 Jun 2016 03:58:24 GMT

Okay,here's the scenario. The XML file is from the Cisco Prime API. What I am doing in order to get the XML file is by right clicking and then "save page as...".

Now, what I am askin' / want to know is if there's a way in SAS in order to automatically generate the XML file.

Re: How to pull an XML file?

Reeza — Tue, 14 Jun 2016 04:37:34 GMT

Ok. So you want to automatically reference an XML file generated by an API. There should be a URL or http method to access the data.

See the links below, the second is probably closer to what you want.

http://blogs.sas.com/content/sasdummy/2012/12/18/using-sas-to-access-data-stored-on-dropbox/

http://support.sas.com/documentation/cdl/en/engxml/64990/HTML/default/viewer.htm#n1d4p29qcfovrxn1k4nalh0bz4n6.htm

Re: How to pull an XML file?

jei — Tue, 14 Jun 2016 07:22:42 GMT

Hi @Ksharp,

As what I understood of a copy procedure is that it only copies the files. May I ask if it can also generate the XML file?

Re: How to pull an XML file?

Ksharp — Tue, 14 Jun 2016 08:03:46 GMT

No. That is not going to genereate XML as you describe . I think you have to download XML file and import it into SAS .

Re: How to pull an XML file?

jei — Tue, 14 Jun 2016 08:44:52 GMT

Hi,

I followed the query

filename nhl url 'http://www.a.com/Nhl.xml';
filename map 'C:\My Documents\XML\Nhl.map';

libname nhl xml xmlmap=map;

proc copy indd=nhl outdd=work;
   select nhl;
run;

But the resulted data set has no rows as shown in the image below. Do you have any idea about it?

Re: How to pull an XML file?

Ksharp — Tue, 14 Jun 2016 08:53:39 GMT

If that is a HTML file , you don't need to transform it into XML , read HTML directly . Like :

filename x url 'http://www.sas.com';
data want;
 infile x recfm=n dlm='<>' ;
 input @'>' x : $2000. @@;
run;

Re: How to pull an XML file?

jei — Wed, 15 Jun 2016 02:36:15 GMT

Hi!

I used this script and I successfully generate an xml file.

FILENAME outfile "C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml";
LIBNAME source XML 'C:\Users\jgmanalo\Desktop\Sample1\From URL\outxml.xml';
PROC HTTP
 OUT = outfile
 URL = 'https://rbc-svr-pi/webacs/api/v1/data/ClientDetails?.full=true'
 METHOD = 'GET';
RUN;

The XML file that I want is this

But what I'm only getting is this

Is there something wrong with the script?

Thank you!

Re: How to pull an XML file?

Ksharp — Wed, 15 Jun 2016 05:28:41 GMT

Since you can download XML file, Try this code :

FILENAME outfile "C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml";
LIBNAME source XML 'C:\Users\jgmanalo\Desktop\Sample1\From URL\outxml.xml';
PROC HTTP
 OUT = outfile
 URL = 'https://rbc-svr-pi/webacs/api/v1/data/ClientDetails?.full=true'
 METHOD = 'GET';
RUN;


filename xx temp;
libname xx xmlv2 'C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml'  automap=replace xmlmap=xx;
proc copy in=xx out=work;
run;

Re: How to pull an XML file?

Reeza — Wed, 15 Jun 2016 05:41:39 GMT

Do you need to log in to the site to generate the XML file?

Re: How to pull an XML file?

jei — Wed, 15 Jun 2016 05:55:45 GMT

Hi,

I tried the code that you gave but an error occured

Re: How to pull an XML file?

Ksharp — Wed, 15 Jun 2016 06:06:10 GMT

That is encoding problem. Maybe try this :

FILENAME outfile "C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml" encoding='utf-8';

FILENAME outfile "C:\Users\jgmanalo\Desktop\Sample1\From URL\OutXML.xml" encoding='utf-16le';

Re: How to pull an XML file?

Reeza — Wed, 15 Jun 2016 06:06:58 GMT

Did you copy and paste? Sometimes the browsers add things. Try typing it out.

Re: How to pull an XML file?

jei — Wed, 15 Jun 2016 08:24:56 GMT

I typed it and I am also log in to the site

Re: How to pull an XML file?

jei — Wed, 15 Jun 2016 08:25:44 GMT

I try to add the UTF but still the error still the same

Re: How to pull an XML file?

Ksharp — Wed, 15 Jun 2016 08:50:20 GMT

Could attach a sample file , so we can test it ?