Report missing variable in a dataset for a each record and create new variable.

[vandhan]

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.

[RW9]

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;

[ChrisNZ · Accepted solution]

> char and numeric comparison is different

Not necessarily.

if missing(VAR)

works for both.