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

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1082 views
  • 0 likes
  • 2 in conversation