DATA Step, Macro, Functions and more

Deciles within a decile

Accepted Solution Solved
Reply
Contributor
Posts: 34
Accepted Solution

Deciles within a decile

Hi all,

In my data set, I have a variable 'decile' with values 1 through 10 based on a variable 'score'. I need to create another variable 'mini-decile' that divides each decile again into 10 equal parts or deciles based on the score (descending).

Can somebody help me how to write the code?

Thanks!


Accepted Solutions
Solution
‎09-23-2014 05:10 PM
Trusted Advisor
Posts: 1,228

Re: Deciles within a decile

Posted in reply to krishmar1

All Replies
Solution
‎09-23-2014 05:10 PM
Trusted Advisor
Posts: 1,228

Re: Deciles within a decile

Posted in reply to krishmar1

Try proc rank.

Super User
Posts: 19,770

Re: Deciles within a decile

Posted in reply to krishmar1

That sounds like percentiles. Use Proc Rank with 100 groups or proc univariate.

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 271 views
  • 3 likes
  • 3 in conversation