topic Re: need third variable bases on data in New SAS User

need third variable bases on data

aanan1417 — Tue, 08 Nov 2022 08:17:11 GMT

data have;

input id name;

datalines;

1 rahul

2 rohit

3 nisha

9 kuldeep

;

run;

data have2;

input id name;

datalines;

1 rahul

2 rohit

3 nisha

4 pukit

5 aakash

;

run;

final output should look like

id name remark

1 rahul ok

2 rohit ok

3 nisha ok

9 kuldeep notok

Re: need third variable bases on data

Shmuel — Tue, 08 Nov 2022 13:32:26 GMT

Have you got instructions how to create the output? what are the rules ?

I suppose that if data on both datasets is the same then remark="OK";

else remark="NOTOK";

To achieve that use merge statement:

data want(drop=_name);
  merge have(in=in1) 
        have2(in=in2 rename=(name=_name));
  by ID;
      if in1 and in2 and name=_name then remark='ok';
      else if in1 and in2 then remark = 'notok';
      else delete;
run;