Using In=variable to create a permanent variable

[ChuksManuel]

Hello guys,

I have two datasets A  and B. A is a baseline dataset and B is the death dataset. 

I want to merge using the "In= " to select only Ids that are in dataset A.

Then also in the merge i want to create a flag using "in=" to determine that the patient died. 

My code is attached.

Any help will be appreciated.

data forty;
merge sleep2(in=x) three (in=y);
if in=x then died=y;
run;
proc print; run;

[ChuksManuel]

data forty;
merge sleep2(in=x) three (in=y);

by id;
if in=x then died=y;
run;
proc print; run;

[Patrick · Accepted solution]

Some code like below should do.

data want;
  merge A(in=ina) B (in=inb);
  by id;
  /* only select rows with an ID in table A */
  if ina;
  /* set died_flg='Y' if a matching ID in table B */
  if inb then
    died_flg='Y';
  else died_flg='N';
run;

proc print;
run;

[ChuksManuel]

Thanks!