topic Getting last service date in Microsoft Integration with SAS

Getting last service date

Gil_ — Fri, 10 Aug 2018 13:15:32 GMT

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

Re: Getting last service date

RW9 — Fri, 10 Aug 2018 13:20:13 GMT

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;

Re: Getting last service date

Gil_ — Fri, 10 Aug 2018 15:10:30 GMT

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

Re: Getting last service date

RW9 — Fri, 10 Aug 2018 15:12:00 GMT

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.

Re: Getting last service date

Gil_ — Fri, 10 Aug 2018 15:53:11 GMT

Really sorry i didnt realize.