Using PROC Template Tagset for XML Export

[mahesh146]

Hi Guys,

I am looking into use of PROC Template with Define Tagset  option for exporting SAS datasets into XML files. The online materials are quite explanatory in terms the commands to be used and syntax to be followed for the same. 

However, I am unable to get below things.

1. How would the programmer decide the sequence of events to be created?

2. Is events name just like variable name where user can use any name as per convenience? If not, is there any online resource where I can find the event names and their use?

3. How events gets executed and mapped to the dataset to print values in XML?

I look forward to your responses.

Thanks,

Mahesh

[RW9]

Why bother, SAS already provides a libname to xml:

http://support.sas.com/documentation/cdl/en/movefile/59598/HTML/default/viewer.htm#a002576292.htm

[mahesh146]

Thanks for the link. I had already explored that one. 🙂

The problem is that we need XML file in specific format with more than 4 level of hierarchies which can be achieved through custom tagset. So looking for the answers on PROC Template.

[RW9]

Perhaps an xmlmap could work then?

http://support.sas.com/resources/papers/proceedings17/1318-2017.pdf

I don't actually know of any resource to show how to create tagsets for proc template, I did look myself sometime back and couldn't find anything.  You can glean things from looking at what has been written already, i.e. tagsets.excelxp and rtf and such like.  That gives a good view on it.  really could use a good paper on the subject though I agree.

[ballardw]

---

@mahesh146 wrote:

Thanks for the link. I had already explored that one. 🙂

The problem is that we need XML file in specific format with more than 4 level of hierarchies which can be achieved through custom tagset. So looking for the answers on PROC Template.

---

Admittedly the tagsets.excelp has bunch of Microsoft centric verbiage but find the excelxp.tpl file (basically the template code) and that may give some starting point.

It sure seems that every "wonderful" XML use seems to come with a "and here's where to buy the tool to make/use the wonderful format" pitch.