07-20-2016 11:36 AM
I have a table A and I want to duplicate each row into a table B, N times.
In table A Ifor each row have:
a date d
In table B i would like:
the date d + 1 month for each new row
a number m, calculated according to new date
So I do something like
data B; set A; do i=0 to N; d = INTNX('month', d, +1, 'e'); m =...;
But the issue with this, is that the original record from A is deleted and we have only date d+1 to d+n and no longer d.
I would like the programm to understand it need to keep the initial date too, and to calculate for this date the number m
Can you help me?
Thank you very much
07-20-2016 12:05 PM - edited 07-20-2016 12:14 PM
There should be a variety of ways to make this happen. Here's one possibility:
do i=0 to N;
***** EDITED to move the first OUTPUT statement.
This assumes that all else is working properly, except for getting that first calculation into the output.
07-20-2016 01:42 PM
If you want both d and the new date in your output, you need two variables, right?
data B; set A; do i = 0 to N; newD = INTNX('month', d, i, 'END'); m =...; output; end; run;