1# zhushji

data a;
input
ID x @;
z=_n_;
cards;
450001 15
450001 14
450002 12
450003 13
450012 18
450012 19
450104 18
450104 12
450104 15
;run;
proc sql ;
create table new1 as select * ,count(id) as count
from a group by id having count>=2 order by z;
alter table new1 drop z ,count;quit;
proc transpose data=new1 out=new2(drop=_name_) prefix=x;
by id;var x;run;

4# lion_li 这应该是对我的程序的修改了。请问什么理由呢？只是请教，没有冒犯的意思。



没有了prefix 选项，如何得到x1 x2 x3...呢？

proc sql;
   create table b as
   select Id, x
        from  
      (select Id, x, count(id) as N_id
           from a
       group by id
       having N_id >=2);
quit;