Jeff
Jeff

Reputation: 29

how to generate a calendar for year using SAS

I want to generate a column(i.e. dates) to save calendar date for a given year for example:

     `dates`
  01jan2019
  02jan2019
  ....
  28jan2019
  01feb2019
  .....
  31dec2019

Upvotes: 0

Views: 698

Answers (1)

Stu Sztukowski
Stu Sztukowski

Reputation: 12909

SAS dates are just the number of days since Jan 1st 1960. Use date literals and a do-loop.

data dates;
    format date date9.;

    do date = '01jan2019'd to '31dec2019'd;
        output;
    end;
run;

Upvotes: 1

Related Questions