@wy110
Looks to me like XML formatted messages or something in this area.
The XML structures in your two examples are not as simple as you believe. That's not a simple table.
Below sample code which reads the first of your message. The result are 9 tables.
You will have to run this message by message and without the XSD it's going to take a bit to bring the data together.
data _null_;
file tmp;
infile datalines truncover;
input;
put _infile_;
datalines;
<personExport>
<personId>123456</personId>
<Id>123456</Id>
<XmlRecord>
<entityObject>
<person eprsId="123456" eprsVersion="0" moduleId="109">
<addresses>
<address locale="9e" type="yzN5D">
<stAddr1>4@Qd!qa4NW2@0-Eoe425</stAddr1>
<stAddr2>au@Uk</stAddr2>
<city>aZ?7zjWH?p</city>
<state>nb</state>
<postalCode>7LA@8SQd?e</postalCode>
<country>pTWWihi-xs</country>
</address>
</addresses>
<disabilityCodes>
<disabilityCode>466</disabilityCode>
<disabilityCode>802</disabilityCode>
</disabilityCodes>
<name>
<family>iNCkfiONdU</family>
<given>4-rOv9gdtG</given>
<middle>e</middle>
<suffix>95XRA2id@t</suffix>
</name>
<message>None</message>
</person>
</entityObject>
</XmlRecord>
</personExport>
;
run;
filename map temp;
libname test xmlv2 "%sysfunc(pathname(tmp))" automap=replace xmlmap="%sysfunc(pathname(map))";
... View more
