topic Re: Calculate Median, P10 and P90 in CAS in SAS Programming

Calculate Median, P10 and P90 in CAS

PaalNavestad — Wed, 24 Nov 2021 07:50:16 GMT

Hi, i have a 19 million row table for which I need to find the Median, P10 and P90 using several class/groupBy. The table is in CAS. In 9.4 this can easily be done with proc means. From the documentation I see that the percentile methods is not supported in Cas. Moving the table to The Spree server is really slow. I can't find anywhere in the documentation how I can do this in CAS. I tried Fedsql but that do not work?

Thanks

Re: Calculate Median, P10 and P90 in CAS

Rick_SAS — Wed, 24 Nov 2021 11:14:05 GMT

I would use PROC CAS to call the percentile action directly:

cas;   /* connect to CAS server */

/* load sample data */
proc casutil;
   load data=Sashelp.Cars casout='Cars' replace; /* use active caslib */
quit;

proc cas;
   percentile.percentile /
      table={name="Cars", 
             vars={"Cylinders", "MPG_City", "Weight"},
             groupby={"Origin"}
            }
      values={10, 50, 90}    /* specify percentiles */
      method = "Iterative"   /* faster than "exact" methods */
      ;
run;

Re: Calculate Median, P10 and P90 in CAS

PaalNavestad — Wed, 24 Nov 2021 11:33:03 GMT

Thanks a lot