topic Re: How to delete some observations in some groups based on a condition in SAS Programming

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

ddotta — Fri, 22 Jan 2021 17:20:12 GMT

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 !

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

ballardw — Fri, 22 Jan 2021 17:23:20 GMT

Please state the condition rules.

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

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

Reeza — Fri, 22 Jan 2021 17:35:42 GMT

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

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

ddotta — Fri, 22 Jan 2021 17:38:02 GMT

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

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

ddotta — Fri, 22 Jan 2021 17:38:28 GMT

not the same question

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

sam369 — Fri, 22 Jan 2021 19:52:56 GMT

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;