To remove the initial missing values, build the steps dataset with:   data steps; retain day; set work.subject_: indsname=dsn curobs=d; subject = scan(dsn,2); if d = 1 then call missing(day); if missing(day) then do; if not missing(steps) then day = 0; end; if not missing(day) then do; day = day + 1; output; end; run; ... View more

Thank you! Both solutions worked perfectly! ... View more

Thanks so much! ... View more

a teaser fun i learned from genius PD's dazzle playing with  PDV . Don't use this, but play with it. It's a joy as it gives an intuition of how DOW works 🙂   data want1; if 0 then set have; visit=0; do until(last.id); visit+1; do until(last.date); set have; by id date; output; end; end; run;     ... View more

This worked perfectly! Thank you so much! ... View more