Hi, I am very new to SAS Visual Analytics and I am having problems creating a new Column where I have to use an If Then Else Statement. The context is: I created a query in design mode with multiple tables. I noticed that we cannot use the Conditional statement in expression clause. How can I create a column with IF Then Else? These Two Columns exist already ResolvedTeam ProductResposibleTeam A X A Z B P C O A O C P D W What I need is: A new column where I combine two fields under the condition: if resolved by A then return the RroductResponsibleTeam if not return the ResolvedTeam. What I need as an output is: NewColumn X Z B C O C D Please help with as much details as possible as I am new to the tool. Thanks in advance.
... View more