Problem in where statement

Jannie_D — Fri, 18 Dec 2020 10:59:13 GMT

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

Re: Problem in where statement

PaigeMiller — Fri, 18 Dec 2020 11:35:10 GMT

where not missing(dato_diagnose) and dato_diagnose < invi_sendtdt1;

topic Problem in where statement in New SAS User

Problem in where statement

Re: Problem in where statement