@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

Thank you sooo much!!! I was thinking too much!!! You are right! I even subsetted a giant data set to multiple datasets by their ID in order to print out them.   ... View more

Thank you for your help! I think your solution is the best way to output them! It has been a while I am still working on it. However, I have issues when I output all the person data sets with do loop... I can't use proc json, I use data step instead.  I create a new question here: https://communities.sas.com/t5/Base-SAS-Programming/how-to-print-multiple-data-sets-with-do-loop/td-p/387831   If you have a chance to look at it, I really appreciate it!  ... View more