Remove records based on a condition

NewUsrStat — Sat, 01 Oct 2022 14:54:20 GMT

Hi guys,

suppose to have:

Id Place

A Hosp1

A Hosp2

B Hosp1

C Hosp3

C Hosp4

I would like the following:

Id Place

C Hosp3

C Hosp4

So I if Place =Hosp1 delete not only the single record but instead the entire Id. Basically I would like to remove Ids containing Hosp1. Can anyone help me please? Thank you very much

Re: Remove records based on a condition

PaigeMiller — Sat, 01 Oct 2022 15:06:11 GMT

From now on, please provide data as WORKING data step code, as shown below.

data have;
    input Id $ Place $;
    cards;
       A                Hosp1
       A                Hosp2
       B                Hosp1
       B                Hosp1
       C                Hosp3
       C                Hosp4
;

proc sql;
	create table want as select *
	    from have
	    group by id having max(place='Hosp1')=0;
quit;

topic Remove records based on a condition in New SAS User

Remove records based on a condition

Re: Remove records based on a condition