topic Re: How to change the value of single cells (of a column) based on some conditions (of other columns in SAS Enterprise Guide

How to change the value of single cells (of a column) based on some conditions (of other columns)?

KubiK888 — Wed, 19 Jul 2017 15:40:23 GMT

Say I have the following data:

Var1 Var2 Var3

0 0 1

1 1 3

0 1 1
0 0 1

1 1 1

How can I change values in Var3 to "-999" if Var1=1 and Var2=1?

Re: How to change the value of single cells (of a column) based on some conditions (of other columns

Rwon — Wed, 19 Jul 2017 15:47:55 GMT

You would want to use if-else conditions. Note that the -999 will be numeric since I assume that is what you want.

data want;
set have;
if Var1=1 and Var2=1 then Var3 = -999;
run;

Source:

https://v8doc.sas.com/sashtml/lgref/z0202239.htm

Re: How to change the value of single cells (of a column) based on some conditions (of other columns

KubiK888 — Wed, 19 Jul 2017 15:56:06 GMT

Thanks, I understand the SAS base code that can do that, but since it's in Enterprise Guide, does it not have a point-and-click solution to it?

Re: How to change the value of single cells (of a column) based on some conditions (of other columns

TomKari — Wed, 19 Jul 2017 17:30:32 GMT

Yes, it's quite easy in EG. Create a new query, and create an advanced expression. In the advanced expression, the CASE function will let you implement "if then else" type logic.