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.
Thanks,
-Matt
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 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Save the date!
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.
Ready to level-up your skills? Choose your own adventure.
Browse our catalog!