topic Re: Or and AND statment at once in New SAS User

Or and AND statment at once

mmea — Tue, 27 Apr 2021 11:28:43 GMT

if I have these to variables in a data set

variable1	variable2
0.90	300
0.20	65
0.01	400

I need to make a variable3 based on following statement:

if variable1 >= 0.1 and/OR variable2 >= 200 then variable3 = "good"

if variable1 < 0.1 and/or variable2 <200 then variable3 = "bad"

So in this case variable3 will be

good

Re: Or and AND statment at once

PaigeMiller — Tue, 27 Apr 2021 13:24:37 GMT

The only logic I know of does not recognize "AND/OR", its more of a figure of speech than any logical or programming concept. So I can only guess what you mean by

if variable1 >= 0.1 and/OR variable2 >= 200 then variable3 = "good"

if variable1 < 0.1 and/or variable2 <200 then variable3 = "bad"

Isn't this the same as using OR in place of AND/OR in the first IF? If not, explain why.

(And side issue, please please please put semi-colons at the end of your SAS statements)

Re: Or and AND statment at once

Kurt_Bremser — Tue, 27 Apr 2021 12:15:34 GMT

Please add cases that should end up as "bad".

Do it in this form:

data have;
input variable1 variable2;
datalines;
0.90  300
0.20  65
0.01  400
;

so we can quickly create the dataset for testing with copy/paste and submit.

Re: Or and AND statment at once

AMSAS — Wed, 28 Apr 2021 17:39:35 GMT

I'll add to the comments, what happens when variable1=0.2 and variable2=199 is that good (variable1>0.1) or bad (variable2<200)

You could find it helpful to build a table:

Variable 1 Value (>0.1)	Variable 2 Value (>200)	Result
0.9 (True)	300 (True)	good (True)
0.05 (False)	300 (True)	????
0.9 (True)	100 (False)	????
0.05 (False)	100 (False)	bad (False)

Re: Or and AND statment at once

mmea — Tue, 04 May 2021 08:59:41 GMT

data have; input variable1 variable2; datalines; 0.90 300 0.20 65 0.01 400 0.006 100 0.67 78 ;

So in this case

0.90 (>0.10) and 300 (>200) is good

0.20 (>0.10) and 65 (<200) is good

0.01 (<0.10) and 400 (>200) is good

0.006 (<0.10) and 100 (<200) is bad

0.67 (>0.10) and 78 (<200) is bad

Re: Or and AND statment at once

mmea — Tue, 04 May 2021 09:01:27 GMT

Yes that is a good because variable 1 is over 10% percent - as long one of thm match the criteria >10% or >=200

Variable 1 Value (>0.1)	Variable 2 Value (>200)	Result
0.9 (True)	300 (True)	good (True)
0.05 (False)	300 (True)	good
0.9 (True)	100 (False)	good
0.05 (False)	100 (False)	bad (False)

It wil be like that

Re: Or and AND statment at once

Kurt_Bremser — Tue, 04 May 2021 09:05:34 GMT

@mmea wrote:

0.20 (>0.10) and 65 (<200) is good

0.67 (>0.10) and 78 (<200) is bad

These two contradict each other.

Re: Or and AND statment at once

mmea — Tue, 04 May 2021 09:10:02 GMT

Sorry its should be good - my mistake

So if one of them have the criteria >10% or >=200 then its good no matter what the other are

Re: Or and AND statment at once

Kurt_Bremser — Tue, 04 May 2021 09:14:47 GMT

data have;
input variable1 variable2;
datalines;
0.90  300
0.20  65
0.01  400
0.006 100
0.67  78
;

data want;
set have;
if variable1 gt 0.1 or variable2 ge 200
then result = "good";
else result = "bad";
run;

Re: Or and AND statment at once

PaigeMiller — Tue, 04 May 2021 10:35:05 GMT

@mmea wrote:

Yes that is a good because variable 1 is over 10% percent - as long one of thm match the criteria >10% or >=200

Variable 1 Value (>0.1) Variable 2 Value (>200) Result

0.9 (True) 300 (True) good (True)

0.05 (False) 300 (True) good

0.9 (True) 100 (False) good

0.05 (False) 100 (False) bad (False)

It wil be like that

So when both variable 1 and variable 2 return a "False" then the result is "False". Any other condition returns a "True".

Then you want when

if variable1<=0.1 and variable2<=200 then result='False'; else result='True';

alternatively

if variable1>0.1 or variable2>200 then result='True'; else result='False';

There is no such thing as an "and/or" here (or anywhere in SAS).

Re: Or and AND statment at once

mmea — Tue, 04 May 2021 11:33:36 GMT

but will this consider when variable1 is below 0.1 but variable2 is GE 200 as TRUE?

Re: Or and AND statment at once

Kurt_Bremser — Tue, 04 May 2021 11:36:20 GMT

Maxim 4.

TRY IT.