I have a data set that I'm working with that comes to me missing rows in random places. It looks something like this: Ref_No Loc Amnt 1 NM $50 2 WA $42 3 ND $71 4 ME $28 5 CA $93 6 CT $62 I've managed to read the data into SAS EG by telling the load editor to read to a specific column and row, but when I go to sort the data, in order to take out the blank rows using the following code, the program stops reading when it reaches a blank row which leaves out a whole bunch of data. proc sort data=work.original_file out=work.new_file;
by Ref_No;
where Ref_No ne .;
run; Any idea what I can use to remove the blank rows without the program cutting off rows below the blank ones? Thanks.
... View more