topic How to create sas dataset from XML file (without using xml Engine ) in SAS Procedures

How to create sas dataset from XML file (without using xml Engine )

jonam — Wed, 14 Dec 2011 20:19:29 GMT

Hi,

Is there any way we can create datasets from XML file without using XML engine? I don't have xml engine.

What is the easiest and best method to create sas datasets from xml file using base sas?

How to create sas dataset from XML file (without using xml Engine )

FriedEgg — Wed, 14 Dec 2011 20:23:40 GMT

The XML LIBNAME Engine is a part of Base SAS since at least version 8.2

How to create sas dataset from XML file (without using xml Engine )

jonam — Wed, 14 Dec 2011 20:42:40 GMT

Really....I'm using SAS 9.1. I checked it by running proc setinit; run; I didn't see xml engine.

How can i use the xml libname engine in base sas.

Thanks a ton for your quick responese.

How to create sas dataset from XML file (without using xml Engine )

FriedEgg — Wed, 14 Dec 2011 21:13:12 GMT

It is not a licenced product, it is just part of Base SAS so you will not see it listed by proc setinit.

Try running this.

filename yt url 'http://gdata.youtube.com/feeds/api/videos/pzI4D6dyp_o/comments?v=2&max-results=50&start-index=1';

libname ytube xml xmlfileref=yt;

data ytube;

set ytube.entry;

run;

This is without defining a proper xml map for this feed so it is not perfect, just to show you that you can use xml engine.

Re: How to create sas dataset from XML file (without using xml Engine )

Cynthia_sas — Wed, 14 Dec 2011 21:27:29 GMT

Hi:

Since the XML Libname Engine is part of Base SAS, you won't see it in PROC SETINIT. (you don't see PROC PRINT, FREQ or MEANS in SETINIT either, but you can still use them).

OK...let's assume that you have an XML file stored in c:\temp\giftidea.xml (as shown in the attached screenshot). Then this code (in 9.2 or higher) would read the XML file into a SAS dataset:

** for 9.2;
/* libname giftxml xml92 'c:\temp\giftidea.xml'; */


** for 9.1.3;
libname giftxml xml 'c:\temp\giftidea.xml';

proc contents data=giftxml._all_;
run;

data mygifts;
   set giftxml.giftidea;
run;

proc print data=work.mygifts;
run;

libname giftxml clear;

If your data are not in a simple structure, as defined in the doc for the Libname Engine, then you would have to use an XML Map file to map from more hierarchical XML to SAS dataset form.

cynthia