SAS Procedures

Help using Base SAS procedures
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
bijayadhikar
Quartz | Level 8

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
antonbcristina
SAS Super FREQ

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

2 REPLIES 2
antonbcristina
SAS Super FREQ

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
Quartz | Level 8
Thanks for your time and prompt response!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 755 views
  • 2 likes
  • 2 in conversation