topic How can I create a time series field between two dates? in SAS Programming

How can I create a time series field between two dates?

Saurabh_Rana — Thu, 09 Apr 2020 06:29:39 GMT

I want to create a time series field between two dates where day is not mentioned, only month and year is mentioned.

For ex:-

Input:-

Start Date = 01/01/18 End Date = 31/12/20

Output:-

01/18

02/18

03/18

10/20

11/20

12/20

Re: How can I create a time series field between two dates?

Kurt_Bremser — Thu, 09 Apr 2020 06:46:11 GMT

First of all: never use two-digit years. After the Y2K scare, this should be an absolute given for anybody involved in the IT business.

Second, don't use date formats in a non-hierarchical order (MY in your case). Start with the most significant part (years). This helps in ordering when formatted values are used.

Third, use SAS date values when dates are involved. If you only need year/month, use the same day (day 1 in the following example) for each period.

data want;
period = '01jan2018'd;
do while (period le '01dec2020'd);
  output;
  period = intnx('month',period,1,'b');
end;
format period yymms7.;
run;