02-04-2014 02:00 AM
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?
02-04-2014 03:49 AM
The quantiles in this case (5) are quintiles.
Proc Ranks groups = 5 data = have out = want /*descending ? */;
Var income ;
Ranks income_group ;
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.