How to delete some observations in some groups based on a condition

[ddotta]

data temp;
input siren $ class $ imput $;
cards;
A CP titi
B CP toto
C CE tata
D CE tata
F CM toto
G CM toto
H SU tata
I SU toto
;
run;

The output I want :

siren class imput
A CP titi
C CE tata
D CE tata
F CM toto
G CM toto
H SU tata

Many thanks in advance !

[ballardw]

Please state the condition rules.

I can make that output but it probably would not work for any other records.

[ddotta]

I would like delete some observations in some groups based on a condition. My condition is each group : if (imput="toto") then delete but if a whole group has imput="toto" then keep it

[Reeza]

https://stackoverflow.com/questions/65848148/how-to-delete-some-rows-within-a-group-in-sas

[ddotta]

not the same question

[sam369 · Accepted solution]

proc sql;
create table want as
select a.*
from temp as a left join (select *,count(imput) as cnt from temp where imput='toto' group by class ) as b on (a.class=b.class & a.siren=b.siren)
having missing(b.cnt) or b.cnt>=2
order by a.siren,a.class;
quit;