Skip rows and begin reading at certain interval

[sap1958]

Here are two sample files

Changes for 2001
Fee TestCode TestName EffDate Amt
C1 1125 M, Stanley 6/1/2001 300
C2 1126 C. Smith 5/1/2001 500

Changes for 2002

Fee TestCode TestName EffDate Amt

C1 1125 M, Stanle 6/1/2001 300
C2 1126 C, Smith 5/1/2001 500

1. In all instances I want to skip any spaces in the rows and begin reading data beginning with the word Fee. As you can see, in some cases data is underneath Fee. In some cases column Fee is separated by a row space. In addition, I notice that there is a row space at the beginning of the report so the data actually begins on line 2 with the words "Changes to" Is it as simple as using dlm = ' '; and will that work with suppressing rows with empty space. Desired output is
Fee TestCode TestName EffDate Amt
C1 1125 M, Stanley 6/1/2001 300
C2 1126 C. Smith 5/1/2001 500

 

[jj72uk]

Im sure there are some infile options that can do this, check out:

http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000146932.htm

For a dirty solution you could always do:

if testcode >1 then helper = 1;else helper = 0;

----

Next datastep

if helper = 0 then delete;

Not the best way, but as I'm sitting on the train...