Page 1 of 1
fetching and converting at the same time
Posted: Mon Apr 03, 2017 2:32 pm
by 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
Re: fetching and converting at the same time
Posted: Mon Apr 03, 2017 2:36 pm
by EViews Gareth
Re: fetching and converting at the same time
Posted: Tue Apr 04, 2017 7:54 am
by 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
Re: fetching and converting at the same time
Posted: Tue Apr 04, 2017 8:52 am
by EViews Gareth
Could you provide the files?
Re: fetching and converting at the same time
Posted: Tue Apr 04, 2017 10:24 am
by 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
Re: fetching and converting at the same time
Posted: Tue Apr 04, 2017 12:08 pm
by 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.
Re: fetching and converting at the same time
Posted: Tue Apr 04, 2017 1:36 pm
by 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
If you calculate the average of 2016Q2 to 2017Q1 you get the number in for 2016 in the annual page.
Re: fetching and converting at the same time
Posted: Tue Apr 04, 2017 2:38 pm
by 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.
Re: fetching and converting at the same time
Posted: Tue Apr 04, 2017 2:41 pm
by 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.
Re: fetching and converting at the same time
Posted: Wed Apr 05, 2017 6:52 am
by 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
Re: fetching and converting at the same time
Posted: Wed Apr 05, 2017 1:26 pm
by 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