Hi, I need to fill upp missing values with previous. Usually I can fix it but not this time. Data have
input ID sjp_dgr;
cards;
1 77
1 .
1 .
1 .
1 54
1 27
1 66
2 .
2 972
2 .
2 .
2 .
3 28
3 24
3 31
3 1420
3 .
3 .
4 747
4 .
5 .
5 .
5 .
5 .
5 51
;
Run; data want;
set have;
retain sjp_dgr;
by id;
if not missing (sjp_dgr) then sjp_dgr_=sjp_dgr;
run;
The problem is that by filling upp missing values in this way the last value for ID 1 (66) becomes the first non missing value for ID 2, while I need that ID 2 keeps its missing value in its first record. A similar problem appears for ID 5 who has missing values originally until the first value appears (51) . In this case ID 4 last value (747) goes over to ID 5 which is not correct. All rows in the original data must remain, even it values are missing in some rows. This is becuase the real data inclues other columns where the values for those are not missing. thank!
... View more