11-24-2013 05:48 AM
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 .
input id name $ gender $;
101 rakesh kumar
102 . goyal
103 namita .
if name ne '' and gender eq '' then display="correct";
11-24-2013 10:56 AM
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.