topic Dedupping by priority when multiple rows share the same priority in SAS Procedures

Dedupping by priority when multiple rows share the same priority

malmario — Wed, 06 Jun 2018 22:43:26 GMT

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

Re: Dedupping by priority when multiple rows share the same priority

ballardw — Wed, 06 Jun 2018 22:57:37 GMT

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.