Open 1to1 left.csv

Open 1to1 right.csv

* Datasets MUST be sorted on Key variable prior to merging;

proc sort data = l_data;

by Key;

run;

proc sort data = r_data;

by Key;

run;

data outer_full;

merge l_data r_data;

by Key;

run;

* Datasets do not need to be previously sorted;

* Refer to l_data as dataset a and r_data as dataset b;

* The coalesce function is used to create the Key to join on;

* Select the Veggies variable from l_data and Fruits from r_data;

proc sql;

create table sql_outer_full as

select coalesce(a.Key, b.Key) as Key, a.Veggies, b.Fruits

from l_data a full join r_data b

on a.Key = b.Key

;

quit;