SAS join based on latest records

[anare]

Hi Team,

I have two data sets, when i tried to joining two tables all the records are getting copied from right table except few date columns missing. after certain records its pasting.

Example below:- 

Table :- 

Number	Closed	Sales rep
96771	7/22/2020 0:00	Madhu
96768		Radha
96771	7/21/2020 17:59	Shankar
90962	7/20/2020 17:59	Madhu
95527		Radha
93647		Shankar
96362	7/22/2020 17:59	Madhu
96361	7/20/2020 17:59	Radha
96339		Shankar

Table B

Number	Closed	Supplies	Vendor
96771	7/22/2020 17:59	Ink	Abc
96768	7/22/2020 17:59	Pen	BCD
96765	7/22/2020 17:59	Printer	Abc
96762	7/22/2020 17:59	Ink	BCD
96759	7/22/2020 17:59	Pen	BD
96756	7/22/2020 17:59	Printer	CD
96753	7/22/2020 17:59	Ink	Abc
96750	7/22/2020 17:59	Pen	Abc
96747	7/22/2020 17:59	Printer	Bcd

I need output like latest record based on closed column from table b as join to table A. 

[PaigeMiller]

Show us the output you want.

[smantha]

proc sql;
create table want as 
select b.*,a.Sales_rep
from
b b
left join 
a a
on a.id= b.id;
quit;