I am converting some SAS code to TD : In SAS you can set multiple variables within a single case statement. Can we do the same in TD? Thanks in advance
What does it mean "Teradata code"? bteq script? Stored Procedure? Other?
CASE (SQL) won't work this way, maybe a SP will.
Code in SAS is a do loop. If you want to achive same thing then use 2 case statements, which is simple and easy solution.
case when RFRL_SRC_CD = '039' then 1
case when RFRL_SRC_CD = '039' then prcd_amt