topic Grouping data into deciles and not counting the lowest value in the decile grouping in SAS Programming

Grouping data into deciles and not counting the lowest value in the decile grouping

RandyStan — Wed, 18 Mar 2020 03:37:14 GMT

Dear All

I want to split my data into deciles but not counting the lowest value into the decile grouping

So my data is as follows

VARA

So the data should be grouped by deciles but 0 should be omitted in the calculation of deciles

VARA Decile_Group

0 0

And the remaining data can be grouped by deciles.

Please help

Thanx so much

Randy

Re: Grouping data into deciles and not counting the lowest value in the decile grouping

Patrick — Wed, 18 Mar 2020 04:16:47 GMT

Did you already see this discussion? I believe @PGStats answer there is what you need.

Re: Grouping data into deciles and not counting the lowest value in the decile grouping

ChrisNZ — Wed, 18 Mar 2020 04:30:40 GMT

Like this?

data HAVE; 
 do I=0 to 100;
   output; 
  end; 
run;

proc rank data=HAVE(where=(I ne 0)) groups=9 out=RANK; 
  var I; 
  ranks GRP ;
run;
 
data WANT;
  set HAVE(where=(I eq 0))
      RANK(in=RANKED);
  GRP=sum(GRP,1)*RANKED;
run;