Making Calculations in panel data within a series

For questions regarding the import, export and manipulation of data in EViews, including graphing and basic statistics.

Moderators: EViews Gareth, EViews Steve, EViews Jason, EViews Moderator, EViews Pamela

yasinuzun
Posts: 1
Joined: Thu Jun 22, 2017 10:26 am

Making Calculations in panel data within a series

Postby yasinuzun » Thu Jun 22, 2017 1:21 pm

Hi everyone,
I hope you're doing great.
I have a question and could not find the answer in the previous topics.
I have a panel data. one of the series is the GDPs of some countries. I want to make calculations using the data within this GDP series, for example, dividing the GDP of all other countries to GDP of USA. This is a part of a long formula.
So, the GDP (cgdpo in the attached file) data is simply;
S. Arabia-1970
S. Arabia-2014
USA-1970
USA-2014

I need to calculate S. Arabia/USA for each year to be used in another calculation.
I need to do this for 190 countries so I need an easy way doing this other than working in a time series and stacking into panel.
Thank you very much for your help.
Kind regards,
Attachments
penn_table_replicatingtfp (1).wf1
cgdpo in the spreadsheet
(36.47 KiB) Downloaded 20 times

startz
Non-normality and collinearity are NOT problems!
Posts: 3151
Joined: Wed Sep 17, 2008 2:25 pm

Re: Making Calculations in panel data within a series

Postby startz » Thu Jun 22, 2017 2:18 pm

Roughly

Code: Select all

series GDPUSA = @meansby(cgdpo,@date,"if countrycode=""USA""")
series ratio = cgdpo/GDPUSA


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 4 guests