using calculated function in PROC SQL for join statements

_LB · Posted 04-28-2011 06:14 PM

Hi all-
I know you can use the calculated statement in where statements, but what about joins?

Unfortunately someone added a zero in a column that I strip out but when I attempt a join as
A Left join B on CALCULATED ENC=b.ENCTR
where ENC is the new column and b.ENCTR is an original column, it throws back an error...

Any help, mightly appreciated...
Thanks again!

Lawrence

_LB · Posted 04-28-2011 06:34 PM

Ignore..I managed to embed the who case statement in the join..
Thanks!

using calculated function in PROC SQL for join statements

Re: using calculated function in PROC SQL for join statements

Registration is open

Call for Content EXTENDED

using calculated function in PROC SQL for join statements

Re: using calculated function in PROC SQL for join statements

Registration is open

Call for Content EXTENDED

SAS Training: Just a Click Away