topic Can someone please explain this code to me? in SAS Programming

Can someone please explain this code to me?

mcypert16 — Sat, 05 Mar 2016 20:08:08 GMT

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.

Re: Can someone please explain this code to me?

FreelanceReinh — Sat, 05 Mar 2016 20:13:03 GMT

Hi @mcypert16,

Have you seen this thread?

Re: Can someone please explain this code to me?

Reeza — Sat, 05 Mar 2016 20:31:57 GMT

@mcypert16 May I ask where these questions are coming from?

Re: Can someone please explain this code to me?

mcypert16 — Sat, 05 Mar 2016 20:52:44 GMT

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.

Re: Can someone please explain this code to me?

mcypert16 — Sat, 05 Mar 2016 20:56:50 GMT

http://biexamacademy.com/