Hi I have a dataset having numerous varibles and want to compare what are the variables having missing values for a subject.
id name number results rank
1 Nan . 3 A
2 Ben 10 .
want results like with new variable "Comment"
id name number results rank Comment
1 Nan . 3 A Number variable is missing
2 Ben 10 . Results and rank variable is missing
I have loaded all variables in macro and compared then realized that char and numeric comparison is different
Please help.
> char and numeric comparison is different
Not necessarily.
if missing(VAR)
works for both.
Post test data in the form of a datastep!!
As such this is untested:
data want; set have; length comment $2000; array n _numeric_; array c _character_; do over n; if missing(n) then catx(',',comment,vname(n)); end; do over c; if missing(c) then catx(',comment,vname(c)); end; run;
> char and numeric comparison is different
Not necessarily.
if missing(VAR)
works for both.
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.