Where clause with missing dates

mlogan — Thu, 22 Oct 2015 14:49:45 GMT

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;

Re: Where clause with missing dates

ballardw — Thu, 22 Oct 2015 14:51:39 GMT

OR start_date=.

Cannot be between two dates and missing at the same time

topic Where clause with missing dates in SAS Data Management

Where clause with missing dates

Re: Where clause with missing dates