Print Missing Date (From the Last x Number of Days)

JackoNewbie — Mon, 03 Feb 2020 19:23:13 GMT

Hi 🙂

What is the best way to print a date that holds no data in a large dataset for a specific date range? For example, I halve multiple records in one dataset for the last 7 days. In the dataset one of the dates in the last 7 days contains no data. How would I write code for SAS to highlight which date holds no data?

In the below, I would want SAS to highlight 01/31/2020 as this is the date that is missing from the last 7 days.

data have;

     input date:mmddyy10.  car_key;

     format date mmddyy10.;

     cards;

01/28/20 20071031
01/29/20 20070930
01/30/20 20070831
02/01/20 20070831
02/02/20 20070630
02/03/20 20070531

;RUN;

Re: Print Missing Date (From the Last x Number of Days)

tomrvincent — Mon, 03 Feb 2020 19:35:51 GMT

I created a hundred-year calendar dataset which I can then right-join to a dataset like your 'have' to easily select missing dates.

topic Print Missing Date (From the Last x Number of Days) in SAS Programming

Print Missing Date (From the Last x Number of Days)

Re: Print Missing Date (From the Last x Number of Days)