Hi SAS Community, You've got a newbie in the building when it comes to SQL, so please be gentle as to date I have been using EG in anything I've been carrying out. I've been told that I have a really simple piece of existing code that can just be ran without issue, but it's throwing up an error on step 1. Error "Expression using equals (=) has components that are of different data types" I've determined that the code is trying to pull in a numerical value against a left join that has a character value but I don't know how to write the code to change the numerical to character apart from thinking it needs to read something like gl_codes=put(account,8) from INPUT_DATA as t1 left join gl_codes as t3 on t1.account =t3.gl_code gl_codes is numeric account is character (LENGTH8) Thanks!
... View more