同问。这个问题一直纠结。。。

请给出具体数据

抱歉啊，新手，不知道发文需要给出具体的数字

已经解决了。分享给大家

先进行频数分析，生成另一个文件。再将前50的创建新文件。最后用select in来创建子文件集。

proc sql noprint;
        create table result_1 as select
         PROJECT_NAME,count(*) as number
         from comb
         group by  PROJECT_NAME;
quit;

rsubmit;
proc sort data=result_1;
        by descending number;
run;

data result;
        set result_1;
        if _n_<=50;
proc sql noprint;
        create table rank50 as select
        *
        from comb
        where PROJECT_NAME in (select PROJECT_NAME from result);
quit;

A simple freq weighted by expenditure amount will do it.

data t1;
   do i=1 to 50000;
      id=ceil(ranuni(123)*100);
          expenditure_amt=round(RAND('CHISQUARE', 1),0.01) ;
          output;
        end;
run;

proc freq data=t1 order=freq;
table id;
weight expenditure_amt;
run;