Problem in where statement

[Jannie_D]

Hi all. As a beginner working in SAS I now encountered a problem with my where statement:

data pop1:

set DTSDCCG;

where dato_diagnose NE Is Missing and dato_diagnose < invi_sendtdt1;

run;

the problem seems to be about the first part of the where statement I want to exclude all the dato_diagnose that have no value and include all where dato_diagnose<invisendt1.

I cannot find the mistake. Can you help me

[PaigeMiller · Accepted solution]

where not missing(dato_diagnose) and dato_diagnose < invi_sendtdt1;