converting unstructured data to dated series

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Moderator, EViews Jason, EViews Matt

EviewsUser1
Posts: 40
Joined: Thu Aug 28, 2014 8:08 am

converting unstructured data to dated series

Postby EviewsUser1 » Thu Mar 19, 2015 6:53 am

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

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: converting unstructured data to dated series

Postby EViews Gareth » Thu Mar 19, 2015 7:45 am

What sort of interpolation do you want to do?

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

EviewsUser1
Posts: 40
Joined: Thu Aug 28, 2014 8:08 am

Re: converting unstructured data to dated series

Postby EviewsUser1 » Thu Mar 19, 2015 8:41 am

I tried

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

and that didn't solve the problem

EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 13604
Joined: Tue Sep 16, 2008 5:38 pm

Re: converting unstructured data to dated series

Postby EViews Gareth » Thu Mar 19, 2015 9:02 am

Did you try c=q?


Return to “Programming”

Who is online

Users browsing this forum: No registered users and 2 guests