Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Data mining with where clause

Reply
Regular Contributor
Posts: 218

Data mining with where clause

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;

Super User
Posts: 11,343

Re: Data mining with where clause

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.

Ask a Question
Discussion stats
  • 1 reply
  • 215 views
  • 0 likes
  • 2 in conversation