[SAS Studio] Calculates Columns in the query builder.

[Audron]

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.

[Audron]

 The above post came out unformatted, so here is a repost.

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.

[grace_sas]

Hi Audron,

This is already slated to be in a future release of SAS Studio.  Thank you for your feedback.