When you run PROC MEANS with the THREADS option to calculate a median statistic, performance might be very slow. This occurs if the values of the variable are unique or close to unique. Performance is better if you run the procedure with the NOTHREADS option.

To work around this issue use the qmethod=p2, as in the following example:

   data huge;
    do i=1 to 100;
     do j=1 to 100;
      do k=1 to 100;
       x=ranuni(3);
       output;
      end;
     end;
    end;
   run;

   proc means data=huge noprint threads qmethod=p2;
   class i j k;
   output out=stat2 mean=mean median=median;
   run;

Operating System and Release Information