Help using Base SAS procedures

Creating an indicator variable based on missing variable values

Accepted Solution Solved
Reply
Occasional Contributor ajb
Occasional Contributor
Posts: 18
Accepted Solution

Creating an indicator variable based on missing variable values

Hi,

I want to create a missing indicator variable and I am at a loss as to how to go about doing this.

I have 100 obs(under the variable PatID) and 15 other variables(v1-v15)

What I want to be able to do is:

        if an observation has missing values for at least any 3  of the 15 variables then newvar=1

else  if an observation has missing values for less than any 3 of the 15 variables then newvar=0

Any suggestions?

Thanks!!


Accepted Solutions
Solution
‎07-27-2014 02:32 AM
Trusted Advisor
Posts: 1,137

Re: Creating an indicator variable based on missing variable values

you can use the nmiss function to achieve your output.

something like below

if nmiss(of v1-v15)>=3 then newvar=1;

else if nmiss(of v1-v15)<3 then newvar=0;

Thanks,

Jag

Thanks,
Jag

View solution in original post


All Replies
Solution
‎07-27-2014 02:32 AM
Trusted Advisor
Posts: 1,137

Re: Creating an indicator variable based on missing variable values

you can use the nmiss function to achieve your output.

something like below

if nmiss(of v1-v15)>=3 then newvar=1;

else if nmiss(of v1-v15)<3 then newvar=0;

Thanks,

Jag

Thanks,
Jag
Occasional Contributor ajb
Occasional Contributor
Posts: 18

Re: Creating an indicator variable based on missing variable values

Thank you so much!

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 703 views
  • 0 likes
  • 2 in conversation