topic Looking for Example of Reading Spreadsheet from XML file in SAS Programming https://communities.sas.com/t5/SAS-Programming/Looking-for-Example-of-Reading-Spreadsheet-from-XML-file/m-p/151972#M29935 <HTML><HEAD></HEAD><BODY><P>In the past, I have created spreadsheets as .xml files, and then distributed them to appropriate individuals.</P><P></P><P>Now, I have a need to read data from an archive of these .xml files.</P><P></P><P>Does anyone have an example of SAS code to read spreadsheets from .xml files?</P></BODY></HTML> Fri, 09 May 2014 13:48:51 GMT PaigeMiller 2014-05-09T13:48:51Z Looking for Example of Reading Spreadsheet from XML file https://communities.sas.com/t5/SAS-Programming/Looking-for-Example-of-Reading-Spreadsheet-from-XML-file/m-p/151972#M29935 <HTML><HEAD></HEAD><BODY><P>In the past, I have created spreadsheets as .xml files, and then distributed them to appropriate individuals.</P><P></P><P>Now, I have a need to read data from an archive of these .xml files.</P><P></P><P>Does anyone have an example of SAS code to read spreadsheets from .xml files?</P></BODY></HTML> Fri, 09 May 2014 13:48:51 GMT https://communities.sas.com/t5/SAS-Programming/Looking-for-Example-of-Reading-Spreadsheet-from-XML-file/m-p/151972#M29935 PaigeMiller 2014-05-09T13:48:51Z Re: Looking for Example of Reading Spreadsheet from XML file https://communities.sas.com/t5/SAS-Programming/Looking-for-Example-of-Reading-Spreadsheet-from-XML-file/m-p/151973#M29936 <HTML><HEAD></HEAD><BODY><P>Maybe you can get somewhere with this but I don't know much about details. </P><P></P><P>Start with this XML map <A href="http://support.sas.com/kb/45/addl/fusion_45192_1_excelxp.map" title="http://support.sas.com/kb/45/addl/fusion_45192_1_excelxp.map">http://support.sas.com/kb/45/addl/fusion_45192_1_excelxp.map</A></P><P></P><P>You will need a libname to point to the XML with with XMLMAP option pointing to the file in the </P><P></P><P>libname MYXML xml "path-to-myxmlfile.xml" xmlmap="path-excelxp.map";</P><P></P><P>The try proc datasets or contents to see names of the objects in the library and work your way from there.</P></BODY></HTML> Sun, 11 May 2014 12:27:27 GMT https://communities.sas.com/t5/SAS-Programming/Looking-for-Example-of-Reading-Spreadsheet-from-XML-file/m-p/151973#M29936 data_null__ 2014-05-11T12:27:27Z