FREQ Table & Quantile

[apple]

I want a two-way table with income quantile in the row & X in the column

The  income quantile should be in the following ranges:

1st – 20th

21st – 40th

41st – 60th

61st – 80th

81st – 100th

How do I group the income into quantiles?

Thank you

[RichardinOz]

The quantiles in this case (5) are quintiles.

Investigate

     Proc Ranks groups =  5 data = have  out = want /*descending ? */;

          Var income ;

          Ranks income_group ;

     Run ;

[untested]

This will number your income values in groups labelled 0 - 4 (4 highest, use descending to reverse the numbering).  Add 1 to income_group to get labels 1 - 5.  Multiply by 20 if you want labels like 20, 40 60, 80.

Richard