Page 1 of 1

Panel dataset frequency conversion

Posted: Thu Feb 24, 2011 3:24 pm
by tchaithonov
Hey Guys,

I am trying to convert a monthly panel dataset to daily by constant-match sum and it looks like in the daily page, the daily numbers are exactly the same as the monthly (so, say for Jan 2008, if the value is 310 for the month, the value in the daily tab should be 10 per the 31 days of Jan 2008. It came out to be 310 per day). I don't know if it's an issue before as I usually don't need to split data this way. Would you please let me know? Thanks.

Tcahithonov

Re: Panel dataset frequency conversion

Posted: Thu Feb 24, 2011 3:28 pm
by EViews Gareth
Could you post an example workfile?

Re: Panel dataset frequency conversion

Posted: Thu Feb 24, 2011 4:17 pm
by EViews Gareth
My quickly knocked up example seems to work right:

Code: Select all

create(page="monthly") m 1990 1995 10 rndseed 1 series y=rnd smpl 1990:1 1990:1 scalar dailyval = @mean(y)/31 show dailyval pagecreate(page="daily") d7 1990 1995 copy(c=d) monthly\y daily\y show y