[Feature Request] Query Builder Calculated Columns

[Audron]

This is a feature request than a question since I currently use the below workarounds:

So far the workarounds include:

1. 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
2. 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 
3. 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.

[SASKiwi]

Feature requests should be in the SASware Ballot:

https://communities.sas.com/t5/SASware-Ballot-Ideas/idb-p/sas_ideas

Please add a post there. It appears I can't move it myself as I can for other topic areas.

[Audron]

I'll repost there.