FREQ Table & Quantile

apple — Tue, 04 Feb 2014 07:00:19 GMT

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

Re: FREQ Table & Quantile

RichardinOz — Tue, 04 Feb 2014 08:49:38 GMT

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

topic FREQ Table & Quantile in SAS Programming

FREQ Table & Quantile

Re: FREQ Table & Quantile