topic Merge 2 datasets - common rows in SAS Programming

Merge 2 datasets - common rows

niladri_routray — Tue, 18 Apr 2017 14:46:29 GMT

I know how to merge 2 datasets.

Can someone please tell me how to merge 2 datasets rows common to both the datasets.

Reeza — Tue, 18 Apr 2017 14:47:24 GMT

We can't understand your question.

Please post sample input and output data to illustrate your issue.

EDIT: Here's the SAS resource on combining datasets and all the different ways.

RW9 — Tue, 18 Apr 2017 14:01:59 GMT

Refer to this visual below which shows SQL code, however the same is possible in datastep merge using in= on both datasets:

data want;
  merge have1 (in=a) have2 (in=b);
  by merge_variables;
  if a and b;
run;