Copy pages from different workfiles with date conversion
Posted: Thu Jul 08, 2010 1:53 pm
Hello. Thank you for the support in the forum. It´s been really helpful.
I wanted to ask you something about date conversion when copying pages from an old to a new workfile and converting the date frequency when doing it.
I need to go from daily data to monthly data. The commands I used were these:
1) For the creation of a new workfile with monthly dates:
wfcreate(wf=Monthly_VAR, page=p_Monthly_VAR) m 1986m01 2010m12. So dates are from January 1986 to December 2010
2) Importing daily data "Inflation" to the workfile "Monthly_VAR" from the workfile "Daily_VAR", using an average conversion for the data:
copy(c=a) Daily_VAR::p_Daily_VAR\Inflation Monthly_VAR::p_Monthly_VAR\
The workfile "Daily_VAR" is structured using a series id in the form "mm/dd/yy". However, after the series "Inflation" is copied in the page "p_Monthly_VAR", the transformed data doesn´t match the date structure for the page "p_Monthly_VAR". For example, the original data goes from "01/02/1998" to "06/22/2009", and after copying it and converting its frequency, in the page "p_Monthly_VAR" I get "NA´s" from 1986m01 to 2000m12, and from 2009m05 to 2010m12, but in the original data actually I do have data from 1998 to 2009, so I am not sure if I´m doing something wrong making months not to match for the frequency conversion.
Thank you very much.
Regards.
I wanted to ask you something about date conversion when copying pages from an old to a new workfile and converting the date frequency when doing it.
I need to go from daily data to monthly data. The commands I used were these:
1) For the creation of a new workfile with monthly dates:
wfcreate(wf=Monthly_VAR, page=p_Monthly_VAR) m 1986m01 2010m12. So dates are from January 1986 to December 2010
2) Importing daily data "Inflation" to the workfile "Monthly_VAR" from the workfile "Daily_VAR", using an average conversion for the data:
copy(c=a) Daily_VAR::p_Daily_VAR\Inflation Monthly_VAR::p_Monthly_VAR\
The workfile "Daily_VAR" is structured using a series id in the form "mm/dd/yy". However, after the series "Inflation" is copied in the page "p_Monthly_VAR", the transformed data doesn´t match the date structure for the page "p_Monthly_VAR". For example, the original data goes from "01/02/1998" to "06/22/2009", and after copying it and converting its frequency, in the page "p_Monthly_VAR" I get "NA´s" from 1986m01 to 2000m12, and from 2009m05 to 2010m12, but in the original data actually I do have data from 1998 to 2009, so I am not sure if I´m doing something wrong making months not to match for the frequency conversion.
Thank you very much.
Regards.