☑ This topic is solved.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 10-30-2023 03:53 PM
(755 views)
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;
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for your time and prompt response!