Hello,   I am trying to create a table using PROC SQL and I want to join on a second table. Without giving the actual column names, the code is essentially this.    proc sql;    create table TABLE as  select distinct col1, col2, ..., case when b.columnX is null then 'Y' else 'N' as columnXNull   from TABLE1 a left join TABLE2 b on strip(put(a.columnX,30.)) = b.columnX ;quit;   In TABLE1 columnX is Type: Numeric, Length: 8 In TABLE2 columnX is Type: Character, Length: 30   I am getting 2 errors in this code -  ERROR: Expression using equals (=) has components that are of different data types. ERROR: Function STRIP requires a character expression as argument 1.    I originally did not have the put function and was still receiving the above errors, except the second error appeared twice. Since adding the put(), one of the two errors for function strip are gone. However, I am confused, because after reading other forum posts, the put() function should be changing columnX to a character. Am I missing something or doing something wrong?  ... View more