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

[RandyStan]

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

0

2

4

0

6

7

0

5

1

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

VARA   Decile_Group

0               0

2

4

0               0

6

7

0              0

5

1       

And the remaining data can be grouped by deciles.

Please help

Thanx so much

Randy       

[Patrick]

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

[ChrisNZ]

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;