DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Contributor
Posts: 40
Accepted Solution

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

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.

 

 

 

 


Accepted Solutions
Solution
‎02-01-2018 09:02 PM
PROC Star
Posts: 2,317

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

char and numeric comparison is different

Not necessarily.

if missing(VAR)

works for both.

View solution in original post


All Replies
Super User
Super User
Posts: 9,416

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

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;
Solution
‎02-01-2018 09:02 PM
PROC Star
Posts: 2,317

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

char and numeric comparison is different

Not necessarily.

if missing(VAR)

works for both.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 96 views
  • 1 like
  • 3 in conversation