I am translating a colleague's STATA code into SAS and am having trouble replicating the dataset. I think it is a merge issue.
His code:
joinby var1 var2 var3 using dataset name unmatch(both)
My code:
DATA New;
MERGE A3 (IN=A) D3 (IN=B);
BY var1 var2 var3;
IF A and B then link_status=1;
ELSE IF A and not B then link_status=2;
ELSE link_status=3;
RUN;
His code:
merge m:1 var1 using "filename"
My code:
data new_;
merge new (in=A) externaldata (in=B);
by var1;
IF A and B then _merge=1;
ELSE IF A and not B then _merge=2;
ELSE _merge=3;
run;
Thanks.