用EXCEL试试。

data test;
   input gvkey $  year $ data;
   cards;
aaaaaa 1984 83949
aaaaaa 1985 88888
aaaaaa 1986 99999
bbbbbb 1987 81111
bbbbbb 1988 23934
cccccc 2000 1123
dddddd 2009 9890
dddddd 2008 8900
dddddd 2010 8999
;

proc tabulate data=test out=a(where=(N<=2));
    class gvkey;
   table gvkey;
run;

proc sql noprint;
    select quote(strip(gvkey)) into :rm_list separated by "," from a;
quit;

data wanted;
     set test;
     if gvkey not in (&rm_list);
run;

假设原始数据集名为orig
proc sql;
        create table new as
        select *
        from orig
        group by gvkey
        having count(gvkey)>2;
quit;
proc print data=new;
run;