Data with multiple delimiters

jerry898969 — Tue, 11 Feb 2014 16:51:43 GMT

I have a text file I have to import. This file contains an id field and then html.

0000001^<tr><td>TEST1</td><td>01/01/01</td><td>FRANK</td></tr><tr><td>TEST2</td><td>01/02/01</td><td>DAVE</td></tr>

0000002^<tr><td>TEST1</td><td> </td><td>WILL</td></tr>

0000003^<tr><td>TEST1</td><td>02/11/12</td><td>JIM</td></tr><tr><td>TEST2</td><td>02/12/13</td><td>Greg</td></tr><tr><td>TEST3</td><td> </td><td> </td></tr>

I need to create a data file that will parse each row and create a multiple rows for every <tr></tr> combination. Based on the above data the results should be

0000001 TEST1 01/01/01 FRANK

0000001 TEST2 01/02/01 DAVE

0000002 TEST1 WILL

0000003 TEST1 02/11/12 JIM

0000003 TEST2 02/12/13 Greg

0000003 TEST3

Thank you for any help.

Re: Data with multiple delimiters

Reeza — Tue, 11 Feb 2014 17:50:08 GMT

Try googling with the search terms : SAS IMPORT HTML TABLE

There are a few papers and references that look promising, as well as a suggestion to use XML processing.

topic Data with multiple delimiters in SAS Procedures

Data with multiple delimiters

Re: Data with multiple delimiters