Deleting Group from single observation

[cmendoza87]

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

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

Want:

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

Thank you!

[maguiremq · Accepted solution]

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.

[cmendoza87]

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