topic Re: Report missing variable in a dataset for a each record and create new variable. in SAS Programming

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

vandhan — Thu, 01 Feb 2018 14:52:18 GMT

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.

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

RW9 — Thu, 01 Feb 2018 15:06:07 GMT

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;

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

ChrisNZ — Thu, 01 Feb 2018 22:16:58 GMT

> char and numeric comparison is different

Not necessarily.

if missing(VAR)

works for both.