topic Re: read XML all rows once in SAS Programming

topic Re: read XML all rows once in SAS Programming https://communities.sas.com/t5/SAS-Programming/read-XML-all-rows-once/m-p/332143#M272019 <PRE> Once you got these tables, you can combine them all together into a table. filename x temp; libname xx xmlv2 '/folders/myfolders/temp.xml' xmlmap=x automap=replace; data want; set xx.item: ; run; </PRE> Mon, 13 Feb 2017 12:40:18 GMT Ksharp 2017-02-13T12:40:18Z read XML all rows once https://communities.sas.com/t5/SAS-Programming/read-XML-all-rows-once/m-p/332128#M272018 <P>Can you please assist.</P><P> </P><P>Below is a sample from an xml we are trying to read. We don’t have the mapper for it and any other for that matter.</P><P>Currently we run a library pointing to the http file as below. We then run a proc dataset which gives us the datasets that are in the library. Each <item#> tags are basically rows which SAS interprets as a dataset. So if there are 1000 rows (<item0> to <item999>), it means there would be 1000 datasets to read, and hence means hitting the database a 1000 times. </P><P> </P><P>Could you please help us with a better way of reading this, hopefully a way that will allow us to read all rows once.</P><P> </P><P>Libname wsdl xml92 "<A href="http://ncss/Webservice/capacity/method/xml/day/&DATE" target="_blank">http://ncss/Webservice/capacity/method/xml/day/&DATE</A>";</P><P> </P><P><?xml version="1.0"?></P><P><A href="http://ncss/Webservice/capacity/method/xml/day/2016-10-06" target="_blank"><response></A><A href="http://ncss/Webservice/capacity/method/xml/day/2016-10-06" target="_blank"><item0></A><Day>2016-10-06</Day><Period>0</Period><LoadForecast>0</LoadForecast><RevisedForecast>0</RevisedForecast><DayAheadAvail/><HydroAvail>0</HydroAvail><AdditionalHydro>0</AdditionalHydro><OCGTAvail>0</OCGTAvail><MaxAvail>0</MaxAvail><MinCapacity>0</MinCapacity><ActualSentout>22008</ActualSentout><RequiredInst>700</RequiredInst><RequiredReg>600</RequiredReg><RequiredTmr>700</RequiredTmr><RequiredInstActual>0</RequiredInstActual><RequiredRegActual>0</RequiredRegActual><RequiredTmrActual>0</RequiredTmrActual><DayAheadAdditionalSpinning>0</DayAheadAdditionalSpinning><TotalCurrentLoadLosses>-3503</TotalCurrentLoadLosses><TotalLoadLosses>-3503</TotalLoadLosses><TotalUnplanned>-665</TotalUnplanned><TotalAdditional>1600</TotalAdditional><TotalDeviation>-2568</TotalDeviation><TotalUnitDeviations>-665</TotalUnitDeviations><OperatingRsv>-2568</OperatingRsv><Surplus>-2568</Surplus><Colour>Red</Colour><SPAN></</SPAN><SPAN>item0></SPAN><A href="http://ncss/Webservice/capacity/method/xml/day/2016-10-06" target="_blank"><item1></A><Day>2016-10-06</Day><Period>1</Period><LoadForecast>0</LoadForecast><RevisedForecast>0</RevisedForecast><DayAheadAvail/><HydroAvail>0</HydroAvail><AdditionalHydro>0</AdditionalHydro><OCGTAvail>0</OCGTAvail><MaxAvail>0</MaxAvail><MinCapacity>0</MinCapacity><ActualSentout>21684</ActualSentout><RequiredInst>700</RequiredInst><RequiredReg>600</RequiredReg><RequiredTmr>700</RequiredTmr><RequiredInstActual>0</RequiredInstActual><RequiredRegActual>0</RequiredRegActual><RequiredTmrActual>0</RequiredTmrActual><DayAheadAdditionalSpinning>0</DayAheadAdditionalSpinning><TotalCurrentLoadLosses>-3518</TotalCurrentLoadLosses><TotalLoadLosses>-3518</TotalLoadLosses><TotalUnplanned>-665</TotalUnplanned><TotalAdditional>1600</TotalAdditional><TotalDeviation>-2583</TotalDeviation><TotalUnitDeviations>-665</TotalUnitDeviations><OperatingRsv>-2583</OperatingRsv><Surplus>-2583</Surplus><Colour>Red</Colour><SPAN></</SPAN><SPAN>item1></SPAN><SPAN> </SPAN><SPAN></response></SPAN></P><P><SPAN> </SPAN></P><P><SPAN>Regards,</SPAN></P><P><SPAN>Thokozani</SPAN></P> Mon, 13 Feb 2017 11:29:12 GMT https://communities.sas.com/t5/SAS-Programming/read-XML-all-rows-once/m-p/332128#M272018 Thokozani1 2017-02-13T11:29:12Z Re: read XML all rows once https://communities.sas.com/t5/SAS-Programming/read-XML-all-rows-once/m-p/332143#M272019 <PRE> Once you got these tables, you can combine them all together into a table. filename x temp; libname xx xmlv2 '/folders/myfolders/temp.xml' xmlmap=x automap=replace; data want; set xx.item: ; run; </PRE> Mon, 13 Feb 2017 12:40:18 GMT https://communities.sas.com/t5/SAS-Programming/read-XML-all-rows-once/m-p/332143#M272019 Ksharp 2017-02-13T12:40:18Z