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;

* The in = left option creates a temporary variable, left, that indicates if the observation was originally in the left dataset;

* The if left and right statement, keeps only observations where right = 1 and left = 1;

data inner;

merge l_data(in = left) r_data(in = right);

by Key;

if left and right;

run;

* Datasets do not need to be previously sorted;

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

* Select all variables from l_data and the Fruits variable from r_data;

proc sql;

create table sql_inner as

select a.*, b.fruits

from l_data a, r_data b

where a.Key = b.Key

;

quit;

*Alternatively instead of a where statement, specify an inner join in the from statement on a.Key = b.Key;

proc sql;

create table sql_inner as

select a.*, b.fruits

from l_data a inner join r_data b

on a.Key = b.Key

;

quit;