Missing seq should be replaced from observation which has visit as visit1 and seq ne missing. That seq number should be retained to the seq number which has missing seq and visit as visit1 ... View more

Hi Kurt, This will not work as seq is not from visit and it will change as the data goes on and different from visit information ... View more

Sorry this was the data i have and need seq to have value retained if it is missing. It needs to be replaced from visit1 value. in this case it should be 1. data WORK.MYDATA; infile datalines dsd truncover; input F1:$6. F2:32. F3:$6. F4:$5. F5:$24. F6:$5. F7:32. F8:DATE9.; datalines4; usubj,,day,value,visit,study,, HED101,0,Day 0,20.2,Visit 1 (Screening),NN11,1,30NOV2017 HED101,28,Day 28,20.2,Visit 6 (End of Week 4),NN11,34,12JAN2018 HED101,,,20.2,,NN11,34, HED101,56,Day 56,20.2,Visit 10 (End of Week 8),NN11,61,07FEB2018 HED101,84,Day 84,20.2,Visit 1 (timeH),NN11,1,06MAR2018 HED101,84,Day 84,20.2,Visit 12 (measure),NN11,76,07MAR2018 HED101,,,20.2,,NN11,76, HED101,0,Day 0,20.2,Visit 6 (End of Week 4),NN11,34,12JAN2018 HED101,28,Day 28,20.2,Visit 10 (End of Week 8),NN11,61,07FEB2018 HED101,56,Day 56,20.2,Visit 1 (timeH),NN11,1,06MAR2018 HED101,56,Day 56,20.2,Visit 12 (measure),NN11,76,07MAR2018 HED101,,,20.2,,NN11,76, HED101,0,Day 0,20,Visit 1 (timeH),NN12,, ;;;;   Edit: no need to use an attachment for this rather short code; moved attachment into code window ... View more

It somehow does'nt work if i use the below code. ot sure where i am doing wrong. proc sort data=WORK.FILTER_FOR_ADLB_SAS7BDAT_0003 out=inh(keep=usubjid paramcd base chg aval studyid2 visitnum visit); by usubjid paramcd visit; run; data want (drop=lst_base lst_chg); set inh; retain lst_base lst_chg; by paramcd; if first.paramcd and visitnum=10 and aval ne . and studyid2="0A23" then do; lst_base=base; lst_chg=chg; end; else do; data:   if base=. then base=lst_base; if chg=. then chg=lst_chg; end; run; usubjid paramcd aval base chg visit visitnum studyid2 101 Bio 45 42 3   . 0A23 101 Bio 43 42 1   . 0A24 101 Bio 45 . .   . 0A23 101 Bio 43 . .   . 0A24 101 Bio 43 45 -2   . 0A24 101 Bio 43 42 1 Unscheduled 5.1 0A24 101 Bio 43 . . Unscheduled 5.1 0A24 101 Bio 43 45 -2 Unscheduled 5.1 0A24 101 Bio 45 45 . Visit 1 (Baseline Extension A) 1 0A24 101 Bio 42 42 . Visit 1 (Screening) 1 0A23 101 Bio 48 42 6 Visit 10 (End of Week 😎 10 0A23 101 Bio 48 . . Visit 10 (End of Week 😎 10 0A23 101 Bio 45 42 3 Visit 12 (Completion/Withdrawal) 12 0A23 101 Bio 45 . . Visit 12 (Completion/Withdrawal) 12 0A23 101 Bio 45 42 3 Visit 6 (End of Week 4) 6 0A23 101 Bio 45 . . Visit 6 (End of Week 4) 6 0A23   ... View more

I get like the below - but i need to get in the same row for usubjid and visit and now it is coming as step wise USUBJID AVISIT AAGE ASEXN chg_pdq base_pdq chg_wlq base_wlq base_qids base_cgis ATWORC-CA003-001 Week 4 42 1 -8 60         ATWORC-CA003-001 Week 8 42 1 12 60         ATWORC-CA003-001 Week 12 42 1 6 60         ATWORC-CA003-001 Week 26 42 1 -14 60         ATWORC-CA003-001 Week 39 42 1 -25 60         ATWORC-CA003-001 Week 52 42 1 -19 60         ATWORC-CA003-001 Week 4 42 1         21   ATWORC-CA003-001 Week 8 42 1         21   ATWORC-CA003-001 Week 12 42 1         21   ATWORC-CA003-001 Week 26 42 1         21   ATWORC-CA003-001 Week 39 42 1         21   ATWORC-CA003-001 Week 52 42 1         21   ATWORC-CA003-001 Week 4 42 1     0,090212 20,35572     ATWORC-CA003-001 Week 8 42 1     -1,11479 20,35572     ATWORC-CA003-001 Week 12 42 1     -3,19786 20,35572     ATWORC-CA003-001 Week 26 42 1     -5,73216 20,35572     ATWORC-CA003-001 Week 39 42 1     -4,19237 20,35572     ATWORC-CA003-001 Week 52 42 1     -2,90292 20,35572     ... View more

It wont work. I get output for each group and the next condition creates in next   ... View more