Sort 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

pelleenglund
Posts: 24
Joined: Fri Sep 16, 2016 6:35 am

Sort panel data

Postby pelleenglund » Thu Sep 26, 2019 5:50 am

Hello,

I wonder if one could sort panel data in Eviews by year instead of ID (see example below)? Right now I can only get all years for the first ID, then all years for the next and so on.

ID Year Series
1 1995 12
2 1995 ..
3 1995 ..
1 1996 ..
2 1996
3 1996
1 1997
2 1997
3 1997

Best regards,
Per

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

Re: Sort panel data

Postby EViews Gareth » Thu Sep 26, 2019 7:26 am

Not really.

You could restructure the panel as an undated panel, and then have the time and cross-section identifiers in any order you want, but then you'll lose all date functionality.
Follow us on Twitter @IHSEViews

pelleenglund
Posts: 24
Joined: Fri Sep 16, 2016 6:35 am

Re: Sort panel data

Postby pelleenglund » Fri Sep 27, 2019 1:57 am

Thanks for ýour answer.

The reason I asked had to do with the new geomap objects. It doesn't seem to connect the map id (e.g. a municipality code) with the corresponding code in the dataset for a panel. But it works fine if you only look for one year separately.

/Pelle

EViews Glenn
EViews Developer
Posts: 2672
Joined: Wed Oct 15, 2008 9:17 am

Re: Sort panel data

Postby EViews Glenn » Wed Oct 30, 2019 11:54 am

It should work. Can you give us a bit more detail on precisely what you are doing, what you expect, and what you are seeing.

Thanks.


Return to “Data Manipulation”

Who is online

Users browsing this forum: No registered users and 25 guests