topic Re: IF else cond not working in SAS Programming

IF else cond not working

Tanja — Sun, 24 Nov 2013 10:48:11 GMT

Hello Everyone!!

For the below dataset, I want to find the record where name is not null and gender is null. Why if condition is not working .

data x;

input id name $ gender $;

cards;

101 rakesh kumar

102 . goyal

103 namita .

;

run;

data test1;

set x;

if name ne '' and gender eq '' then display="correct";

run;

Advance thanks

Re: IF else cond not working

jakarman — Sun, 24 Nov 2013 15:56:10 GMT

Would review the concepts of missing values: SAS(R) 9.4 Language Reference: Concepts and more in detail working with them. SAS(R) 9.4 Language Reference: Concepts It is the . being used as default representation of missing with numeric variables. With character vars it is ' ' the space. Special missing are possible as sometimes you have more reasons that something is missing.

The usage of the word null is coming from a DBMS point of view that is not the same approach as missing in statistics.

When you are going for statistics try to see that difference and understand the origins.

Going to you question.

You have read the char-variables with "." content in the datastep.

That is really meaningful content for strings these are not missing values.

Re: IF else cond not working

Tom — Sun, 24 Nov 2013 16:29:10 GMT

What is doing that you do not want?

Obs id name gender display

1 101 rakesh kumar

2 102 goyal

3 103 namita correct