BookmarkSubscribeRSS Feed
mlogan
Lapis Lazuli | Level 10

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;

1 REPLY 1
ballardw
Super User

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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1068 views
  • 0 likes
  • 2 in conversation