BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Tpham
Quartz | Level 8

So I have this sample data format

IDBlockValueWANT
1A-101
1A02
1A0.523
1A184
1A205
1A256
1b-191
1b0.252
1b0.963
1b214
1b325
1b456

So I want to code a rank based on the values for each ID/block.  All patients have 12 records (6 for block A and 6 for block B). So I did the first step where I used proc sort by ID Block and Value. Now I want to create that WANT variable where it indicates the rank within each ID/Block. What is the easiest way to do this?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User

data want;

by id block;

if first.block then want=1;

else want+1;

run;

View solution in original post

1 REPLY 1
Reeza
Super User

data want;

by id block;

if first.block then want=1;

else want+1;

run;

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 926 views
  • 0 likes
  • 2 in conversation