SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Where clause with missing dates

Accepted Solution Solved
Reply
Regular Contributor
Posts: 215
Accepted Solution

Where clause with missing dates

Hi All,

I wanted to do a query where I will get all dates within a range and the cells where the dates are missing. I wrote the following code, but it's not working. Can someone please help.

 

Data want;
set have;
WHERE start_date between "01Oct2014"d and "30Sep2015"d and start_date = .;
RUN;


Accepted Solutions
Solution
‎10-30-2015 12:18 PM
Super User
Posts: 10,526

Re: Where clause with missing dates

OR start_date=.

 

Cannot be between two dates and missing at the same time

View solution in original post


All Replies
Solution
‎10-30-2015 12:18 PM
Super User
Posts: 10,526

Re: Where clause with missing dates

OR start_date=.

 

Cannot be between two dates and missing at the same time

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 261 views
  • 2 likes
  • 2 in conversation