topic Re: How to merge multiple datasets with no duplicates? in SAS Programming

How to merge multiple datasets with no duplicates?

smicha — Mon, 30 Oct 2017 12:33:53 GMT

Hi,

Let's say that I have 3 datasets:

I want to merge those 3 datasets in a way that the result will look like this

But using the code below

data dataset_wrong;
      merge dataset_a dataset_b dataset_c;
      by A;
run;

the result is

What is the right code to produce the result I want.

Thank you in advance.

Re: How to merge multiple datasets with no duplicates?

Kurt_Bremser — Mon, 30 Oct 2017 12:53:24 GMT

try the following:

data dataset_wrong;
if _n_ = 0 then merge dataset_a dataset_b dataset_c;
/* this does nothing, but is needed to make the following work */
call missing(of _all_);
merge
  dataset_a
  dataset_b
  dataset_c
;
by A;
run;

Re: How to merge multiple datasets with no duplicates?

smicha — Mon, 30 Oct 2017 13:06:47 GMT

Thank you that seems to work.