topic Re: Delete deaths list from dataset in SAS Programming

Delete deaths list from dataset

mayasak — Mon, 28 Nov 2022 04:17:08 GMT

Hi,

I have a data set and a death list. I need to remove the dead cases from the original dataset and keep the living observations. I would greatly appreciate your help to delete the dead observations from the original dataset.

data have;
input ID Name$ City$ State$;
cards;
11321 Mickey Mouse Miami FL
44555 Alice Meek Baltimore MD
21713 Lili Good Atlanta GA
12346 Donald Duck Houston TX
;
run;

Death list:
44555 Alice Meek Baltimore MD
21713 Lili Good Atlanta GA

Wanted list:
11321 Mickey Mouse Miami FL
12346 Donald Duck Houston TX

Thank you

Re: Delete deaths list from dataset

Ksharp — Mon, 28 Nov 2022 06:40:24 GMT

data have;
input ID Name & $20. City$ State$;
cards;
11321 Mickey Mouse   Miami FL
44555 Alice Meek     Baltimore MD
21713 Lili Good      Atlanta GA
12346 Donald Duck    Houston TX
;
run;

data Death ;
input ID Name & $20. City$ State$;
cards;
44555 Alice Meek   Baltimore MD
21713 Lili Good    Atlanta GA
;
run;

proc sql;
create table want as
select * from have
except
select * from Death
;
quit;

Re: Delete deaths list from dataset

Kurt_Bremser — Mon, 28 Nov 2022 07:19:02 GMT

Data step solution which does not need any prior sorting:

data want;
set have;
if _n_ = 1
then do;
  declare hash d (dataset:"death");
  d.definekey("id");
  d.definedone();
end;
if d.check() ne 0;
run;

Re: Delete deaths list from dataset

mayasak — Wed, 30 Nov 2022 12:52:36 GMT

Thank you Kurt. This was helpful.