After a merge statement, I often inspect the merged data and decide whether I want to keep rows with _merge==1 (master), _merge==2 (using), _merge==3 (matched). I have trouble remembering what 1,2,3 mean and would much rather use words than numbers.
I'm aware of the keep option to the merge command --e.g.,
But I'm often unsure which results I want to keep until I've inspected the data. So what I'm talking about is more like this.
Is there a more transparent alternative to saying _merge==1 here?
Thanks!
Paul
I'm aware of the keep option to the merge command --e.g.,
Code:
merge 1:1 using otherdata, keep(match master)
Code:
merge 1:1 using otherdata list if _merge==1 drop if _merge==1
Thanks!
Paul
Comment