topic Re: Distinct observation with condition in SAS Programming

Distinct observation with condition

monona — Tue, 16 Apr 2019 21:21:21 GMT

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.

Re: Distinct observation with condition

novinosrin — Tue, 16 Apr 2019 21:26:15 GMT

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;