Page 1 of 1

converting unstructured data to dated series

Posted: Thu Mar 19, 2015 6:53 am
by EviewsUser1
Below are the essential lines from a very large program (too large to attach).
I start with unstructed data then create a matrix 27 rows by 22 columns called f_di_sub. I convert the matrix to a group of 22 series -- the group name is datser_f.
I then copy the group to a dated page with freq=A. The g=s command did not work -- only gave me the group definition, not the individual series.
I then copy the annual series to a quarterly page and the result is a series that goes from 1988q1 through 1994q3 -- 27 observations long. I would like it to interpolate the series to quarterly from 1988q1 through 2014q4. How can I do that?

Thanks.

wfcreate(wf=work, page=page1) u 8232696

smpl 1 27
mtos(f_di_sub,datser_f)
':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
'::::::::::::::::::::::::::::::::: CREATE NEW PAGE WITH ANNUAL FREQUENCY :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
pagecreate(page=annual) a 1988 2014
copy(g=d) page1\datser_f
':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
'::::::::::::::::::::::::::::::::: CREATE NEW PAGE WITH QUARTERLY FREQUENCY ::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
':::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
pagecreate(page=quarterly) q 1988q1 2014q4
copy(g=d) page1\datser_f

Re: converting unstructured data to dated series

Posted: Thu Mar 19, 2015 7:45 am
by EViews Gareth
What sort of interpolation do you want to do?

Whatever it is, you'll do it using the c= option on the copy command.

Re: converting unstructured data to dated series

Posted: Thu Mar 19, 2015 8:41 am
by EviewsUser1
I tried

pagecreate(page=quarterly) q 1988q1 2014q4
copy(g=d,=q) page1\datser_f

and that didn't solve the problem

Re: converting unstructured data to dated series

Posted: Thu Mar 19, 2015 9:02 am
by EViews Gareth
Did you try c=q?