Distinct observation with condition

[monona]

As you see, observations of rsid are identical. I need just a single row whose start value is minimum of them and end value is maximum of them. Appreciate if someone help me out.

[novinosrin · Accepted solution]

Are you asking for this?

Proc sql;

create table want as

select rsid, chr ,min(start) as start, max(end) as max

from your_dataset

group by rsid, chr

quit;