topic Re: Add New Column based on IF Statement in SAS Visual Analytics

Add New Column based on IF Statement

tassekurt — Fri, 12 Aug 2016 19:30:54 GMT

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

Please help with as much details as possible as I am new to the tool. Thanks in advance.

Re: Add New Column based on IF Statement

stat_sas — Fri, 12 Aug 2016 20:07:23 GMT

Hi,

Please try this:

data want;
set have;
NewColumn=ResolvedTeam;
if ResolvedTeam='A' then NewColumn=ProductResposibleTeam;
run;

Re: Add New Column based on IF Statement

tassekurt — Fri, 12 Aug 2016 20:38:24 GMT

Here is the error I am getting:

Re: Add New Column based on IF Statement

stat_sas — Fri, 12 Aug 2016 20:43:07 GMT

Data set "have" would be based on information provided. I've added syntax to create data set. Please try this:

data have;
input ResolvedTeam $ ProductResposibleTeam $;
datalines;
A X
A Z
B P
C O
A O
C P
D W
;

data want;
set have;
NewColumn=ResolvedTeam;
if ResolvedTeam='A' then NewColumn=ProductResposibleTeam;
run;

Re: Add New Column based on IF Statement

LinusH — Sat, 13 Aug 2016 08:05:24 GMT

Another option is to create the column in the Visual Data Builder. There you use SQL syntax, which means that you can use CASE-WHEN-THEN-ELSE-syntax.

Re: Add New Column based on IF Statement

tassekurt — Mon, 15 Aug 2016 18:56:38 GMT

The code works but the column is not created. Why?

Thanks again.

Re: Add New Column based on IF Statement

TejaSurapaneni — Tue, 16 Aug 2016 10:39:03 GMT

Hello,

in SAS VA,

IF ( 'ResolvedTeam'n In ('A') )
RETURN ' ProductResposibleTeam'n
ELSE 'ResolvedTeam'n

Let me know.

Thanks & Regards,

Teja Surapaneni

Re: Add New Column based on IF Statement

tassekurt — Tue, 16 Aug 2016 19:33:19 GMT

I really don’t know how it works. There is no error but nothing is happening as an output. Is there anything to do with libraries?

Thanks again.

Re: Add New Column based on IF Statement

tassekurt — Wed, 17 Aug 2016 17:59:44 GMT

Thank you so much.