I have variables asset, year. I want to rank asset by year, that is to rank asset within each year. There is no tie in the asset. I want to have four groups of equal sizes based upon the rank of asset. I used proc rank procedure. I used groups=4 option. But in the result, the number of obs in each group is not equal. Why are they not equal? How to do this correctly?Thanks.
Provide some example data to get a code answer 🙂
Provide some example data to get a code answer 🙂
try
proc rank data=have groups=4 tie=dense;
by year;
var asset;
run;
SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.
Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.