Create a new workfile. The workfile becomes the active workfile.
Syntax
wfcreate(options) frequency[(subperiod_opts)] start_date end_date [num_cross_sections]
wfcreate(options) frequency[(subperiod_opts)] start_date +num_observations
wfcreate(options) u num_observations
The first form of the command may be used to create a new regular frequency workfile with the specified frequency, start, and end date. Subperiod options may also be specified for intraweek or intraday data. See table below for a complete description for each frequency. If you include the optional
num_cross_sections, EViews will create a balanced panel page using integer identifiers for each of the cross-sections. Note that more complex panel structures may be created using
pagestruct. You may use the
@now keyword to specify the current date/time as either the
start_date or
end_date.
The second form of the command may be used to create a new regular frequency workfile with a specified frequency, start date and number of observations. The end date is calculated as the start date plus the number of periods (determined by the frequency specification) given by num_observations.
The third form of the command is used to create an unstructured workfile with the specified number of observations.
Options
wf=wf_name | Optional name for the new workfile. |
page=page_name | Optional name for the page in the new workfile. |
prompt | Force the dialog to appear from within a program. |
Arguments
The frequency argument should be specified using one of the following forms:
Sec[opt], 5Sec[opt], 15Sec[opt], 30Sec[opt] | Seconds in intervals of: 1, 5, 15, or 30 seconds, respectively. You may optionally specify days of the week and start and end times during the day using the opt parameter. See explanation of subperiod options below. |
Min[opt], 2Min[opt], 5Min[opt], 10Min[opt], 15Min[opt], 20Min[opt], 30Min[[opt] | Minutes in intervals of: 1, 2, 5, 10, 15, 20, or 30 minutes, respectively. You may optionally specify days of the week and start and end times during the day using the opt parameter. See explanation of subperiod options below. |
H[opt], 2H[opt], 4H[opt], 6H[opt], 8H[opt], 12H[[opt] | Hours in intervals of: 1, 2, 4, 6, 8, or 12 hours, respectively. You may optionally specify days of the week and start and end times during the day using the opt parameter. See explanation of subperiod options below. |
D(s, e) | Daily with arbitrary days of the week. Specify the first and last days of the week with integers s and e, where Monday is given the number 1 and Sunday is given the number 7. (Note that the “D” option used to specify a 5-day frequency prior to EViews 7.) |
D5 or 5 | Daily with five days per week, Monday through Friday. |
D7 or 7 | Daily with seven days per week. |
W | Weekly |
T | Ten-day (daily in intervals of ten). |
F | Fortnight |
BM | Bimonthly |
M | Monthly |
Q | Quarterly |
S | Semi-annual |
A or Y | Annual |
2Y, 3Y, 4Y, 5Y, 6Y, 7Y, 8Y, 9Y, 10Y, 20Y | Multi-year in intervals of: 2, 3, 4, 5, 6, 7, 8, 9, 10, or 20 years, respectively. |
Subperiod options
EViews allows for setting the days of the week and the time of day within intraday frequencies, which include seconds, minutes, and hours. For instance, you may specify hourly data between 8AM and 5PM on Monday through Wednesday. These subperiod options should follow the frequency keyword and be enclosed in parentheses.
To specify days of the week, use integers to indicate the days, where Monday is given the number 1 and Sunday is given the number 7. For example,
wfcreate(wf=storehours) 30MIN(1-6, 8:00-17:00) 1/3/2000 12/30/2000
indicates a half-hour frequency that includes Monday through Saturday from 8AM to 5PM.
To specify the start and end times, you may use either a 24 hour clock, including minutes and optionally seconds, or a 12 hour clock using AM and PM. For example, each of the following represents 8PM: 8PM, 8:00PM, 8:00:00PM, 20:00, and 20:00:00. Thus, our previous example could have been written:
wfcreate(wf=storehours) 30MIN(1-6, 8AM-5PM) 1/3/2000 12/30/2000
If you wish to include all days of the week but would like to specify a start and end time, set the date range to include all days and then specify the times. The day of the week parameter appears first and is required if you wish to supply the time of day parameters. For instance,
wfcreate(wf=storehours) 30MIN(1-7, 10AM-3PM) 1/3/2000 12/30/2000
indicates a half-hour frequency from 10AM to 3PM on all days of the week.
You may also include a time with the start and end date parameters to specify partial days at the beginning or end of the workfile. For example,
wfcreate(wf=storehours) 30MIN(1-6, 8AM-5PM) 1/3/2000 10AM 12/30/2000 2PM
creates the same workfile as above, but limits the first day, 1/3/2000, to 10AM - 5PM and the last day, 12/30/2000, to 8AM - 2PM.
Alignment options
Certain frequencies optionally allow you to specify the starting point of the frequency period. Weekly and biweekly frequencies allow you to set the day at which the week begins. Annual, semiannual and quarterly frequencies allow you to set the month at which the quarter or year begins. Setting the starting period is important if you wish to use frequency conversion to convert data from a different frequency.
To specify the start period, simply add an extra term to the frequency symbol, surrounded in parenthesis, containing the day, or month, upon which you wish the frequency to start. For example:
wfcreate w(monday) 2000 2010
creates a weekly workfile from 2000 to 2010, where each week starts on a Monday.
wfcreate a(july) 2001 2007
creates an annual workfile where each year starts in July.
Note that by default, if you do not specify a starting point, EViews will use the period of the specified start_date. To make this difference concrete, consider the commands:
wfcreate w 2000 2010
and
wfcreate w(monday) 2000 2010
Since January 1st, 2000 was a Saturday, the first command will create a weekly workfile where each week starts on a Saturday, and the first observation in the workfile will span the period January 1st-January 7th 2000.
The second command will force EViews to start weeks on a Monday, and thus the first observation will actually span the period December 27th 1999 - January 2nd 2000.
Examples
wfcreate(wf=annual, page=myproject) a 1950 2005
wfcreate(wf=unstruct, page=undated) u 1000
creates two workfiles. The first is a workfile named ANNUAL containing a single page named MYPROJECT containing annual data from 1950 to 2005; the second is a workfile named UNSTRUCT containing a single page named UNDATED with 1000 unstructured observations.
wfcreate(wf=griliches_grunfeld, page=annual) a 1935 1954 10
creates the GRILICHES_GRUNFELD workfile containing a page named “ANNUAL” with 10 cross-sections of annual data for the years 1935 to 1954.
wfcreate(wf=fourday) D(1,4) 1/3/2000 12/31/2000
specifies a daily workfile from January 3, 2000 to December 31, 2000, including only Monday through Thursday. The day range may be delimited by either a comma or a dash, such that
wfcreate(wf=fourday) D(1-4) 1/3/2000 12/31/2000
is equivalent to the previous command.
wfcreate(wf=captimes) 15SEC(2-4) 1/3/2000 12/30/2000
creates a workfile with 15 second intervals on Tuesday through Thursday only, from 1/3/2000 to 12/30/2000.
wfcreate m 1995 +30
will create a monthly workfile starting in January 1995 and ending in July 1997.
Cross-references