Hi, in my case log is not generated only the message that I mentioned pops up and the code is: proc sql; create table Want as select a.*,b.* from Lib1.Have1 a left join Lib2.Have2 b on trim(upcase (a.ID))=trim(upcase(b.ID)) and trim (upcase (a.MemberNo))=trim(upcase(b.MemberNo)) AND a.Date_Received between b.'Start Date'n and b. 'End Date'n AND a.Date_Received between b.policy_startdate and b.policy_ enddate AND a.Date_Received between b.policy_start_date and b.policy_end_date; QUIT; Left Data contains 90,00,32 and Right Data 8,10,74,788
... View more
