感觉sql做不了

proc sql;
  select * from dataset

sorry, did not finish.

proc sql;
  select * from ds
  having count(*) gt 1
group by id;
quit;

还是用data step慢慢做吧

这个可行吗？count（*）是什么意思

data a;
input x$11.;
cards;
1,1,2,3,2,4
2,3,2,3,5,6
3,6,8,8,9,0
;run;
%macro a(no);
%do n=1 %to &no;
x&n=scan(x,&n,',')+0;
%end;
%mend a;
data b(drop=x);
set a;
%a(6);
run;
proc transpose data=b out=c;
run;
%macro b(i);
%do n=1 %to &i;
proc sort data=c;
by col&n;
run;
proc sql;
create table col&n as
select distinct col&n from c;
quit;
%end;%mend b;
%b(3)
data me;
merge col1 col2 col3;
run;
proc transpose data=me out=tranpose;
run;
data want;
set tranpose;
array x(5) col1-col5;
do i=1 to 5;
if x(i)=. then x(i)='';
m=x(1)||','||x(2)||','||x(3)||','||x(4)||','||x(5);
m=compress(m,'.');
m=compress(m);end;
run;

这个可以，但是写的太长了，效率不高，希望能有更加优化的code。

data have;
   a ="2, 2, 3, 3, 4   "; output;
   a ="2, 3, 3, 4, 5, 5"; output;
   a ="3, 6, 8, 8, 9, 0"; output;
run;

data have1;
   set have;
   do i = 1 to countw(a);
    b1 = scan(a,i);
    output;
   end; drop i;
run;

proc sql;
    create table have2 as
    select distinct a, b1
    from have1
    group by a
    order by a, b1;
quit;

data wanted;
    set have2;
    by a;
      length b $20;
      retain b;
    if first.a then b=b1;
    else b = cats(b, ",", b1);
    if last.a then output;
    drop b1;
run;

果然好用

这样是对一个ID有多条记录的处理，好像理解错了，貌似不能解决lz的问题。

对每个ID count 记录的个数

你这个比较好懂，请问countw（）函数是什么意思

计数字符串中单词的个数