topic How to parse 'messy' data? in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/How-to-parse-messy-data/m-p/10875#M38 <HTML><HEAD></HEAD><BODY><P>This question will get more exposure in "SAS Macro facility, Data step" section than this section.&nbsp; It will also help if you could illustrate what is the desired outcome from this data.</P></BODY></HTML> Fri, 16 Sep 2011 16:54:07 GMT DLing 2011-09-16T16:54:07Z How to parse 'messy' data? https://communities.sas.com/t5/SAS-Data-Science/How-to-parse-messy-data/m-p/10874#M37 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I have some semi-structured text files that I'm trying to read into SAS v9.1.3. An example is shown below in <SPAN style="color: #0000ff;">blue.</SPAN></P><P>The column headings are listed above the dashed line and the data blocks are below the line. I'm not sure how to parse the data into a table structure. Any suggestions would be greatly appreciated.</P><P></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Daily Report for 08SEP11</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Printed on 09SEP11 at EST 07:19:00</SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Page&nbsp; 1</SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff;">Tran No&nbsp; R Company Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DB/CR Amount&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DB Curr Date/Time Appv'd</SPAN></P><P><SPAN style="color: #0000ff;">Tran ID&nbsp; N Payment Method&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Transfer Amount&nbsp;&nbsp;&nbsp; CR Curr Date/Time Prnt'd</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FX Rate</SPAN></P><P><SPAN style="color: #0000ff;">-------- - ------------------------ ------------------ -- ---- ----------------</SPAN></P><P><SPAN style="color: #0000ff;">2510001&nbsp;&nbsp;&nbsp; READING RAINBOW&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 375.50 DB&nbsp; USD 08SEP11 07:11:22</SPAN></P><P><SPAN style="color: #0000ff;">SUPERXFER R book&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08SEP11 15:47:00</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08SEP11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * PENDING *</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Debit account number:&nbsp; 3333333333</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Credit bank aaa:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 12345678</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Credit acct number: 1111111111</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Credit acct name:&nbsp;&nbsp; IRA FLEXIBLE SPENDING ACCOUNT</SPAN></P><P></P><P></P><P><SPAN style="color: #0000ff;">2510002&nbsp;&nbsp;&nbsp; BABY SUPERSTORE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 175,000.00 DB&nbsp; USD 08SEP11 07:20:31</SPAN></P><P><SPAN style="color: #0000ff;">BSUPER001 N Fedwire Out Interface&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08SEP11 08:20:40</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 08SEP11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * CONFIRMED *</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Debit account number:&nbsp; 2222222222</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Receiving bank aba:&nbsp;&nbsp;&nbsp; 234567898</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Credit account number: 2222-1111111-7</SPAN></P><P><SPAN style="color: #0000ff;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Credit account name:&nbsp;&nbsp; IND OPSE</SPAN></P></BODY></HTML> Fri, 16 Sep 2011 15:16:33 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-parse-messy-data/m-p/10874#M37 Mr_Breeze 2011-09-16T15:16:33Z How to parse 'messy' data? https://communities.sas.com/t5/SAS-Data-Science/How-to-parse-messy-data/m-p/10875#M38 <HTML><HEAD></HEAD><BODY><P>This question will get more exposure in "SAS Macro facility, Data step" section than this section.&nbsp; It will also help if you could illustrate what is the desired outcome from this data.</P></BODY></HTML> Fri, 16 Sep 2011 16:54:07 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-parse-messy-data/m-p/10875#M38 DLing 2011-09-16T16:54:07Z How to parse 'messy' data? https://communities.sas.com/t5/SAS-Data-Science/How-to-parse-messy-data/m-p/10876#M39 <HTML><HEAD></HEAD><BODY><P>Okay, thanks. I'll post the question with the desired outcome in that section.</P></BODY></HTML> Fri, 16 Sep 2011 17:03:32 GMT https://communities.sas.com/t5/SAS-Data-Science/How-to-parse-messy-data/m-p/10876#M39 Mr_Breeze 2011-09-16T17:03:32Z