How to get base variable in this figure

[DR_Majeti]

Please help how to get the BASE variable from AVAL variable ...

My concern is how to retain the base values for even above observation of basline in AVISIT

[Jagadishkatam]

hi Dr.Majeti,

i tried to explain with a sample data, hope it helps yo

data have;

    infile cards missover;

    input group visit$ aval ablfl $;

cards;

1 SCR   0

1 run   1

1 week0 2    Y

1 week1 1   

1 week2 4   

1 week3 5   

2 SCR   0

2 run   1

2 week0 3    Y

2 week1 1   

2 week2 4   

2 week3 5   

;

run;

proc sort data=    have;

    by group descending ablfl;

run;

data want;

    set have;

    by group descending ablfl;

    retain base;

    if ablfl='Y' then base=aval;

run;

proc sort data=    want;

    by group visit ablfl;

run;

Thanks,

Jagadish