Programming the statistical procedures from SAS

Proc rank decile binning

Accepted Solution Solved
Reply
Contributor
Posts: 67
Accepted Solution

Proc rank decile binning

Hello

 

In logistic regression after deciling using proc rank, I ran proc freq which returned below output

 

decile.JPG

I am getting different frequencies in each decile, is it necessary that we should get equal number of frequencies in each decile?.

 

Thanks


Accepted Solutions
Solution
a week ago
SAS Super FREQ
Posts: 3,307

Re: Proc rank decile binning

You will not necessarily get identical numbers in each bin. See the example (and cautionary tale) in the article "Binning data by quantiles? Beware of rounded data!"

View solution in original post


All Replies
Super Contributor
Posts: 476

Re: Proc rank decile binning

Necessary for what? Use the GROUPS= option in PROC RANK if you want to have equal frecuencies in your groups

 

Small example

 

proc rank data=sashelp.cars out=carsRanked groups=10;
	var invoice;
	ranks group;
run;

proc freq data = carsRanked;
	tables group / nocum;
run;
Solution
a week ago
SAS Super FREQ
Posts: 3,307

Re: Proc rank decile binning

You will not necessarily get identical numbers in each bin. See the example (and cautionary tale) in the article "Binning data by quantiles? Beware of rounded data!"

Contributor
Posts: 67

Re: Proc rank decile binning

Thank you very much.

 

Lets say I want to calculate expected defaults(Y=0), I have 8417/16880=0.499 zeros, then can I say that the expected defaults is 2044*0.499=1019.956 for the decile 4?.decile.JPG

 

Thank you.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 75 views
  • 0 likes
  • 3 in conversation