【sas proc sql】out join

 1 data mylearn.outerjoin_a;
 2     input a :$;
 3     datalines;
 4     a
 5     b
 6     c
 7     d
 8     e
 9     f
10     g
11     ;
12 run;
13 data mylearn.outjoin_b;
14     input b :$;
15     datalines;
16     b
17     c
18     d
19     k
20     ;
21 run;
22 proc sql;
23     select * from mylearn.outerjoin_a a right join mylearn.outjoin_b b
24     on a.a=b.b;
25 quit;
26 proc sql;
27     select * from mylearn.outerjoin_a a left join mylearn.outjoin_b b
28     on a.a=b.b;
29 quit;

left join 结果是

1 proc sql;
2     select a.a '#a#a sample',b.b from mylearn.outerjoin_a a full join mylearn.outjoin_b b
3     on a.a=b.b;
4 quit;

注意：行说明中的# #是用来在label上换行