Data mining with where clause

[mlogan]

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;

[ballardw]

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.