topic Re: How to grouping the values? in SAS Procedures

How to grouping the values?

thdang — Tue, 27 Nov 2012 21:25:03 GMT

Hallo, can someone please help how can I group the coef? I have a data set which look like this:

id coef

...........

It has n rows. The coef is sorted and I would like to splits them into 10 groups. The first group would have the first n/10 highest coef and the last group would have the latest n/10 lowest coef.

Thank you so much!

Re: How to grouping the values?

PGStats — Tue, 27 Nov 2012 23:36:37 GMT

Two ways to do this :

proc ranks data=have out=want groups=10 descending;
var coef;
ranks group;
run;

/* Assuming data have is sorted by coef */

data want;
set have nobs=ntot;
group= 10 - floor((_n_*10)/(ntot-1));
run;

Re: How to grouping the values?

thdang — Tue, 27 Nov 2012 23:54:10 GMT

Thank you. it works great