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 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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