Question: Write the proc sql statements to create a table merging the datasets single and double on their common variable x keeping all observations from single
Write the proc sql statements to create a table merging the datasets single and double on their common variable x keeping all observations from single and the matching observations from double;
data single;
input id $ var;
datalines;
a 1
b 2
c 3
;
run;
data double;
input id $ var;
datalines;
a 11
c 33
;
run;
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
