how do I use if/and/delete statement to delete sex-dependent values

[ayosas]

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?

[Reeza · Accepted solution]

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]

Thank you!! This worked, much appreciation