Well it was running so I thought we were going to be okay but no luck. No I have no idea what is happening. Reeza: When I run your code I get back NOTHING in the loan_num column and the loan_no(s) are anywhere from 2 to 8 digits which means the leading zeros in loan_no were dropped. Loan_Num LOAN_NO 75 208 521 950 1115 1131 through to 508353265 proc sql; create table test3 as select m1.loan_num, lc.loan_no from PAPCPI.tbl14 lc left join PAPDSY1.master1 m1 ON trim(m1.loan_num) = put(lc.loan_no, Z8. -l) ; quit; Patrick: Your suggestion returns the same as Reeza's. proc sql; create table test3 as select m1.loan_num, lc.loan_no from PAPCPI.tbl14 lc left join PAPDSY1.master1 m1 ON left(m1.loan_num) = put(lc.loan_no, 13.) ; quit; :smileyconfused:
... View more