topic How to create an XML file in SAS Programming

How to create an XML file

henrik_liebach — Thu, 15 Jun 2017 14:01:11 GMT

The Danish government (TAX) ask us to deliver one .XML file for each account a customer have.

Oure environment is:

Windows server 2008

SAS Enterprice client 7.1 64 bit.

I have two questions:

1) Is it possible to create an .xml file with the Basic SAS tools, as the one that is add as an exsempel?

2) If not, do I need a more advance SAS Tool to create a file like attach file? If Yes, can you suggest one or to tools and an ensample of script.

Thx in advance

/ Henrik

Re: How to create an XML file

RW9 — Thu, 15 Jun 2017 14:25:19 GMT

I don't know where my last reply got to. Anyways, you can use SAS to create basic XML output, see here for Google response 1:

http://support.sas.com/resources/papers/proceedings12/253-2012.pdf

how good it is I don't know.

What I would say is that XML is all text, so you can create any type of text output you like and apply tags and such like. E.g.:

data _null_;
  set sashelp.class end=last;
  file "want.xml";
  if _n_=1 then put "<start>";
  put cats("<name>",name,"</name>");
  if last then put "</start>";
run;