Solved: How to select both duplicate IDs if a condition met

bijayadhikar · Posted 10-30-2023 03:53 PM

This should be an easy solution but could not figured it out. How to I select both duplicate IDs if year is associated with 2023?

Have

ID	year
130177	2021
130177	2022
137939	2021
137939	2023
160200	2022
160200	2023
166898	2020
166898	2023
175553	2022
175553	2023

want:

ID	year
137939	2021
137939	2023
160200	2022
160200	2023
166898	2020
166898	2023
175553	2022
175553	2023

data HAVE;
input ID year;
cards;
130177 2021
130177 2022
137939 2021
137939 2023
160200 2022
160200 2023
166898 2020
166898 2023
175553 2022
175553 2023
run;

antonbcristina · Posted 10-30-2023 04:14 PM

You could use a PROC SQL subquery to find the (distinct?) IDs with records in 2023 and then pull all records matching those IDs.

proc sql;
	select id, year
	from have
	where id in (select id
		     from have
	             where year=2023);
quit;

View solution in original post

antonbcristina · Posted 10-30-2023 04:14 PM

You could use a PROC SQL subquery to find the (distinct?) IDs with records in 2023 and then pull all records matching those IDs.

proc sql;
	select id, year
	from have
	where id in (select id
		     from have
	             where year=2023);
quit;

bijayadhikar · Posted 10-30-2023 05:53 PM

Thanks for your time and prompt response!

How to select both duplicate IDs if a condition met

Re: How to select both duplicate IDs if a condition met

Re: How to select both duplicate IDs if a condition met

Re: How to select both duplicate IDs if a condition met

How to select both duplicate IDs if a condition met

Re: How to select both duplicate IDs if a condition met

Re: How to select both duplicate IDs if a condition met

Re: How to select both duplicate IDs if a condition met

SAS Innovate 2025: Call for Content

Click image to register for webinar

Classroom Training Available!