topic Re: abnormal if then output in SAS Programming

abnormal if then output

pavank — Sun, 07 Jul 2024 06:29:31 GMT

/*Question_1 */

data k;
x=2;
if x=1 then y=100;
if x=2 then y=200;
if x=3 then y=300;
else y=27;
run;



/*Question_2 */


data _n;
set sashelp.class;
if sex='F';
if sex='M' ;
put name sex ;
run;

Hi Experts,

Question_1 :Why it gives x=2 and y=27 why not y=200 in k dataset could you please explain

Question_2: Why zero observations in _n dataset

Re: abnormal if then output

MarkusWeick — Sun, 07 Jul 2024 06:42:16 GMT

Hi @pavank, regarding question 1: the else relates only to the "if" which is before it. Try this:

data k;
x=2;
if x=1 then y=100;
else
	if x=2 then y=200;
	else
		if x=3 then y=300;
		else y=27;
run;

Mayve it gives the results you want.

The comparison of this code and its results with the code and results of your question 1 should help to understand how nested if else works.

Best

Markus

Re: abnormal if then output

MarkusWeick — Sun, 07 Jul 2024 06:53:07 GMT

Hi @pavank, regarding the second question:

Please read https://communities.sas.com/t5/SAS-Programming/Difference-between-only-IF-with-and-IF-with-THEN-statement/td-p/245441.

Your if statements select only the rowas with sex = "F" and (!) sex = "M".

"and" and not "or". But there are now rows with sex = "F" and (!) sex = "M".

Hope this answers your question.

Best

Markus

Re: abnormal if then output

pavank — Sun, 07 Jul 2024 07:04:32 GMT

Hi @MarkusWeick

Thank you for your solution