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
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.
What is doing that you do not want?
Obs id name gender display
1 101 rakesh kumar
2 102 goyal
3 103 namita correct
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.