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;