03-05-2016 03:08 PM
data work.expertise; INPUT ID Name $ Level; if level = . then expertise = 'Unknown'; else if level = 1 then expertise = 'Low'; else if level = 2 or 3 then expertise = 'Medium'; else expertise = 'High'; DATALINES; 1 Frank 1 2 Joan 2 3 Sui 2 4 Jose 3 5 Burt 4 6 Kelly . 7 Juan 1 ; run;
I see what the problem is right away. else if level = 2 or 3 then expertise = 'Medium'; It should be level=2 OR level=3.
What I don't understand is the code produces this output? Any explanation would be nice. Thanks.
03-05-2016 03:52 PM
Yes. They are from a website called BI exam academy. I understand the question now. The else if level=2 or 3 is always true because 3 is nonmissing and not 0. So the code never gets past line 3.
Need further help from the community? Please ask a new question.