[Feature Request] Query Builder Calculated Columns

Audron — Sun, 30 Sep 2018 20:57:50 GMT

This is a feature request than a question since 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.

Re: [Feature Request] Query Builder Calculated Columns

SASKiwi — Sun, 30 Sep 2018 21:42:03 GMT

Feature requests should be in the SASware Ballot:

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

Audron — Sun, 30 Sep 2018 22:18:04 GMT

I'll repost there.