BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Jannie_D
Calcite | Level 5

I am creating sub populations and in that proces I encountered a problem. because I use th symbol < in a where statement it includes all missing values too (for dato_diagnose). How can I get around that? 

the code is

 

 

data POP4_01;

set All1;

where not missing(koloskopi1_dt) and Dato_diagnose<182+LabSvar;

run;

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
PaigeMiller
Diamond | Level 26
where not missing(koloskopi1_dt) and not missing(dato_diagnose) and  Dato_diagnose<182+LabSvar;
--
Paige Miller

View solution in original post

1 REPLY 1
PaigeMiller
Diamond | Level 26
where not missing(koloskopi1_dt) and not missing(dato_diagnose) and  Dato_diagnose<182+LabSvar;
--
Paige Miller