BookmarkSubscribeRSS Feed
ari
Quartz | Level 8 ari
Quartz | Level 8
Have:   
ID v1v2v3
1-3aa
1-2bb
1-1cb
11db
2-20aa
2-6bb
2-3cb
2-2db
31aa
    
want:   
ID v1v2v3
11db
2-2db
31aa

 

I am trying to find one unique observation per id.   v1 ranges from 1 to -20. I am trying  to output  the highest and unique value possible for v1. 

2 REPLIES 2
LinusH
Tourmaline | Level 20

Is the ID and v1 combination unique?

If so, use SQL with group by ID having max(v1) = v1.

Data never sleeps
How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

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
  • 2 replies
  • 1345 views
  • 1 like
  • 3 in conversation