How to get base variable in this figure

DR_Majeti — Sat, 07 Sep 2013 06:37:34 GMT

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

Re: How to get base variable in this figure

Jagadishkatam — Sat, 07 Sep 2013 07:41:49 GMT

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