Prev: using proc export/dbms=xls and excel lost date format
Next: Reading an XML parsed file
From: Wendi Wright on 27 Feb 2010 09:05
I need to read in an XML file that comes all in one string (one line). The
current string I am using is currently at length 968,273 and could easily be
longer. We will be receiving these strings from an MQ server on our
mainframe - we are fetching them to the PC and this is how they appear. The
example below (with three records) is only length 3830. I am wondering what
would be the best way to read this in. I want to use only a single data
step (at most) and have one record per item (there may be multiple items per
GRResolvedRequest - see <ItemLst> that repeats. I have not used the XML
Mapper before, is this a good option?

Just imagine the following all on one line:
<GRResolvedRequest ReqID="00036"
ReqEndpoint="http://mcsdoas13.mhe.mhc:22411/ESMWebService/GRResolvedService"
FinalRC="0"><ReqGrpLst><ReqGrpDet
ReqGrpID="PCTRITE0036010000000000009"><ItemLst><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="044"
DelElementID="1208711" ItemRawRsp="480" DelItemID="01104879"
ItemParsed="480" ItemValue=" 480.0000" ItemRWO="R" ItemStatus="S"
GRRuleIDs="2,3,4,5,6,7,8,9,10,13"></ItemDet><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="045"
DelElementID="1208713" ItemRawRsp=" " DelItemID="01104975" ItemParsed=""
ItemValue=" .0000" ItemRWO="O" ItemStatus=" "
GRRuleIDs="2,3,4,5,6,7,8,9,10,13"></ItemDet><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="044"
DelElementID="1209372" ItemRawRsp="8" DelItemID="01105810" ItemParsed="8"
ItemValue=" 8.0000" ItemRWO="R" ItemStatus="1"
GRRuleIDs="2,3"></ItemDet><ItemDet DocComCD="2152701" TstID="CUSTOM-West
Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="045" DelElementID="1209374"
ItemRawRsp=" " DelItemID="01105812" ItemParsed="" ItemValue=" .0000"
ItemRWO="O" ItemStatus=" "
GRRuleIDs="2,3"></ItemDet></ItemLst></ReqGrpDet></ReqGrpLst></GRResolvedRequest><GRResolvedRequest
ReqID="00037"
ReqEndpoint="http://mcsdoas13.mhe.mhc:22411/ESMWebService/GRResolvedService"
FinalRC="0"><ReqGrpLst><ReqGrpDet
ReqGrpID="PCTRITE0037010000000000009"><ItemLst><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="044"
DelElementID="1208711" ItemRawRsp="480" DelItemID="01104879"
ItemParsed="480" ItemValue=" 480.0000" ItemRWO="R" ItemStatus="S"
GRRuleIDs="2,3,4,5,6,7,8,9,10,13"></ItemDet><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="045"
DelElementID="1208713" ItemRawRsp="225" DelItemID="01104975"
ItemParsed="225" ItemValue=" 225.0000" ItemRWO="R" ItemStatus="S"
GRRuleIDs="2,3,4,5,6,7,8,9,10,13"></ItemDet><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="044"
DelElementID="1209372" ItemRawRsp="8" DelItemID="01105810" ItemParsed="8"
ItemValue=" 8.0000" ItemRWO="R" ItemStatus="1"
GRRuleIDs="2,3"></ItemDet><ItemDet DocComCD="2152701" TstID="CUSTOM-West
Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="045" DelElementID="1209374"
ItemRawRsp="15" DelItemID="01105812" ItemParsed="15" ItemValue=" 15.0000"
ItemRWO="R" ItemStatus="1"
GRRuleIDs="2,3"></ItemDet></ItemLst></ReqGrpDet></ReqGrpLst></GRResolvedRequest><GRResolvedRequest
ReqID="00038"
ReqEndpoint="http://mcsdoas13.mhe.mhc:22411/ESMWebService/GRResolvedService"
FinalRC="0"><ReqGrpLst><ReqGrpDet
ReqGrpID="PCTRITE0038010000000000009"><ItemLst><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="044"
DelElementID="1208711" ItemRawRsp="480" DelItemID="01104879"
ItemParsed="480" ItemValue=" 480.0000" ItemRWO="R" ItemStatus="S"
GRRuleIDs="2,3,4,5,6,7,8,9,10,13"></ItemDet><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="045"
DelElementID="1208713" ItemRawRsp="225" DelItemID="01104975"
ItemParsed="225" ItemValue=" 225.0000" ItemRWO="R" ItemStatus="S"
GRRuleIDs="2,3,4,5,6,7,8,9,10,13"></ItemDet><ItemDet DocComCD="2152701"
TstID="CUSTOM-West Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="044"
DelElementID="1209372" ItemRawRsp="8" DelItemID="01105810" ItemParsed="8"
ItemValue=" 8.0000" ItemRWO="R" ItemStatus="1"
GRRuleIDs="2,3"></ItemDet><ItemDet DocComCD="2152701" TstID="CUSTOM-West
Virginia" TstFmCD="A" TstLvlCD="13" ItemNum="045" DelElementID="1209374"
ItemRawRsp="15" DelItemID="01105812" ItemParsed="15" ItemValue=" 15.0000"
ItemRWO="R" ItemStatus="1"
GRRuleIDs="2,3"></ItemDet></ItemLst></ReqGrpDet></ReqGrpLst></GRResolvedRequest>
 | 
Pages: 1
Prev: using proc export/dbms=xls and excel lost date format
Next: Reading an XML parsed file