Hi, I've have a lot of XML files that have "hidden" credit bureau data that I want to extract. Each XML file represents a customer of ours that contains info like address info/employer info/deal structure info/etc. The credit bureau data is "hidden" in one of the attributes of one of the root elements. This data is extremely useful to my company and I want to be able to extract it. I tried importing the entire xml file (using XML mapper) into SAS but the credit bureau data gets truncated because it's much longer than the max characters aloud. So, I can't even read the data into SAS to try to parse that field out later on. Can someone give me some ideas on how to solve this issue? Is there a way to read this field directly into SAS without the other surrounding data? Not sure how to go about this. Below is an example of the data I'm working with. The raw_xml data is the "hidden" data (in bold) (Often over 100,000 characters). Removed 99% of the data but just wanted to give you an idea of the structure that I'm working with. Hope this makes sense. Appreciate any help/advice. I use Base SAS and xmlv2 to read in the data. <DealDetails> <cash_down="1000.00" net_trade="0.00" updated_by="" bundle_id=""/> </DealDetails> <Customers> <age="28" create_date="2017-09-30T11:04:47.0000000"> <Reports> <Report active="True" valid="True" bureau="TU" raw_xml="<Response Score="700"><creditBureau><document>response</document><version>2.18</version><transactionControl>< . . . . </printImage></product></creditBureau></Response>" create_date="" update_date="" updated_by="System [No User Available]"deal_detail_id="" bundle_id=""/> </Reports>
... View more