Problem creating a panel data

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

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

mpsc19
Posts: 26
Joined: Mon Jul 10, 2017 8:41 am

Problem creating a panel data

Postby mpsc19 » Mon Mar 01, 2021 12:55 pm

Hello! Im using Eviews 9.
Im working with an Unstructured/undated workfile with 6818 observations (people 18 years and older) from 2010 to 2014:

Image

in the picture we can see the variable "A8ANIOTRIM" that reflects the quarter in which the observation appears (for example the person "29462013" appears in the first and second quarter of 2010 and the same for 2011), each observation appears in two quarters of one year and in two quarters of another year.

Then I modify the structure creating a panel data, when I do so, "A8ANIOTRIM" self-modifies and add the two missing quarters of each year (in which the observation does not appear) with no content:

Image

I can not delete it and it does not help me that they appear... help me please :| :|

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

Re: Problem creating a panel data

Postby EViews Gareth » Mon Mar 01, 2021 3:13 pm

When you restructure as the balance, don't check any of the "Balance" or "Insert" check boxes.
Follow us on Twitter @IHSEViews

mpsc19
Posts: 26
Joined: Mon Jul 10, 2017 8:41 am

Re: Problem creating a panel data

Postby mpsc19 » Tue Mar 02, 2021 12:27 pm

It was simpler than i thought, thanks!


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 7 guests