|
Hello all,
I hvae a text file having a format like below
FHQC 121
H 1234 A14
FHQC 123
D 1235 A14
D 1235 A15
FHQC 124
----------------------------
Date: blah blah
----------------------------
D 1236 A15
I wan to create a SAS data set that looks like the following
FHQC 121 H 1234 A14
FHQC 123 D 1235 A14
FHQC 123 D 1235 A15
FHQC 124 D 1236 A15
The problem is The lines after FHQC can be 1 or more. It is not a
fixed number of lines. And I
also want to ignore the lines in the middle like
----------------------------
Date
----------------------------
What is the easiest way of going about doing this. Appreciate your
input.
|