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!!
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
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
Thank you so much!
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.