converting unstructured data to dated series
Posted: 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
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