BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
ayosas
Fluorite | Level 6
set ile.nhanes2016 (keep= SMQ040 IMQ060 IMQ070 IMQ100 RIAGENDR 
RIDAGEYR DMDCITZN DMDMARTL BMXBMI DMDEDUC2 INDHHIN2
MCQ220);
if IMQ070=. and IMQ060=. then delete;
run;

proc freq data=ile.nhanes2016;
tables IMQ060 IMQ070 / nocum missing;
run;

IMQ070 value is for males and IMQ060 is for females. Subjects have a value for one and not the other. I want to delete missing values. After running the code missing values remain for both males and females, is there something wrong with my code?

 

Screen Shot 2021-07-06 at 7.10.45 PM.png

1 ACCEPTED SOLUTION

Accepted Solutions
Reeza
Super User
You're only deleting records where BOTH are missing, you want to delete records where either are missing and use OR instead of AND.


if IMQ070=. or IMQ060=. then delete;

However, since you can only be one, I don't think that's what you want either as that will delete all record essentially since the other one will always be the opposite.

I would suggest creating a new variable HPV vaccine:

HPV_Vaxx = coalesce(IMQ070, IMQ060);
if missing(IMQ070) then gender=0; else gender=1;


View solution in original post

2 REPLIES 2
Reeza
Super User
You're only deleting records where BOTH are missing, you want to delete records where either are missing and use OR instead of AND.


if IMQ070=. or IMQ060=. then delete;

However, since you can only be one, I don't think that's what you want either as that will delete all record essentially since the other one will always be the opposite.

I would suggest creating a new variable HPV vaccine:

HPV_Vaxx = coalesce(IMQ070, IMQ060);
if missing(IMQ070) then gender=0; else gender=1;


ayosas
Fluorite | Level 6
Thank you!! This worked, much appreciation

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

What is Bayesian Analysis?

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 610 views
  • 2 likes
  • 2 in conversation