topic Re: Using In=variable to create a permanent variable in SAS Programming

Using In=variable to create a permanent variable

ChuksManuel — Wed, 03 Jul 2019 20:23:12 GMT

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;

Re: Using In=variable to create a permanent variable

ChuksManuel — Wed, 03 Jul 2019 20:27:01 GMT

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

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

Re: Using In=variable to create a permanent variable

Patrick — Wed, 03 Jul 2019 20:41:23 GMT

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;

Re: Using In=variable to create a permanent variable

ChuksManuel — Wed, 03 Jul 2019 21:00:19 GMT

Thanks!