topic Re: AND and OR statements in sas problem in SAS Procedures

AND and OR statements in sas problem

zetter — Thu, 02 Oct 2014 18:12:53 GMT

How can this EXCEL statement be written in SAS

Excel version:

=IF(OR(AND(A<=X,ISBLANK(B)),(AND(A<=X,B<A))),1,0)

in Other words, if A<=X and B is blank then then variable value =1 OR if A<=X and B<1 then variable value =1 else variable value=c

I've used a SAS statement like this:

data want

let value $10:

iF A is le X and B ='' then value= ‘1’:

if A is le X and B lt A then values='1':

else value=0

these statements do not bring up correct results. How do use the OR statement correctly here? I think the error is in the implementation of OR.

Re: AND and OR statements in sas problem

PGStats — Thu, 02 Oct 2014 18:26:30 GMT

With SAS, TRUE is 1 and FALSE is 0, so your expression can be written:

value = A<=X and (missing(B) or B<A);

Re: AND and OR statements in sas problem

Reeza — Thu, 02 Oct 2014 18:34:34 GMT

That doesn't seem like valid SAS code, I think you missed an else for one and a typo, value vs values.

Is this closer:

IF A le X and B ='' then value= 1;

ELSE if A le X and B lt A then value=1;

else value=0;

Re: AND and OR statements in sas problem

ballardw — Thu, 02 Oct 2014 19:39:43 GMT

What do you want to do if A is missing? Missing values are always less than anything else and you want to make sure you are getting expected results. If you don't want to assign 1 when A is missing you need to address that.

Re: AND and OR statements in sas problem

zetter — Thu, 02 Oct 2014 19:55:40 GMT

What about this:

IF A ne. and A le X and B =. then value= 1;

ELSE if A ne. and A le X and B lt A then value=1;

else value=0;