I currently use the below workarounds: So far the workarounds include: Copying the code and adding the case statement or calculations to the PROC SQL You end up losing the task, so it would be nice to just include an advanced expression column in order to not lose the task Using the Transform Data Task as a separate step I found that I had to trick the task to letting me format a calculated date back into a date format. DateColumn-1; format tr1_date DATE9. It would be nice if this task had a visual way to format the calculated column Using the Recode Task as a separate step A Recode condition should let us select another column Let us override the ELSE (otherwise) functionality Also allow another column to be part of the Recode condition These enhancement would do a lot to make the above tasks more complete and functional.
... View more
