xtreg Insufficient Observations Error

[Fahad Mirza]

Hello everyone,

Hope you all are well and keeping safe!

I have this query regarding a problem I am facing in running a xtreg regression where I get Insufficient Observations error. Based on the dataset I ran xtlogit because my dependant variable was dummy and that the panel was set using emiscode and year (strongly balanced).

Now I wanted to run the xtreg regression because I wanted to make the coefficients from the above model comparable with the OLS regression. Thinking that maybe running an xtreg will allow me to have a panel like LPM model (I could be blatantly wrong, and given my doubts i feel like I definitely am!). However, running xtreg gives me the error and doesnt go forward. What could I be doing wrong? Is it because I have only a maximum of 2 observations only to perform xtreg and that i require more? Will it be right for me to run just a simple regress to get an LPM model and make results comparable to xtlogit?

Help will be appreciated.

* The regression:
xtreg sc_funds_from_govt drink_water toilets boundary_wall computer sports library main_gate sewerage electricity play_ground

* Example generated by -dataex-. To install: ssc install dataex
clear
input long emiscode int year byte(sc_funds_from_govt drink_water toilets boundary_wall computer sports library main_gate sewerage electricity play_ground)
31110001 2004 . . . . . . . . . . .
31110001 2005 . . . . . . . . . . .
31110001 2006 . 1 1 1 1 1 1 1 . . 1
31110001 2007 0 1 1 1 1 1 1 0 0 1 1
31110002 2004 . . . . . . . . . . .
31110002 2005 . . . . . . . . . . .
31110002 2006 . 1 1 1 1 1 1 1 . . 0
31110002 2007 0 1 1 1 1 1 1 1 1 1 0
31110003 2004 . . . . . . . . . . .
31110003 2005 . . . . . . . . . . .
31110003 2006 . 1 1 1 0 0 1 1 . . 0
31110003 2007 0 1 1 1 0 1 1 1 1 1 0
31110004 2004 . . . . . . . . . . .
31110004 2005 . . . . . . . . . . .
31110004 2006 . 1 1 1 0 1 1 1 . . 1
31110004 2007 0 1 1 1 0 0 1 1 0 1 0
31110005 2004 . . . . . . . . . . .
31110005 2005 . . . . . . . . . . .
31110005 2006 . 1 1 1 0 1 1 1 . . 1
31110005 2007 0 1 1 1 0 1 1 1 0 1 1
31110006 2004 . . . . . . . . . . .
31110006 2005 . . . . . . . . . . .
31110006 2006 . 1 0 1 0 0 1 1 . . 0
31110006 2007 0 1 0 1 0 0 1 1 0 1 0
31110007 2004 . . . . . . . . . . .
31110007 2005 . . . . . . . . . . .
31110007 2006 . 1 0 0 0 1 1 1 . . 1
31110007 2007 0 1 0 0 0 1 1 1 0 1 1
31110008 2004 . . . . . . . . . . .
31110008 2005 . . . . . . . . . . .
31110008 2006 . 1 1 1 0 0 1 1 . . 0
31110008 2007 0 1 1 1 0 1 1 1 0 1 0
31110009 2004 . . . . . . . . . . .
31110009 2005 . . . . . . . . . . .
31110009 2006 . 1 1 1 0 0 1 1 . . 0
31110009 2007 0 1 1 1 0 0 1 1 0 1 0
31110010 2004 . . . . . . . . . . .
31110010 2005 . . . . . . . . . . .
31110010 2006 . 1 1 1 0 1 1 1 . . 1
31110010 2007 0 1 1 1 0 0 1 1 1 1 1
31110011 2004 . . . . . . . . . . .
31110011 2005 . . . . . . . . . . .
31110011 2006 0 1 0 1 0 1 1 0 . . 1
31110011 2007 0 1 0 0 0 1 1 0 0 1 1
31110012 2004 . . . . . . . . . . .
31110012 2005 . . . . . . . . . . .
31110012 2006 . 1 1 1 0 1 1 1 . . 1
31110012 2007 0 1 1 1 0 1 1 1 1 1 1
31110013 2004 . . . . . . . . . . .
31110013 2005 . . . . . . . . . . .
31110013 2006 . 1 1 0 0 1 1 1 . . 1
31110013 2007 0 1 1 1 0 1 1 1 1 1 1
31110014 2004 . . . . . . . . . . .
31110014 2005 . . . . . . . . . . .
31110014 2006 . 1 1 0 0 1 1 1 . . 1
31110014 2007 0 1 1 1 0 0 1 1 0 1 0
31110015 2004 . . . . . . . . . . .
31110015 2005 . . . . . . . . . . .
31110015 2006 . 1 0 0 0 1 1 1 . . 1
31110015 2007 0 1 1 0 0 0 1 0 0 1 0
31110018 2004 . . . . . . . . . . .
31110018 2005 . . . . . . . . . . .
31110018 2006 . 1 1 1 0 1 1 1 . . 0
31110018 2007 0 1 1 1 0 1 1 1 0 1 0
31110019 2004 . . . . . . . . . . .
31110019 2005 . . . . . . . . . . .
31110019 2006 . 1 1 1 0 0 1 1 . . 0
31110019 2007 0 1 1 1 0 0 1 1 1 1 0
31110020 2004 . . . . . . . . . . .
31110020 2005 . . . . . . . . . . .
31110020 2006 . 1 1 1 0 1 1 1 . . 1
31110020 2007 0 1 1 1 0 1 1 1 1 1 1
31110021 2004 . . . . . . . . . . .
31110021 2005 . . . . . . . . . . .
31110021 2006 . 1 1 1 1 1 1 1 . . 1
31110021 2007 0 1 1 1 1 1 1 1 0 1 1
31110022 2004 . . . . . . . . . . .
31110022 2005 . . . . . . . . . . .
31110022 2006 . 1 1 1 0 0 0 1 . . 0
31110022 2007 0 1 1 1 0 0 0 1 0 1 0
31110023 2004 . . . . . . . . . . .
31110023 2005 . . . . . . . . . . .
31110023 2006 . 1 1 0 0 1 1 0 . . 1
31110023 2007 0 1 1 0 0 1 1 0 0 1 1
31110024 2004 . . . . . . . . . . .
31110024 2005 . . . . . . . . . . .
31110024 2006 . 1 1 0 0 0 1 0 . . 0
31110024 2007 0 1 1 0 0 1 1 1 1 1 0
31110025 2004 . . . . . . . . . . .
31110025 2005 . . . . . . . . . . .
31110025 2006 . 1 1 1 0 1 1 1 . . 0
31110025 2007 0 1 1 1 0 1 1 1 0 1 0
31110026 2004 . . . . . . . . . . .
31110026 2005 . . . . . . . . . . .
31110026 2006 . 1 1 1 0 1 1 1 . . 1
31110026 2007 0 1 1 1 0 1 1 1 1 1 1
31110027 2004 . . . . . . . . . . .
31110027 2005 . . . . . . . . . . .
31110027 2006 . 1 1 1 0 1 1 1 . . 0
31110027 2007 0 1 1 1 0 0 1 1 0 1 0
31110028 2004 . . . . . . . . . . .
31110028 2005 . . . . . . . . . . .
31110028 2006 . 1 1 1 0 1 1 1 . . 0
31110028 2007 0 1 1 1 0 1 1 1 0 1 0
31110029 2004 . . . . . . . . . . .
31110029 2005 . . . . . . . . . . .
31110029 2006 1 1 1 0 0 1 1 0 . . 1
31110029 2007 0 1 1 0 0 1 1 0 0 0 1
31110030 2004 . . . . . . . . . . .
31110030 2005 . . . . . . . . . . .
31110030 2006 . 1 1 1 0 1 1 1 . . 0
31110030 2007 0 1 1 1 0 1 1 1 1 1 0
31110031 2004 . . . . . . . . . . .
31110031 2005 . . . . . . . . . . .
31110031 2006 . 1 1 1 0 1 0 . . . .
31110031 2007 0 1 1 1 0 0 1 1 1 1 1
31110032 2004 . . . . . . . . . . .
31110032 2005 . . . . . . . . . . .
31110032 2006 . 1 1 1 0 0 1 1 . . 0
31110032 2007 0 1 1 1 0 0 1 1 0 1 0
31110033 2004 . . . . . . . . . . .
31110033 2005 . . . . . . . . . . .
31110033 2006 . 1 1 1 0 1 1 1 . . 1
31110033 2007 0 1 1 1 0 1 1 1 1 1 1
31110034 2004 . . . . . . . . . . .
31110034 2005 . . . . . . . . . . .
31110034 2006 . 1 1 1 0 0 1 1 . . 0
31110034 2007 0 1 1 1 0 0 1 1 1 1 0
31110035 2004 . . . . . . . . . . .
31110035 2005 . . . . . . . . . . .
31110035 2006 . 1 1 1 0 1 1 1 . . 1
31110035 2007 0 1 1 1 0 1 1 1 0 1 1
31110037 2004 . . . . . . . . . . .
31110037 2005 . . . . . . . . . . .
31110037 2006 . 1 1 1 1 1 1 1 . . 1
31110037 2007 0 1 1 1 1 1 1 1 1 1 1
31110038 2004 . . . . . . . . . . .
31110038 2005 . . . . . . . . . . .
31110038 2006 . 1 1 1 1 1 1 1 . . 0
31110038 2007 0 1 1 1 1 0 1 1 1 1 0
31110039 2004 . . . . . . . . . . .
31110039 2005 . . . . . . . . . . .
31110039 2006 . 1 1 1 0 0 1 1 . . 1
31110039 2007 0 1 1 1 0 1 1 1 0 1 0
31110040 2004 . . . . . . . . . . .
31110040 2005 . . . . . . . . . . .
31110040 2006 0 1 1 1 0 0 0 1 . . 0
31110040 2007 1 1 1 1 0 0 1 1 0 1 0
31110041 2004 . . . . . . . . . . .
31110041 2005 . . . . . . . . . . .
31110041 2006 1 1 0 0 0 1 1 1 . . 1
31110041 2007 1 1 0 0 0 1 1 1 0 1 1
31110042 2004 . . . . . . . . . . .
31110042 2005 . . . . . . . . . . .
31110042 2006 1 1 0 0 0 1 0 0 . . 1
31110042 2007 1 1 0 0 0 0 0 0 0 1 0
31110043 2004 . . . . . . . . . . .
31110043 2005 . . . . . . . . . . .
31110043 2006 0 1 1 0 0 1 0 1 . . 1
31110043 2007 1 1 1 1 0 1 1 1 0 1 1
31110044 2004 . . . . . . . . . . .
31110044 2005 . . . . . . . . . . .
31110044 2006 0 1 0 1 0 1 1 1 . . 1
31110044 2007 0 1 1 1 0 1 1 1 0 1 0
31110045 2004 . . . . . . . . . . .
31110045 2005 . . . . . . . . . . .
31110045 2006 0 1 1 1 0 1 0 0 . . 1
31110045 2007 1 1 1 1 0 0 0 1 1 1 0
31110046 2004 . . . . . . . . . . .
31110046 2005 . . . . . . . . . . .
31110046 2006 0 1 1 0 0 1 0 0 . . 0
31110046 2007 1 1 1 0 0 0 1 0 0 1 0
31110047 2004 . . . . . . . . . . .
31110047 2005 . . . . . . . . . . .
31110047 2006 1 1 1 1 0 1 0 1 . . 0
31110047 2007 1 1 1 1 0 0 0 1 1 1 0
31110048 2004 . . . . . . . . . . .
31110048 2005 . . . . . . . . . . .
31110048 2006 0 1 1 0 0 1 0 0 . . 0
31110048 2007 0 1 1 0 0 0 . 0 1 0 0
31110049 2004 . . . . . . . . . . .
31110049 2005 . . . . . . . . . . .
31110049 2006 0 1 1 1 0 1 1 1 . . 0
31110049 2007 1 1 1 1 0 0 1 1 1 1 0
31110050 2004 . . . . . . . . . . .
31110050 2005 . . . . . . . . . . .
31110050 2006 0 1 1 1 0 1 1 1 . . 0
31110050 2007 1 1 1 1 0 0 1 1 1 1 0
31110051 2004 . . . . . . . . . . .
31110051 2005 . . . . . . . . . . .
31110051 2006 0 0 0 1 0 0 1 1 . . 0
31110051 2007 1 0 0 1 0 0 1 1 0 1 0
31110052 2004 . . . . . . . . . . .
31110052 2005 . . . . . . . . . . .
31110052 2006 0 1 0 0 0 1 0 0 . . 0
31110052 2007 1 0 0 0 0 0 0 0 0 0 0
31110053 2004 . . . . . . . . . . .
31110053 2005 . . . . . . . . . . .
31110053 2006 . 1 1 1 0 0 0 1 . . 0
31110053 2007 . 1 1 1 0 0 0 1 1 0 0
31110054 2004 . . . . . . . . . . .
31110054 2005 . . . . . . . . . . .
31110054 2006 0 1 1 1 0 1 0 1 . . 0
31110054 2007 1 1 1 1 0 0 1 1 1 1 0
31110055 2004 . . . . . . . . . . .
31110055 2005 . . . . . . . . . . .
31110055 2006 0 1 1 0 0 1 0 1 . . 0
31110055 2007 1 1 1 0 0 0 . 0 0 1 0
31110056 2004 . . . . . . . . . . .
31110056 2005 . . . . . . . . . . .
31110056 2006 0 1 1 0 0 0 1 0 . . 0
31110056 2007 1 1 1 0 0 0 1 0 1 1 0
31110057 2004 . . . . . . . . . . .
31110057 2005 . . . . . . . . . . .
31110057 2006 0 1 1 1 0 1 1 1 . . 1
31110057 2007 1 1 1 1 0 0 1 1 0 1 0
31110058 2004 . . . . . . . . . . .
31110058 2005 . . . . . . . . . . .
31110058 2006 0 1 1 1 0 1 1 0 . . 0
31110058 2007 1 1 1 1 0 0 1 0 0 1 0
31110059 2004 . . . . . . . . . . .
31110059 2005 . . . . . . . . . . .
31110059 2006 0 1 0 0 0 1 1 0 . . 0
31110059 2007 1 1 0 0 0 0 1 1 0 1 0
31110060 2004 . . . . . . . . . . .
31110060 2005 . . . . . . . . . . .
31110060 2006 0 1 1 1 0 1 0 1 . . 0
31110060 2007 1 1 1 1 0 0 1 1 0 1 0
31110061 2004 . . . . . . . . . . .
31110061 2005 . . . . . . . . . . .
31110061 2006 1 1 0 0 0 1 1 0 . . 1
31110061 2007 0 1 1 1 0 1 1 1 1 1 1
31110062 2004 . . . . . . . . . . .
31110062 2005 . . . . . . . . . . .
31110062 2006 0 1 1 0 0 1 1 0 . . 0
31110062 2007 0 1 1 0 0 1 1 0 0 1 0
31110063 2004 . . . . . . . . . . .
31110063 2005 . . . . . . . . . . .
31110063 2006 0 1 0 1 0 1 0 1 . . 1
31110063 2007 0 1 1 1 0 1 1 1 0 1 1
31110064 2004 . . . . . . . . . . .
31110064 2005 . . . . . . . . . . .
31110064 2006 1 1 1 1 0 0 0 1 . . 0
31110064 2007 0 1 1 1 0 0 0 1 0 0 0
31110065 2004 . . . . . . . . . . .
31110065 2005 . . . . . . . . . . .
31110065 2006 1 1 1 0 0 1 1 1 . . 1
31110065 2007 0 1 1 0 0 1 1 1 0 1 1
31110066 2004 . . . . . . . . . . .
31110066 2005 . . . . . . . . . . .
31110066 2006 1 1 1 0 0 0 1 0 . . 0
31110066 2007 1 1 0 0 0 1 0 0 0 0 0
31110067 2004 . . . . . . . . . . .
31110067 2005 . . . . . . . . . . .
31110067 2006 1 1 1 1 0 1 0 1 . . 0
31110067 2007 0 1 1 1 0 0 0 1 1 1 0
31110068 2004 . . . . . . . . . . .
31110068 2005 . . . . . . . . . . .
31110068 2006 . 1 1 0 0 0 0 0 . . 1
31110068 2007 1 1 0 1 0 0 . 1 0 1 0
31110069 2004 . . . . . . . . . . .
31110069 2005 . . . . . . . . . . .
31110069 2006 1 1 0 1 0 1 1 1 . . 1
31110069 2007 0 1 0 1 0 0 1 1 0 0 0
31110070 2004 . . . . . . . . . . .
31110070 2005 . . . . . . . . . . .
31110070 2006 1 0 1 0 0 0 0 0 . . 0
31110070 2007 0 0 1 0 0 0 1 0 0 0 0
31110071 2004 . . . . . . . . . . .
31110071 2005 . . . . . . . . . . .
31110071 2006 1 1 1 1 0 1 0 1 . . 1
31110071 2007 0 1 1 1 0 0 . 1 1 1 0
31110072 2004 . . . . . . . . . . .
31110072 2005 . . . . . . . . . . .
31110072 2006 1 1 1 1 0 0 1 1 . . 0
31110072 2007 0 1 1 1 0 1 1 1 1 1 0
31110073 2004 . . . . . . . . . . .
31110073 2005 . . . . . . . . . . .
31110073 2006 1 1 1 1 0 0 0 1 . . 1
31110073 2007 0 1 0 1 0 0 0 1 0 0 0
31110074 2004 . . . . . . . . . . .
31110074 2005 . . . . . . . . . . .
31110074 2006 . 1 1 1 0 1 0 1 . . 1
31110074 2007 0 1 1 1 0 0 0 1 1 1 0
31110075 2004 . . . . . . . . . . .
31110075 2005 . . . . . . . . . . .
31110075 2006 1 1 1 1 0 1 . 1 . . 0
31110075 2007 0 1 1 1 0 0 1 1 0 1 0
31110076 2004 . . . . . . . . . . .
31110076 2005 . . . . . . . . . . .
31110076 2006 0 1 1 1 0 1 0 1 . . 1
31110076 2007 0 1 1 1 0 1 . 1 1 1 1
31110077 2004 . . . . . . . . . . .
31110077 2005 . . . . . . . . . . .
31110077 2006 0 1 1 1 0 0 1 1 . . 0
31110077 2007 0 1 1 1 0 0 1 1 1 1 0
31110078 2004 . . . . . . . . . . .
31110078 2005 . . . . . . . . . . .
31110078 2006 1 1 1 1 0 0 1 1 . . .
31110078 2007 0 1 1 1 0 0 1 1 1 1 0
end
label values drink_water yesno0
label values sports yesno0
label def yesno0 0 "No", modify
label def yesno0 1 "Yes", modify
label values toilets yesno
label values boundary_wall yesno
label values computer yesno
label values library yesno
label values main_gate yesno
label values sewerage yesno
label values electricity yesno
label values play_ground yesno
label def yesno 0 "No", modify
label def yesno 1 "Yes", modify

[Carlo Lazzaro]

Fahad:
I do hope you're safe , too.
The issue you have is that you have only one observation per -panelid-; hence, -xtreg- does not work.
Conversely, as expected -regress- works:

. reg sc_funds_from_govt drink_water toilets boundary_wall computer sports library main_gate sewerage electricity play_ground

      Source |       SS           df       MS      Number of obs   =        69
-------------+----------------------------------   F(10, 58)       =      2.33
       Model |  3.80825414        10  .380825414   Prob > F        =    0.0222
    Residual |  9.49609369        58  .163725753   R-squared       =    0.2862
-------------+----------------------------------   Adj R-squared   =    0.1632
       Total |  13.3043478        68  .195652174   Root MSE        =    .40463

-------------------------------------------------------------------------------
sc_funds_fr~t |      Coef.   Std. Err.      t    P>|t|     [95% Conf. Interval]
--------------+----------------------------------------------------------------
  drink_water |  -.2170634   .2734524    -0.79   0.431    -.7644378     .330311
      toilets |  -.2839936   .1702834    -1.67   0.101    -.6248528    .0568657
boundary_wall |  -.0707934   .1875044    -0.38   0.707    -.4461242    .3045374
     computer |   -.130234   .2007921    -0.65   0.519    -.5321631    .2716951
       sports |  -.2279434   .1268629    -1.80   0.078    -.4818872    .0260003
      library |  -.1631976   .1649323    -0.99   0.327    -.4933455    .1669503
    main_gate |  -.2118979   .1934203    -1.10   0.278    -.5990706    .1752748
     sewerage |    .032583   .1142603     0.29   0.777    -.1961338    .2612997
  electricity |   .4088935   .2043272     2.00   0.050    -.0001118    .8178988
  play_ground |   -.065584   .1333455    -0.49   0.625    -.3325041     .201336
        _cons |   .8280622   .2567854     3.22   0.002     .3140505    1.342074
-------------------------------------------------------------------------------

.

[Fahad Mirza]

Thank you for the reply Carlo!

I had this query in mind regarding the dataset. Since I have observations for the year 2006 and 2007 only, will it make sense if i were to paste 2006 values onto 2005 and 2004? The reason why I am thinking this is because prior to 2007, if there was an alternate status in 2006, then that status would most probably be consistent even at 2005 and 2004 since these variables are related to infrastructure and usually once infrastructure is established, it most often remains.

Or is the idea too far fetched?

[Carlo Lazzaro]

Fahad:
whenever we make-up our data according to assumptions what follows is as good as our assumptions about the data generating process are..
I do prefer to analyse the data as they are and live with them.

[Fahad Mirza]

True, well, thanks once again!