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;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.