08-12-2016 03:30 PM
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
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:
Please help with as much details as possible as I am new to the tool. Thanks in advance.
08-12-2016 04:43 PM
Data set "have" would be based on information provided. I've added syntax to create data set. Please try this:
input ResolvedTeam $ ProductResposibleTeam $;
if ResolvedTeam='A' then NewColumn=ProductResposibleTeam;
08-13-2016 04:05 AM