Yes, this is possible.
You just have to convert one to the other using the appropriate function.
For example, this would work for an inner join:
[pre]proc sql noprint;
create table result as
select a.CUS_SOCIAL_SEC_NUM, a...,
b...
from TABLE_A as a, TABLE_B as b
where a.CUS_SOCIAL_SEC_NUM = inputn(b.CUS_SOCIAL_SEC_NUM,'best.');
quit;[/pre]
inputn function converts a alphanumeric value to a numeric one
see:
http://support.sas.com/documentation/cdl/en/sclref/59578/HTML/default/a000162302.htm
or the opposite will do the same:
[pre]
...
where strip(put(a.CUS_SOCIAL_SEC_NUM,best.)) = strip(b.CUS_SOCIAL_SEC_NUM);[/pre]
put function converts a numeric value to a alphanumeric one
see:
http://support.sas.com/documentation/cdl/en/lrdict/62618/HTML/default/a000199354.htm
strip functions just makes sure there is no blanks before and after the value.
Cheers from Portugal
Daniel Santos @
www.cgd.pt