BookmarkSubscribeRSS Feed
malmario
Calcite | Level 5

Hello,

 

I have a data set which I've given values in a column called priority.  How can I dedup so that I keep those with the lowest value for priority?  For example below, I would want to keep the value where priority = 1 and delete any other priorities.


priority example.JPG

 

 

Thanks,

-Matt

1 REPLY 1
ballardw
Super User

In a data step:

 

Data want;

    set have;

    where priority=1;

run;

 

will keep only records with the stated priority value. If the value is character then it would have the value inside quote marks.

 

 

sas-innovate-white.png

Missed SAS Innovate in Orlando?

Catch the best of SAS Innovate 2025 — anytime, anywhere. Stream powerful keynotes, real-world demos, and game-changing insights from the world’s leading data and AI minds.

 

Register now

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
  • 1109 views
  • 0 likes
  • 2 in conversation