https://communities.sas.com/t5/SAS-Data-Management/data-import/m-p/370977#M11226 <P>Thank you Tom for your suggestion.</P> <P>I've integrated the XML code in the original question.</P> <P>Hope this is more clear now.</P> Tue, 27 Jun 2017 15:40:16 GMT fre 2017-06-27T15:40:16Z https://communities.sas.com/t5/SAS-Data-Management/data-import/m-p/370911#M11222 <P>* deleted, not a good question&nbsp;*</P> Mon, 03 Jul 2017 10:44:48 GMT https://communities.sas.com/t5/SAS-Data-Management/data-import/m-p/370911#M11222 fre 2017-07-03T10:44:48Z https://communities.sas.com/t5/SAS-Data-Management/data-import/m-p/370925#M11223 <P>SAS has tools for parsing XML, but it assumes the XML is in a file and not in a variable.</P> <P>I would import the first spreadsheet and write the XML into a file and try importing that.</P> <P>&nbsp;</P> <P>PS. Your XLSX files are hard to view on the SAS website. The first one doesn't show the full XML in the column you mentioned and the second one doesn't render at all. You should just paste an example of the XML as text into your question (use the {i} icon to paste into a code box to preserve formatting) if you want help with how to parse it.</P> Tue, 27 Jun 2017 13:40:10 GMT https://communities.sas.com/t5/SAS-Data-Management/data-import/m-p/370925#M11223 Tom 2017-06-27T13:40:10Z https://communities.sas.com/t5/SAS-Data-Management/data-import/m-p/370977#M11226 <P>Thank you Tom for your suggestion.</P> <P>I've integrated the XML code in the original question.</P> <P>Hope this is more clear now.</P> Tue, 27 Jun 2017 15:40:16 GMT https://communities.sas.com/t5/SAS-Data-Management/data-import/m-p/370977#M11226 fre 2017-06-27T15:40:16Z