|
Hi lipty,
I dont know is it an optimal solution.but try it out.
Hope this helps
data test;
input year hospital branch $ N ;
cards;
1989 1 b1 22
1989 1 b2 23
1989 1 b3 22
1989 1 b4 24
1989 1 b5 24
1990 6 b1 55
1990 6 b2 33
1990 6 b4 77
1990 6 b5 33
1990 10 b2 66
1990 10 b3 66
1990 10 b4 66
1990 11 b2 67
1990 11 b3 67
1990 11 b4 67
;
run;
proc sort data=test out=test1;by year hospital n;run;
data final(keep = year hospital new);
set test1;
by year hospital n;
n1=lag(n);
if first.hospital then n1=.;
if lag(n1)=n then new=0;
else if last.hospital then new=1;
if last.hospital;
run;
Thanks,
shiva
| 
