topic Re: 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, 16 Apr 2020 10:01:35 GMT

I want to create a time series field between two dates such that there is only one entry for each month and the day in that entry is the last day of that specific month.

For ex:-

Input:-

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

Output:-

31/01/18

28/02/18

31/03/18

30/04/18

31/10/20

30/11/20

31/12/20

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

Kurt_Bremser — Thu, 16 Apr 2020 10:25:20 GMT

Use the intnx() function to calculate your end-of-period values:

cur_date = intnx('month',start_date,0,'e');
do while (cur_date le end_date);
  output;
  cur_date = intnx('month',cur_date,1,'e');
end;

It is, of course, assumed that start_date and end_date contain SAS date values.

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

kelxxx — Thu, 16 Apr 2020 10:39:44 GMT

options yearcutoff=2000;
 
%let indate=01/01/18;
%let outmon=12/18;

data toto;
sdate=input("&indate",ddmmyy8.);
emon=input("01/&outmon",ddmmyy8.);
edate=intnx ('month',emon,0,'E');
days=edate-sdate;
do i=0 to days;
datest=sdate+i;
output;
end;
format datest ddmmyy8.;
keep datest;
run;

Hi,

it is not optimal but it works

have a nice day.