SAS generate XML file with header/arrays/footes

filgueira — Wed, 21 Jul 2021 18:40:29 GMT

Hy! Is it possible, using SAS with XML Mapper generate a XML with arrays. For example:

I have a table like that:

John, Chicago, receiptA, value1

John, Chicago, receiptB, value2

John, Chicago, receiptC, value3

Mary, Boston, receiptX, value8

Mary, Boston, receiptY, value9.

and I want a XML like that.

<city>Chicago</city>

<receipt>receiptA</receipt> <value>value1</value>

<receipt>receiptB</receipt> <value>value2</value>

<receipt>receiptC</receipt> <value>value3</value>

</receipts>

<city>Boston</city>

<receipt>receiptX</receipt> <value>value8</value>

<receipt>receiptY</receipt> <value>value9</value>

</receipts>

.....

Any help about that.

tks

Filgueira

Re: SAS generate XML file with header/arrays/footes

ChrisNZ — Wed, 21 Jul 2021 22:32:16 GMT

There might be a way, but you should just write a data step for such simple output if you get no replies, rather than dealing with XML Mapper.