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.
With SAS, TRUE is 1 and FALSE is 0, so your expression can be written:
value = A<=X and (missing(B) or B<A);
PG
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;
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.
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;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.