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.
Show us the output you want.
proc sql;
create table want as
select b.*,a.Sales_rep
from
b b
left join
a a
on a.id= b.id;
quit;
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.