topic Adding Date Rows to dataset in New SAS User

Adding Date Rows to dataset

Solly7 — Mon, 21 Oct 2019 08:55:35 GMT

Hi All, i have below data. So what i need to do is to add months after an each renewal. i.e if renewal date is 1-apr-2012, i need to add 12 months until i reach 1-apr-2013( i.e i need to add 1-may-2012, 1-jun-2012 till 1-april 2013).

see my below data

Renewal date Transaction type

1-april-2012 R

1-april-2013 R

1-april-2014 R

Re: Adding Date Rows to dataset

ed_sas_member — Mon, 21 Oct 2019 09:20:21 GMT

Hi @Solly7 ,

I suggest to use the intnx() function as follows. This function applies multiples of a given interval to a date and returns the resulting value.

data want;
	set have;
	format Renewal_date2 date9.;
	do i=1 to 12;
		Renewal_date2 = intnx('month',Renewal_date,i-1);
		output;
	end;
	drop i Renewal_date;
	rename Renewal_date2 = Renewal_date;
run;

Re: Adding Date Rows to dataset

Solly7 — Mon, 21 Oct 2019 09:50:46 GMT

Hi , your solutions works. thanks a lot