topic Re: Import XML stored across multiple cells in Excel in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/Import-XML-stored-across-multiple-cells-in-Excel/m-p/736820#M38689 <P>Save this as a CSV file, then you can easily combine the 4th to 7th column while reading the CSV with a data step.</P> Sun, 25 Apr 2021 09:57:44 GMT Kurt_Bremser 2021-04-25T09:57:44Z Import XML stored across multiple cells in Excel https://communities.sas.com/t5/SAS-Enterprise-Guide/Import-XML-stored-across-multiple-cells-in-Excel/m-p/736817#M38688 <P>An export into excel has been created that has a number of regular fields, then an xml response stored across several cells.&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="kiddala_0-1619340233840.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/58659i133C0C4F95B23092/image-size/medium?v=v2&amp;px=400" role="button" title="kiddala_0-1619340233840.png" alt="kiddala_0-1619340233840.png" /></span></P><P>Is there a way to import this directly?&nbsp;</P><P>I haven't seen anything that deals with this specifically.&nbsp;</P><P>Cheers</P> Sun, 25 Apr 2021 08:49:19 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Import-XML-stored-across-multiple-cells-in-Excel/m-p/736817#M38688 kiddala 2021-04-25T08:49:19Z Re: Import XML stored across multiple cells in Excel https://communities.sas.com/t5/SAS-Enterprise-Guide/Import-XML-stored-across-multiple-cells-in-Excel/m-p/736820#M38689 <P>Save this as a CSV file, then you can easily combine the 4th to 7th column while reading the CSV with a data step.</P> Sun, 25 Apr 2021 09:57:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Import-XML-stored-across-multiple-cells-in-Excel/m-p/736820#M38689 Kurt_Bremser 2021-04-25T09:57:44Z