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?
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.