Try adding the IN option to both on the data set statement and then filtering on that to control for an inner join.   data; merge may_nomatch_2(IN=T1 rename=(Loan_9=LOAN PropZIP=Property_Zip)) march2018_3_9char (IN=T2); by Loan_9 PropZIP; If T1 and T2; *inner join; run; ... View more

See if this gives you something usable. proc format library=work; value iszero 0='Yes' other='No' ; run; proc tabulate data=have; class _numeric_/missing; format _numeric_ iszero.; tables _numeric_ , n ; run; replace HAVE with the name of your data set.   ... View more