Help with joining 2 datasets

[Haydo]

I have the following data:

I'd like to join on "Origin" (Table1) to "Origin" on Table2 and create a new dataset as per Table3 below.

Table1

Origin	Number
A	23
B	45
C	65
D	250
E	600
F	200

Table 2

Origin	Target	Tfs
A	AB	13
A	AC	10
C	BA	65
D	DA	200
D	DL	50
E	BA	100
E	ZA	150
E	MN	200
E	NP	150
F	AB	100
F	ZA	100

 Desired Output

Origin	Target	Number	Tfs
A	AB	23	13
A	AC		10
C	BA	65	65
D	DA	250	200
D	DL		50
E	BA	600	100
E	ZA		150
E	MN		200
E	NP		150
F	AB	200	100
F	ZA		100

[Kurt_Bremser · Accepted solution]

data want;
call missing(number);
merge
  table1
  table2
;
by origin;
run;