how to exclude missing values in where statement

Jannie_D — Fri, 26 Feb 2021 13:55:40 GMT

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;

Re: how to exclude missing values in where statement

PaigeMiller — Fri, 26 Feb 2021 14:06:46 GMT

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

topic Re: how to exclude missing values in where statement in New SAS User

how to exclude missing values in where statement

Re: how to exclude missing values in where statement