How to split panel data into different terciles/subsample

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

NimUnited
Posts: 4
Joined: Sun Mar 18, 2018 11:26 am

How to split panel data into different terciles/subsample

Postby NimUnited » Tue May 01, 2018 3:24 am

Hello,

We have an unbalanced panel data that we want to split into three different terciles or subsamples based on one of the control variables (market value of assets).

Do anyone know how to divide the data into three subsamples based on medians from market value of assets?

It is a 10-year panel data, and the market value of assets changes along the years. Does Eviews divide the data based on the 10-year average of market value of assets or?

Thank you in advance

Best regards

Steffan

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

Re: How to split panel data into different terciles/subsample

Postby EViews Gareth » Tue May 01, 2018 7:20 am

Without more details it is hard to be more helpful, but perhaps something like:

Code: Select all

smpl if x>@median(x)
Follow us on Twitter @IHSEViews


Return to “Data Manipulation”

Who is online

Users browsing this forum: Google [Bot] and 5 guests