So I've made some progress on this problem. The following code helped me add a monthly column. data Monthly;
set Quarterly;
if qtr = 1 then do;
do month = 1 to 3;
output;
end;
end;
if qtr = 2 then do;
do month = 4 to 6;
output;
end;
end;
if qtr = 3 then do;
do month = 7 to 9;
output;
end;
end;
if qtr = 4 then do;
do month = 10 to 12;
output;
end;
end;
run; I have my table in the desired structure below, but the values are duplicates of the beginning quarterly value. Have Region Year Qtr Month Value North 2001 1 1 100 North 2001 1 2 100 North 2001 1 3 100 North 2001 2 1 103 North 2001 2 2 103 North 2001 2 3 103 North 2001 3 1 106 I want to take the difference between month 1 in a given year and month 1 in the prior year, divide the total by three, and add that amount to month 2, then month 3. Example in the table below. Want Region Year Qtr Month Value North 2001 1 1 100 North 2001 1 2 101 North 2001 1 3 102 North 2001 2 1 103 North 2001 2 2 104 North 2001 2 3 105 North 2001 3 1 106
... View more
