data a;
input a naam $;
datalines;
1 piet
2 jan
3 kees
run;

data b;
input a nummer;
datalines;
1 4
3 53
run;

proc sql _method _tree;
  select a.a, naam, nummer 
  from a left join
  b on a.a=b.a;
run;