topic Re: How to select both duplicate IDs if a condition met in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/How-to-select-both-duplicate-IDs-if-a-condition-met/m-p/900801#M83069 <P>You could use a PROC SQL subquery to find the (distinct?) IDs with records in 2023 and then pull all records matching those IDs.&nbsp;&nbsp;</P> <PRE>proc sql; select id, year from have where id in (select id from have where year=2023); quit;</PRE> <P>&nbsp;</P> Mon, 30 Oct 2023 20:15:08 GMT antonbcristina 2023-10-30T20:15:08Z How to select both duplicate IDs if a condition met https://communities.sas.com/t5/SAS-Procedures/How-to-select-both-duplicate-IDs-if-a-condition-met/m-p/900796#M83068 <P>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?</P> <P>Have</P> <TABLE width="148"> <TBODY> <TR> <TD width="76">ID</TD> <TD width="72">year</TD> </TR> <TR> <TD>130177</TD> <TD>2021</TD> </TR> <TR> <TD>130177</TD> <TD>2022</TD> </TR> <TR> <TD>137939</TD> <TD>2021</TD> </TR> <TR> <TD>137939</TD> <TD>2023</TD> </TR> <TR> <TD>160200</TD> <TD>2022</TD> </TR> <TR> <TD>160200</TD> <TD>2023</TD> </TR> <TR> <TD>166898</TD> <TD>2020</TD> </TR> <TR> <TD>166898</TD> <TD>2023</TD> </TR> <TR> <TD>175553</TD> <TD>2022</TD> </TR> <TR> <TD>175553</TD> <TD>2023</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>want:</P> <TABLE width="148"> <TBODY> <TR> <TD width="76">ID</TD> <TD width="72">year</TD> </TR> <TR> <TD>137939</TD> <TD>2021</TD> </TR> <TR> <TD>137939</TD> <TD>2023</TD> </TR> <TR> <TD>160200</TD> <TD>2022</TD> </TR> <TR> <TD>160200</TD> <TD>2023</TD> </TR> <TR> <TD>166898</TD> <TD>2020</TD> </TR> <TR> <TD>166898</TD> <TD>2023</TD> </TR> <TR> <TD>175553</TD> <TD>2022</TD> </TR> <TR> <TD>175553</TD> <TD>2023</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>data HAVE;<BR />input ID year;<BR />cards;<BR />130177 2021<BR />130177 2022<BR />137939 2021<BR />137939 2023<BR />160200 2022<BR />160200 2023<BR />166898 2020<BR />166898 2023<BR />175553 2022<BR />175553 2023<BR />run;</P> <P>&nbsp;</P> Mon, 30 Oct 2023 19:53:15 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-select-both-duplicate-IDs-if-a-condition-met/m-p/900796#M83068 bijayadhikar 2023-10-30T19:53:15Z Re: How to select both duplicate IDs if a condition met https://communities.sas.com/t5/SAS-Procedures/How-to-select-both-duplicate-IDs-if-a-condition-met/m-p/900801#M83069 <P>You could use a PROC SQL subquery to find the (distinct?) IDs with records in 2023 and then pull all records matching those IDs.&nbsp;&nbsp;</P> <PRE>proc sql; select id, year from have where id in (select id from have where year=2023); quit;</PRE> <P>&nbsp;</P> Mon, 30 Oct 2023 20:15:08 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-select-both-duplicate-IDs-if-a-condition-met/m-p/900801#M83069 antonbcristina 2023-10-30T20:15:08Z Re: How to select both duplicate IDs if a condition met https://communities.sas.com/t5/SAS-Procedures/How-to-select-both-duplicate-IDs-if-a-condition-met/m-p/900822#M83070 Thanks for your time and prompt response! Mon, 30 Oct 2023 21:53:49 GMT https://communities.sas.com/t5/SAS-Procedures/How-to-select-both-duplicate-IDs-if-a-condition-met/m-p/900822#M83070 bijayadhikar 2023-10-30T21:53:49Z