https://communities.sas.com/t5/SAS-Programming/using-calculated-function-in-PROC-SQL-for-join-statements/m-p/59839#M12958 Hi all-<BR /> I know you can use the calculated statement in where statements, but what about joins?<BR /> <BR /> Unfortunately someone added a zero in a column that I strip out but when I attempt a join as<BR /> A Left join B on CALCULATED ENC=b.ENCTR<BR /> where ENC is the new column and b.ENCTR is an original column, it throws back an error...<BR /> <BR /> Any help, mightly appreciated...<BR /> Thanks again!<BR /> <BR /> Lawrence Thu, 28 Apr 2011 22:14:19 GMT _LB 2011-04-28T22:14:19Z https://communities.sas.com/t5/SAS-Programming/using-calculated-function-in-PROC-SQL-for-join-statements/m-p/59839#M12958 Hi all-<BR /> I know you can use the calculated statement in where statements, but what about joins?<BR /> <BR /> Unfortunately someone added a zero in a column that I strip out but when I attempt a join as<BR /> A Left join B on CALCULATED ENC=b.ENCTR<BR /> where ENC is the new column and b.ENCTR is an original column, it throws back an error...<BR /> <BR /> Any help, mightly appreciated...<BR /> Thanks again!<BR /> <BR /> Lawrence Thu, 28 Apr 2011 22:14:19 GMT https://communities.sas.com/t5/SAS-Programming/using-calculated-function-in-PROC-SQL-for-join-statements/m-p/59839#M12958 _LB 2011-04-28T22:14:19Z https://communities.sas.com/t5/SAS-Programming/using-calculated-function-in-PROC-SQL-for-join-statements/m-p/59840#M12959 Ignore..I managed to embed the who case statement in the join..<BR /> Thanks! Thu, 28 Apr 2011 22:34:37 GMT https://communities.sas.com/t5/SAS-Programming/using-calculated-function-in-PROC-SQL-for-join-statements/m-p/59840#M12959 _LB 2011-04-28T22:34:37Z