How to generate quantile from SAS Proc Univariate

 Today, I would introduce the simple code to generate the quantile of variables with SAS macro code.

%macro decile(tbl, var);

 /* noprint option means this procedure doesn't print the basic univariate statistics */

 proc univariate data = &tbl. noprint;

 /* Input variable you want to review */

   var &var.;

/* output dataset name

     pctlpre : percentile pre-naming, This is output variable name

     prctlpts : percentile plots, you can specify the interval of percentile

*/

   output out = &var. pctlpre = &var. pctlpts = 10 to 100 by 10;

 run;

%mend;

%decile(base.table, usage);

%decile(base.table, energy_util);