10-02-2014 02:12 PM
How can this EXCEL statement be written in SAS
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:
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':
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.
10-02-2014 02:34 PM
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;
10-02-2014 03:39 PM
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.