Hi,

I working with individual data for two rounds- 2005 and 2012. I have accounted for attrition and kept the required adult child in the household. However, when I specify the time variable, I get a weakly balanced panel.

I am using the command: xtset IDHH year

IDHH is the unique household ID. Whenever I use xtset IDHH, I get a balanced panel but whenever I add a time variable, I get a weakly balanced panel.

The data looks like this:

Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int(year SURVEY AGE) float(logchildwage logheadwage) double IDHH
2005 1 24 2.4713535 2.5513964   20407080
2005 1 22  3.327874 2.7198846   51301051
2005 1 18 1.7972836 1.7972836   82603031
2005 1 14 1.8725867 2.2131913   96602090
2005 1 26 2.5477076 2.8353896  102201111
2012 2 27  3.310443 4.1859117  113121201
2005 1 30 2.0794415  2.167995  190202061
2012 2 21   2.70805   2.70805  201050401
2005 1 23 2.7186005 2.1796038  231304061
2005 1 16  2.512788  2.512788  270304121
2005 1 23  2.512788  2.512788  270701081
2005 1 23 3.3718674 2.5986776  281511080
2005 1 24 2.4183996 3.8923995  292605140
2005 1 21  4.509575  3.816428  321205160
2005 1 27 2.4837954 2.4837954  331504251
2012 2 15  2.525729 3.4927645  701070401
2012 2 19  3.218876  3.624341  904081401
2012 2 15   1.89712  2.931194  949082001
2012 2 22  2.931194  2.931194  954070701
2012 2 27  2.813411  2.931194  966031411
2012 2 20 2.3025851  .5108256  968022201
2012 2 16  2.931194 3.1135154 1806101601
2012 2 25  2.484907 2.3025851 1911140501
2012 2 32  2.748872  2.525729 2317020111
2012 2 19  2.931194  2.931194 2330020801
2012 2 26  3.358638  3.218876 2810040611
2012 2 35  2.525729  2.525729 2905351311
2012 2 19  2.813411  3.218876 2927030201
2012 2 24  2.511935 3.4011974 3213030401
2012 2 24  3.610918 3.6888795 3312150701
end
label values SURVEY SURVEY
label def SURVEY 1 "IHDS1 1", modify
label def SURVEY 2 "IHDS2 2", modify