fetching and converting at the same time

[miorinnovo]

When I fetch a monthly series form a database into an annual workpage the conversion automatically is done by summing. How do I fetch it and have it average instead?

Thanks

[EViews Gareth]

http://www.eviews.com/help/helpintro.ht ... fetch.html

[miorinnovo]

Thanks

I'm using c=a to convert quarterly to annual, but an odd thing is happening. The last data available right now is 2017Q1, and its averaging the years going from Q2 to Q1 instead of the regular calendar year.

Any idea why or how to fix?

Thanks

[EViews Gareth]

Could you provide the files?

[miorinnovo]

Well I'm fetching form an internal database but the relevant code is just the following:

Code: Select all

smpl 1981 2016
fetch(d=database, c=a) variablename



[EViews Jason]

I am not seeing the described behavior. We are going to need more information.

Please post or send the files or screenshots to support@eviews.com.

[miorinnovo]

When I import the quarter data into a quarterly page I get:

Code: Select all

2016Q1   529506
2016Q2   529667
2016Q3   530128
2016Q4   530376
2017Q1   529696


But when I use the following code to import into an annual page

Code: Select all

smpl 1981 2016
fetch(d=database, c=a) variablename


I get

Code: Select all

2015   529043.75
2016   529966.75


If you calculate the average of 2016Q2 to 2017Q1 you get the number in for 2016 in the annual page.

[miorinnovo]

I was able to work around the problem by importing the data into a quarterly page and then copying it over to the annual page.

[EViews Jason]

How is your workfile structured? If you double click "Range" in the workfile window, a dialog will appear. Please post a screenshot of that workfile.

Secondly if you open the database and double click the series you are fetching, a preview window containing meta information about the series should appear. Please post a screenshot of that as well. I would like to see the frequency and start and end dates of the series.

Thirdly, also make sure your copy of EViews is up to date. Select help->EViews update to obtain the latest version.

[miorinnovo]

1- The workfile structure is annual 1961-2017
2- I'm not sure how to open the database
3- My version is 9.5 January 7 2016 build

[EViews Jason]

Can you update your copy? You are using a version more than a year old.

If the problem persists after updating, I will need a copy of your database. Please send to support@eviews.com