Data mining with where clause

mlogan — Tue, 24 Mar 2015 16:08:59 GMT

can anyone tell me why my following code is not working? I am trying to find all All records where City is Chicago and there is no Date. Note that in my sas databse it puts a dot(.) where date variable is missing.

Name City Date

John Chicago 2015-02-01

Albert Toronto .

Alice Sydney 2015-02-01

Albert Chicago .

Here is my code:

data new;

set info;

where City='Chicago' and Date<>' ';

run;

Re: Data mining with where clause

ballardw — Tue, 24 Mar 2015 16:17:27 GMT

Is your date variable a character or numeric? It may be numeric in which case use Date = . or Missing(date). Missing(date) would be better as it doesn't care if the variable is numeric or character.

topic Data mining with where clause in SAS Data Science

Data mining with where clause

Re: Data mining with where clause