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.
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;
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;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.