topic Re: Adding another row based on conditions in SAS Programming

Adding another row based on conditions

Sangho — Fri, 24 Feb 2017 02:13:54 GMT

I want to add another row based on the value.

In the data below, for the first observation, for example, for firm 1, starting from 15-JAN-2012, for every 12 month, for 3 times, I need to give $1000. For observation 4, for firm 2, starting from 05-FEB-2015, every 6 month, for two times, I need to give firm $1000. (I just put two firms for brevity)


data schedule;
 input firmid startdate mmddyy10. unit times amount;
 datalines;
1 01/15/2012 12 3 1000
1 03/15/2013 12 1 2000
1 01/30/2011 3 4 500
2 02/05/2015 6 2 1000
;
run;

proc print data=schedule;
format startdate date11.;
run;

In the end, I need a table that looks like below

Could you please help me creating this table?

Thanks!

Re: Adding another row based on conditions

LaurieF — Fri, 24 Feb 2017 02:22:43 GMT

Here you go:

data schedule;
 input firmid startdate mmddyy10. unit times amount;
 attrib startdate length=4 format=date9.;
 datalines;
1 01/15/2012 12 3 1000
1 03/15/2013 12 1 2000
1 01/30/2011 3 4 500
2 02/05/2015 6 2 1000
;
run;

data want;
set schedule;
output;
do i = 1 to times - 1;
   startdate = intnx('month', startdate, unit, 's');
   output;
   end;
keep firmid startdate amount;
run;

Re: Adding another row based on conditions

Sangho — Fri, 24 Feb 2017 02:53:48 GMT

It works great! Thank you so much.