topic Re: Deleting Group from single observation in SAS Programming

Deleting Group from single observation

cmendoza87 — Sat, 14 Aug 2021 15:04:15 GMT

I have a large dataset with multiple observations per person. I am having trouble creating a separate dataset from this dataset where if a person has a given observation (fever = yes) that I can delete all of their observations, not just the observation with fever = yes. Is there a way to IF-THEN-DELETE a group?

Have:

ID Fever

1 N

2 Y

2 N

5 N

Want:

ID Fever

1 N

5 N

Thank you!

Re: Deleting Group from single observation

maguiremq — Sun, 15 Aug 2021 15:41:52 GMT

I find PROC SQL subqueries helpful in these circumstances:

data have;
input id fever $;
datalines;
1       N
1       N
1       N
1       N
1       N    
1       N
1       N
2       Y
2       N
2       N
2       N
2       N
5       N
5       N
5       N
5       N
5       N
;

proc sql;
	create table 	want as
		select
					*
		from
					have
		where		id not in	(select
											id
								 from
								 			have
								 where
								 			fever = "Y");
quit;

id 	fever
1 	N
1 	N
1 	N
1 	N
1 	N
1 	N
1 	N
5 	N
5 	N
5 	N
5 	N
5 	N

There may be some IF-THEN stuff that you can do, but I'm not quite sure what would be the most efficient way.

Re: Deleting Group from single observation

cmendoza87 — Sun, 15 Aug 2021 16:00:24 GMT

This worked! Thank you so much!!!! PROC SQL seemed really complicated to me before but this code will definitely help me use it more.