Caluclations of Panel Data (i,t) with distribution of i

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

Posts: 1
Joined: Mon Jun 05, 2017 11:45 am

Caluclations of Panel Data (i,t) with distribution of i

Postby abhmail » Tue Jun 06, 2017 1:00 pm

I have a panel data set (age and year).

But some series in the panel (e.g. Average Income) are derived from a distribution. So I have another distribution (age and level). It does not vary by time.

In addition, there are some series that vary only by year (e.g. Income Growth).

[Attached XLS shows these 3 template sheets.]
(30.5 KiB) Downloaded 31 times

I have imported the data in 3 different pages. But how do I perform calculations using series from different pages -

1. Can I refer to a series from one page without copying? If yes, how to refer to a i,t data of a series on a page?

for !year = 1 to 78
for !age = 1 to 52
for !level = 1 to 79


2. If not, do I have create a page with year, (age*level) as category? That will increase the sample size unnecessarily (even though levels don't change by year).

Any help will be greatly appreciated.


EViews Gareth
Fe ddaethom, fe welon, fe amcangyfrifon
Posts: 11813
Joined: Tue Sep 16, 2008 5:38 pm

Re: Caluclations of Panel Data (i,t) with distribution of i

Postby EViews Gareth » Tue Jun 06, 2017 1:24 pm

You can use pagename\series name to refer to a series on another page. But you're probably better off copying them over so you know exactly what is going on.
Follow us on Twitter @IHSEViews

Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 5 guests