I have a file with a case number that is sporadically filled in. The file is 500k plus rows, If the next time a case # is filled in happens to be the same case # as before I want to fill in the blanks. I thought of using lag() but some of the missing rows are pretty large. If the next case # populated is different the rows between should be left blank.
data have; infile cards dsd; input case$ ; cards; 500 , , , 500 , 600 , , 700 700 , 700 ; run;
data want; infile cards dsd; input case$ ; cards; 500 500 500 500 500 , 600 , , 700 700 700 700 ; run;
... View more