Generate Series Skills

This part shows you how generate new series before you run the regression and forecasting. Some basic skills will be shown as below:

  1. Basic Skill for Generating Series
  2. Add, Subtract, Multiply and Divide
  3. Raise to the Power
  4. Square Root
  5. Take Log Form
  6. Difference [X - X(-1)]
  7. Set Seasonal Dummy
  8. Set Trend


Basic Skill for Generating Series

Step 1 : After opening a workfile, select Objects in Eviews.
Step 2 : Select New Object in the menu to create new series.
Step 3 : Select Series as the type of object and type a name as you like in the Name for Object box. The name "Untitled" is used as an example.
Step 4 : After clicking OK button, a new series will form. The name you named before will be shown at the top of the new series ("Untitled" in this example). Data can be type in those NA boxes. Then the new series will completely formed.
Back to the top


Add, Subtract, Multiply and Divide

Step 1 : Using exiting series to general new series by adding, subtract, multipling and dividing them. Select Gener in Eviews.
Step 2 : A dialog is shown and you can type in the equation of the new series. Type the name to be given to the new series such as new in this example, an "=" sign, and the formula describing now to calculate the new series such as cs + gdp in this example. You can change the sign of "+" for "-" (subtract), "*" (multiply) or "/" (divide) as needed.
Step 3 : After clicking OK button, a new series will form. The name will be shown as you named before ("new" in this example).
Back to the top


Raise to the Power

Step 1 : Using exiting series to general new series by raising to the power. Select Gener in Eviews.
Step 2 : A dialog is shown and you can type in the equation of the new series. Type the name to be given to the new series such as new_cs in this example, an "=" sign, and the formula describing now to calculate the new series such as cs^2 in this example. Using the sign "^" means the power of the exiting series. In this example, new_cs is the square of cs.
Step 3 : After clicking OK button, a new series will form. The name will be shown as you named before ("new_cs" in this example).
Back to the top


Square Root

Step 1 : Using exiting series to general new series by taking the square root. Select Gener in Eviews.
Step 2 : A dialog is shown and you can type in the equation of the new series. Type the name to be given to the new series such as sr_cs in this example, an "=" sign, and the formula describing now to calculate the new series such as sqr(cs) in this example. Using "sqr( )" means the square root of the exiting series. In this example, sr_cs is square root of cs.
Step 3 : After clicking OK button, a new series will form. The name will be shown as you named before ("sr_cs" in this example).
Back to the top


Take Log

Step 1 : Using exiting series to general new series in log form. Select Gener in Eviews.
Step 2 : A dialog is shown and you can type in the equation of the new series. Type the name to be given to the new series such as ln_cs in this example, an "=" sign, and the formula describing now to calculate the new series such as log(cs) in this example. Using "log( )" means the natural logarithm of the exiting series. In this example, ln_cs is the natural logarithm of cs.
Step 3 : After clicking OK button, a new series will form. The name will be shown as you named before ("ln_cs" in this example).
Back to the top


Differnce [X - X(-1)]

Step 1 : Using exiting series to general new series for first difference. Select Gener in Eviews.
Step 2 : A dialog is shown and you can type in the equation of the new series. Type the name to be given to the new series such as dif_cs in this example, an "=" sign, and the formula describing now to calculate the new series such as d(cs) in this example. Using "d( )" means the first difference of the exiting series. In this example, dif_cs is the first difference of cs which is cs - cs(-1).
Step 3 : After clicking OK button, a new series will form. The name will be shown as you named before ("dif_cs" in this example).
Back to the top


Set Seasonal Dummy

Step 1 : Using exiting data to general new series by setting seasonal dummy. Select Gener in Eviews.
Step 2 : A dialog is shown and you can type in the equation of the new series. Type the name to be given to the new series such as sea_dummy in this example, an "=" sign, and the formula describing now to calculate the new series such as @seas(1) in this example. Using "@seas( )" to set the seasonal dummy of the data. @seas(1) means setting the first quarter or month equal to one, others equal to zero. @seas(2) means setting the second quarter or month equal to one, others equal to zero and so on.
Step 3 : After clicking OK button, a new series will form. The name will be shown as you named before ("sea_dummy" in this example).
Back to the top


Set Trend

Step 1 : Using exiting data to general new series by setting trend. Select Gener in Eviews.
Step 2 : A dialog is shown and you can type in the equation of the new series. Type the name to be given to the new series such as trend in this example, an "=" sign, and the formula describing now to calculate the new series such as @trend(1947:1) in this example. Using "@trend( )" to set the trend of the data. The date in the parenthesis is the begining date of the trend which equals zero in the new series. In this example, @trend(1947:1) means setting the first quarter of 1947 equal to zero and accumulates one more unit in each coming quarter.
Step 3 : After clicking OK button, a new series will form. The name will be shown as you named before ("trend" in this example).
Back to the top


All right reserved by Dr. Bill Hung.