Translating STATA merges to SAS

martyvd — Wed, 31 Oct 2018 16:28:00 GMT

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.

Re: Translating STATA merges to SAS

ballardw — Wed, 31 Oct 2018 17:13:56 GMT

Example input data and expected results would help. As it is we can not tell what is missing or added.

Provide just enough records and variables in the two sets being merged to show the issues and what the result should be for the example input data sets.

I don't speak STATA so can't work from the example code but have a pretty fair understanding of how to manipulate data in SAS.

topic Re: Translating STATA merges to SAS in SAS Programming

Translating STATA merges to SAS

Re: Translating STATA merges to SAS