I have a data set in an XML file with a format similar to the sample below.   <?xml version="1.0" encoding="UTF-8"?> <PEOPLE xmlns:HOME="http://sample.url.org/home" xmlns:IP="http://sample.url.org/ip" xmlns:WORK="http://sample.url.org/work"> <PERSON> <NAME>Joe Smith</NAME> <HOME:ADDRESS>1234 Elm Street</HOME:ADDRESS> <HOME:PHONE>999-555-0011</HOME:PHONE> <WORK:ADDRESS>2001 Office Drive, Box 101</WORK:ADDRESS> <WORK:PHONE>999-555-0101</WORK:PHONE> <IP:ADDRESS>192.168.1.1</IP:ADDRESS> </PERSON> … <PERSON> <NAME>Pat Perkinson</NAME> <HOME:ADDRESS>1395 Half Way</HOME:ADDRESS> <HOME:PHONE>999-555-0033</HOME:PHONE> <WORK:ADDRESS>2001 Office Drive, Box 103</WORK:ADDRESS> <WORK:PHONE>999-555-0103</WORK:PHONE> <IP:ADDRESS>10.0.1.1</IP:ADDRESS> </PERSO      I am looking to create a SAS data set where the Name is stored in one column, the Home Address and Phone number are stored together in a single column and the Work Address and Phone are stored together in a single column. I have an output XML mapping document that I used to create the XML data set in the first place. Is there any way to modify that to read the data back into SQL as combined columns? ... View more