Balance and Un-Balance Panel

Sattar Khan

Join Date: Sep 2020
Posts: 100

Balance and Un-Balance Panel

22 Dec 2021, 03:21

Greetings Everyone!

Hopefully, you will find this post in good health. Dear all, I have a un-balance panel data set, but when I apply xtset then it appears strongly balance

HTML Code:

xtset ComID year, yearly
       panel variable:  ComID (strongly balanced)
        time variable:  year, 2010 to 2019
                delta:  1 year

my data looks like

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input int year double psxsectorcode int firmage str58 nameoftheauditor double(gprato1 cashfromop1 totalassetsratio1) float COMID
2010 828 28 ""                                       .226     .     .  1
2011 828 29 ""                                       .267     .     .  1
2012 828 30 "Riaz Ahmad & Co."                       .005     .  .012  1
2013 828 31 "Riaz Ahmad & Co."                      -.086     .  .122  1
2014 828 32 "Riaz Ahmad & Co."                      -.037 -.162 -.069  1
2015 828 33 "Riaz Ahmad & Co."                          . 4.185 -.364  1
2016 828 34 "Riaz Ahmad & Co."                          .     .  .037  1
2017 828 35 "Riaz Ahmad & Co."                          .     . -.125  1
2018 828 36 "Riaz Ahmad & Co."                          .     .  .054  1
2019 828 37 "Riaz Ahmad & Co."                          .     .  .202  1
2010 823 62 "M. Yousuf Adil Saleem & Co."               .     .     .  2
2011 823 63 "M. Yousuf Adil Saleem & Co."               . 1.093  .279  2
2012 823 64 "M. Yousuf Adil Saleem & Co."            .297  .416   .26  2
2013 823 65 "M. Yousuf Adil Saleem & Co."            .193  -.01  .197  2
2014 823 66 "Ernst & Young Ford Rhodes Sidat Hyder"   .15  .341  .233  2
2015 823 67 "Ernst & Young Ford Rohdes Sidat Hyder"  .114  .219  .198  2
2016 823 68 "Ernst & Young Ford Rohdes Sidat Hyder"  .114 -.232   .07  2
2017 823 69 "Ernst & Young Ford Rohdes Sidat Hyder"  .107  .848  .087  2
2018 823 70 "Ernst & Young Ford Rohdes Sidat Hyder"  .022  -.49  .057  2
2019 823 71 "Ernst & Young Ford Rohdes Sidat Hyder"     .     .     .  2
2010 826 26 "Farooq Ali & Co"                        .805     .     .  3
2011 826 27 "Farooq Ali & Co"                         .05     .     .  3
2012 826 28 "Farooq Ali & Co"                        .047     .     .  3
2013 826 29 "Farooq Ali & Co"                       -.508     .     .  3
2014 826 30 "Farooq Ali & Co"                           .     .     .  3
2015 826 31 "Kaleem & Co"                               .     .     .  3
2016 826 32 "Kaleem & Co"                               .     .     .  3
2017 826 33 "Kaleem & Co"                               .     .     .  3
2018 826 34 "Kaleem & Co"                               . -.936 -.019  3
2019 826 35 "Sarwars & Co"                              .  .982  .456  3
2010 826 18 "Haroon Zakaria & Company"               .668 -.368 -.074  4
2011 826 19 "Haroon Zakaria & Company"              -.099 -.569  .158  4
2012 826 20 "Haroon Zakaria & Company"              -.093     .  .915  4
2013 826 21 "Haroon Zakaria & Company"                .21     .  .369  4
2014 826 22 "Haroon Zakaria & Company"               -.01     . -.034  4
2015 826 23 "Haroon Zakaria & Company"              -.787     . -.262  4
2016 826 24 "Haroon Zakaria & Co."                   .358  -.26  -.11  4
2017 826 25 "Rahman Sarfaraz Rahim Iqbal Rafiq"     1.545     .   .79  4
2018 826 26 "Rahman Sarfaraz Rahim Iqbal Rafiq"     -.378     . -.081  4
2019 826 27 "Rahman Sarfaraz Rahim Iqbal Rafiq"     -.721 -.196  .722  4
2010 808 24 "Anjum Asim Shahid Rahman"               .558     . -.316  5
2011 808 25 "Anjum Asim Shahid Rahman"              -.323     .  .251  5
2012 808 26 "Anjum Asim Shahid Rahman"               -.32     . -.031  5
2013 808 27 "Anjum Asim Shahid Rahman"              1.003     .  .937  5
2014 808 28 "Anjum Asim Shahid Rahman"               .454     . -.093  5
2015 808 29 "Grant Thornton Anjum Rahman"            -.38     . -.173  5
2016 808 30 "Grant Thornton Anjum Rahman"           -.123     . -.278  5
2017 808 31 "Grant Thornton Anjum Rahman"           -.063     . -.084  5
2018 808 32 "Grant Thornton Anjum Rahman"           -.619     .  -.33  5
2019 808 33 "Grant Thornton Anjum Rahman"           -.942     . -.042  5
2010 802 29 "Ernst & Young Ford Rhodes Sidat Hyder"  .368 2.372  .286  6
2011 802 30 "Ernst & Young Ford Rhodes Sidat Hyder"  .291 -.031  .139  6
2012 802 31 "Ernst & Young Ford Rhodes Sidat Hyder"  -.02   .31  .187  6
2013 802 32 "Ernst & Young Ford Rhodes Sidat Hyder" -.164  -.73  .018  6
2014 802 33 "Ernst & Young Ford Rhodes Sidat Hyder" -.262 3.117  .035  6
2015 802 34 "Ernst & Young Ford Rohdes Sidat Hyder"  .376 -.793  .197  6
2016 802 35 "Ernst & Young Ford Rohdes Sidat Hyder"  .627 7.125  .104  6
2017 802 36 "Ernst & Young Ford Rohdes Sidat Hyder"  .147 -.268  .162  6
2018 802 37 "Ernst & Young Ford Rohdes Sidat Hyder"  .093 -.099  .131  6
2019 802 38 "Ernst & Young Ford Rohdes Sidat Hyder"  .089 -.723  .155  6
2010 805 51 "Faruq Ali & Co."                           .     .  .509  7
2011 805 52 "KPMG Taseer Hadi & Co."                -.452 -.298  .069  7
2012 805 53 "KPMG Taseer Hadi & Co."                -.316     .  .007  7
2013 805 54 "KPMG Taseer Hadi & Co."                    .     .     .  7
2014 805 55 "KPMG Taseer Hadi & Co."                    .     .  .122  7
2015 805 56 "KPMG Taseer Hadi & Co."                    .     . -.013  7
2016 805 57 "KPMG Taseer Hadi & Co."                    . 1.418 -.022  7
2017 805 58 "Ernst & Young Ford Rohdes Sidat Hyder"     . -.733 -.017  7
2018 805 59 "KPMG Taseer Hadi & Co."                    . 2.201 -.019  7
2019 805 60 "Grant Thornton Anjum Rahman"               .     .     .  7
2010 828 21 "M. Yousuf Adil Saleem & Co."            .413 1.642 -.044  8
2011 828 22 "M. Yousuf Adil Saleem & Co."            .401 -.737 -.047  8
2012 828 23 "F.R.A.N.T.S. & Co"                      .017 1.308 -.055  8
2013 828 24 "F.R.A.N.T.S. & Co"                     -.126 -.092  .286  8
2014 828 25 "F.R.A.N.T.S. & Co"                     -.064     .  .107  8
2015 828 26 "F.R.A.N.T.S. & Co"                     -.316     .  .009  8
2016 828 27 "PKF F.R.A.N.T.S"                       -.184 -.981  .002  8
2017 828 28 "PKF F.R.A.N.T.S"                        .084     .   .12  8
2018 828 29 "M/s PKF F.R..a.n.T.S"                   .116     .  .048  8
2019 828 30 "M/s PKF F.R..a.n.T.S"                   .367 -.398  .103  8
2010 808  5 ""                                          .     .     .  9
2011 808  6 "A.F. Ferguson & Co."                       .     .     .  9
2012 808  7 "A.F. Ferguson & Co."                       .     .  .292  9
2013 808  8 "A.F. Ferguson & Co."                       .     .  .311  9
2014 808  9 "A.F. Ferguson & Co."                       .     .  .134  9
2015 808 10 "A.F. Ferguson & Co."                       .     . -.058  9
2016 808 11 "A.F. Ferguson & Co."                   3.728     .  .001  9
2017 808 12 "A.F. Ferguson & Co."                   8.575     .  .184  9
2018 808 13 "A.F. Ferguson & Co."                    .854     .  .123  9
2019 808 14 "A.F. Ferguson & Co."                   -.106     .  .602  9
2010 805 -1 ""                                          .     .     . 10
2011 805  0 "KPMG Taseer Hadi & Co"                     .     .     . 10
2012 805  1 "KPMG Taseer Hadi & Co"                     .     .     . 10
2013 805  2 "KPMG Taseer Hadi & Co"                     .     .     . 10
2014 805  3 "KPMG Taseer Hadi & Co"                     .     .     . 10
2015 805  4 "A.F.Ferguson & Co."                        .     .     . 10
2016 805  5 "A.F.Ferguson & Co."                        .     .     . 10
2017 805  6 "A.F.Ferguson & Co."                        .     .     . 10
2018 805  7 "A.F.Ferguson & Co."                        .     .     . 10
2019 805  8 "KPMG Taseer Hadi & Co."                    .     .     . 10
end
format %ty year
label values psxsectorcode psxsectorcode
label def psxsectorcode 802 "AutoMobile Parts&Accessories", modify
label def psxsectorcode 805 "Chemical", modify
label def psxsectorcode 808 "Engineering", modify
label def psxsectorcode 823 "Pharmaceuticals", modify
label def psxsectorcode 826 "Sugar & Allied Industries", modify
label def psxsectorcode 828 "Technology & Communication", modify

Kindly guide me in this regard that how to tackle this issue.

Regards
Sattar Khan

Tags: None

Carlo Lazzaro

Join Date: Apr 2014
Posts: 17612

22 Dec 2021, 04:27

Sattar:
actually, your panel is strongly balanced:

Code:

. xtset COMID year

Panel variable: COMID (strongly balanced)
 Time variable: year, 2010 to 2019
         Delta: 1 year

. table COMID

--------------------
        |  Frequency
--------+-----------
COMID   |          
  1     |         10
  2     |         10
  3     |         10
  4     |         10
  5     |         10
  6     |         10
  7     |         10
  8     |         10
  9     |         10
  10    |         10
  Total |        100
--------------------

.

Kind regards,
Carlo
(StataNow 18.5)

Comment

Sattar Khan

Join Date: Sep 2020

Posts: 100
#3

22 Dec 2021, 05:05

Originally posted by Carlo Lazzaro View Post

Sattar:
actually, your panel is strongly balanced:

Code:

. xtset COMID year Panel variable: COMID (strongly balanced) Time variable: year, 2010 to 2019 Delta: 1 year . table COMID -------------------- | Frequency --------+----------- COMID | 1 | 10 2 | 10 3 | 10 4 | 10 5 | 10 6 | 10 7 | 10 8 | 10 9 | 10 10 | 10 Total | 100 -------------------- .

but Carlo I have 30 columns containing data in it, in year 2010 in some companies it has 10 observations, in some 20, in some 25 etc.
Comment
Carlo Lazzaro

Join Date: Apr 2014

Posts: 17612
#4

22 Dec 2021, 06:33

Sattar:
have you considered the role of missing values?
Stata applies listwise deletion by default, ruling out observations with missing values in any variable.

Kind regards,
Carlo
(StataNow 18.5)
1 like
Comment

Announcement

Balance and Un-Balance Panel

Comment

Comment

Comment