Getting last service date

[Gil_]

I have 2 tables i need to know based on table A date when it was last done in table b.
Table A
Id. Date
A1. 05/01/2018
A3. 05/08/2018
Table B
Id. Date
A1. 04/28/2018
A3. 04/21/2018
A1. 03/07/2018
A3. 04/16/2018

Whst i need output frrom table a and the last date from when service was done from table b

Id. Date. Date.
A1. 05/01/2018. 04/28/2018
A3. 05/08/2018. 04/21/2018

[RW9 · Accepted solution]

What does this have to do with BI?  Also, please post test data in the form of a datastep, as such this code is untested:

proc sql;
  create table want as 
  select a.id,
            a.date,
            b.date as last_date
  from   tablea a
  left join (select id,
                    max(date) as date 
             from   tableb 
             group by id) b
  on       a.id=b.id;
quit;

[Gil_]

Thanks will test it. What do you mean by your question? BI.

[RW9]

You posted the question in the BI forum, but I didn't see anything relating to BI specifically.  If so I can move to the general SAS questions area.

[Gil_]

Really sorry i didnt realize.