There is a particular way of representing the panel data for analyzing in STATA and EViews. Irrespective of the number of variables or cross sections, the data needs to be formatted in a typical way.
Following is the generalized structure of a panel dataset, which can be analyzed in STATA and EViews:
Cross Section | Cross Section ID | Time Series | Variable 1 | Variable 2 | Variable 3 | Variable 4 |
---|---|---|---|---|---|---|
Cross Section 1 | Cross Section ID 1 | Time Period 1 | Value # | Value # | Value # | Value # |
Cross Section 1 | Cross Section ID 1 | Time Period 2 | Value # | Value # | Value # | Value # |
Cross Section 1 | Cross Section ID 1 | Time Period 3 | Value # | Value # | Value # | Value # |
Cross Section 2 | Cross Section ID 2 | Time Period 1 | Value # | Value # | Value # | Value # |
Cross Section 2 | Cross Section ID 2 | Time Period 2 | Value # | Value # | Value # | Value # |
Cross Section 2 | Cross Section ID 2 | Time Period 3 | Value # | Value # | Value # | Value # |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
| | | | | | | | | | | | | |
Cross Section N | Cross Section ID N | Time Period T | Value # | Value # | Value # | Value # |