10-22-2011 09:13 AM
I need help from some proc expand experts
I have data that has date and units by quarter.. I want it to expand it by month but when the total for the year (by 12 months) is added up it remains the same as the 4 quarters.
and so on...
so in the 'want' the sum for the 2000.01 & 2000.02 & 2000.03 remain 33 as per before.
11-07-2011 06:55 PM
input date:yyq. y;
format date yyq.;
proc expand to=month extrapolate method=step;
convert y / tout=(/3);
11-07-2011 06:56 PM
This post was just shown as a new post even though it is a month old. Surely someone must have asked the obvious questions: (1) does it HAVE to be done with proc Expand? and (2) what determines the proportion of the split for each month?
If you only need quarter expanded to month, and the percents to be equally split between the three months, and it can be accomplished in a datastep, the task is trivial.