frequency convert 2month
Posted: Wed Feb 24, 2010 6:01 am
Hi all,
I'm trying to convert monthly to quarterly frequency, but not to take the simply average, ... this is to easy ;o)
copy(c=na,smpl="1991 2011") MData\* QData\*
My current problem is construct the quarterly value by
1) the 2nd month of a quarter only (Is there a command similar to c=second?)
or
2) the average of the 1st and 2nd month( c=average(1+2)?)
I thougt about an "ifsample" condition, but didn't find an answer so far?
Anybody have already solved this problem?
Thanks in advance, Katjes
I'm trying to convert monthly to quarterly frequency, but not to take the simply average, ... this is to easy ;o)
copy(c=na,smpl="1991 2011") MData\* QData\*
My current problem is construct the quarterly value by
1) the 2nd month of a quarter only (Is there a command similar to c=second?)
or
2) the average of the 1st and 2nd month( c=average(1+2)?)
I thougt about an "ifsample" condition, but didn't find an answer so far?
Anybody have already solved this problem?
Thanks in advance, Katjes