data have; input group a $ b c; datalines; 1 A 23 20 1 B 34 32 1 C 29 12 1 D 24 10 2 E 45 65 2 F 87 25 2 G 89 76 ; data want; set have; by group; if first.group then cnt=1; else cnt+1; run; proc sql; select * from want group by group having cnt>max(cnt)-2 order by group,cnt; quit; ... View more

This seems to be a tough using proc corr. Try proc anova or proc glm. ... View more

data have;    input acct_nbr $ custid $ date : date9.;    format date date9.; _custid=input(compress(custid,,'kd'),best.); mon=month(date); month=date; format month monyy7.; cards; a1            c11  20Jun2013 a1            c11  15Jul2013 a1            c12  08Aug2013 a1            c11  25Aug2013 a2            c21  20Jun2013 a2            c23  15Jul2013 a2            c21  08Aug2013 a2            c24  25Aug2013 a3            c31  20Jun2013 a3            c32  15Jul2013 a3            c31  08Aug2013 a3            c32  25Aug2013 a3            c31  30Aug2013 ;;;;    run; data want (keep=acct_nbr month shift); set have; by acct_nbr mon _custid notsorted; if first.acct_nbr and first.mon then shift=0; if not first.mon and _custid-lag(_custid) ne 0 then shift+1; if last.mon then output; run; proc tabulate data=want; class acct_nbr month; var shift; table acct_nbr=' ',month=' '*shift=' '*sum=' '/box='acct_nbr'; run; ... View more

Hi, Not sure about above macro logic. May be this can provide the desired output. data have; input id visit score; datalines; 1 1 12.5 1 2 20 2 2 26 ; data want; set have; by id; retain base_line; if first.id then base_line=score; change=score-base_line; run; ... View more

What is "same"  in where clause? ... View more

It will flag all observations starting from non missing date within each accnt. ... View more

data want;   set have;   by accnt;   if first.accnt then flag=0;   if not missing(date) then flag+1; run; proc sql; select accnt,avg(amnt) as average from want where flag=1 group by accnt; quit; ... View more

data have; input acct_nbr   $ custid $; _custid=input(compress(custid,,'kd'),best.); cards; a1            c11 a1            c11 a1            c12 a1            c11 a2            c21 a2            c23 a2            c21 a2            c24 a3            c31 a3            c32 a3            c31 a3            c32 a3            c31 ; data want (keep=acct_nbr change); set have; by acct_nbr _custid notsorted; if first.acct_nbr then change=0; if not first.acct_nbr and _custid-lag(_custid) ne 0 then change+1; if last.acct_nbr then output; run; ... View more