Hello,

I have a lot of balance sheet data (with a lot of variables). What I need is for every idnr (company), a command that tells stata to drop the company if it is missing data in two consecutive years or two discontinous years (so if in total, the firm has missing information for two or more years, stata should drop the company completely. The variables I'm checking are below: fias, turn, ebta or toas. (I have more in the real dataset, but this is the start).

Thanks!


Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input str16 idnr double(closdate_year turn opre fias toas plbt ebta)
"FI10290064"    2007     3000     3000     7000    49000        0    1000
"FI10290064"    2008     5000    10000        0    37000     2000       .
"FI10290064"    2009    11000    11000        .    34000    -7000       .
"FI10290064"    2010    41000    41000        0    35000     2000       .
"FI10290064"    2011     2000    17000        0    33000     4000       .
"FI10290064"    2012     1000     1000        0    30000        0       .
"FI10290064"    2013        .        .        0    26738     -822       .
"FI10290064"    2014   257000        0    59000   411000   -11000   -9000
"FI26827006"    2016    71000    71000   546000   575000    -4000       .
"FI27388017"    2016        .   100000        .        .        .       .
"IT00000020362" 2007  1841487  1970409   130359  1536018  -161042 -108568
"IT00000020362" 2008  2300573  2206105   161324  1594518    11172   66722
"IT00000020362" 2009  1007198   928467   148419  1066803  -389538 -354287
"IT00000020362" 2010  1263340  1217213   149139  1130277  -276673 -248887
"IT00000020362" 2011  1034239   942236   140757   705171  -293753 -177292
"IT00000020362" 2012   539470   345612    40236   248084  -208791 -190953
"IT00000210054" 2007   610064   613005    26213   351598    -9921   -5881
"IT00000210054" 2008   595101   625437    23943   429147     9051   15819
"IT00000210054" 2009   491656   499725    18438   375860     7394   13099
"IT00000210054" 2010   542363   566913    12443   404001    -5441    2278
"IT00000210054" 2011   528512   508694     9366   430936     5947   15052
"IT00000210054" 2012   444428   439272     7967   350952     3731   12363
"IT00000210054" 2013   407241   408549     7359   360537     3786   11175
"IT00000210054" 2014   436512   439470     6139   409089     3650   11444
"IT00000210054" 2015   367083   365195     5528   366863      517   10025
"IT00000210054" 2016   381487   382250     4918   428085      169    8638
"IT00000240408" 2011    14958    14962    82356   105826    -8833   -3974
"IT00000240408" 2012   131965   148113    67031   154975    45601   54756
"IT00000240408" 2013   173274   173578    74107   175385    69388   79884
"IT00000240408" 2014   143327   180905    86169   294797    43369   53169
"IT00000240408" 2015   263160   316212    80206   243868   113661  122953
"IT00000240408" 2016   151514   171881    85313   214666    25269   34201
"IT00000450155" 2007  1707725  1729067   509281   967702    83439  290396
"IT00000450155" 2008  1785326  1777067   484540  1040840    47476  253069
"IT00000450155" 2009  1444539  1440234   332871   936566   -63434  115492
"IT00000450155" 2010  1323801  1282357   265356   812812   -36824   94169
"IT00000450155" 2011  1091350  1132447   268407   678546  -333135 -217695
"IT00000450155" 2012  1159131  1148983   208134   728572  -192405 -119987
"IT00000450155" 2013  1031793  1026007   165842   870776  -211479 -141028
"IT00000450155" 2014   534215   534215   206161   671892  -263184 -209963
"IT00000450155" 2015  1395732  1446358   486243  1269456     -714  103089
"IT00000450155" 2016  1429306  1434313   402248  1210096     2341  110179
"IT00000520288" 2007   709721  2041155  1255030  1769122    91372  153060
"IT00000520288" 2008   751262   967389  1438714  2077346   -93944   46088
"IT00000520288" 2009   643837   638687  1346920  1975874   -78459   67611
"IT00000520288" 2010   461521   564622  1268650  1897604   -80252    3973
"IT00000520288" 2011   417131   538081  1207011  1946940   -80650    6318
"IT00000520288" 2012   330940   319790  1134156  1872882  -254420 -161478
"IT00000520288" 2013   302023   307623  1112924  1866515  -168309 -137656
"IT00000520288" 2014   289213   269413  1097492  1907857     2934    4748
"IT00000520288" 2015   299966   309966  1093102  1968723      941   -8156
"IT00000520288" 2016   202605   -85575  1089913  1321363  -642695 -634306
"IT00001040286" 2007      -13    51668    14849    99965    25072   32511
"IT00001040286" 2008       -2   102329   138560   281995    49333   57418
"IT00001040286" 2009       -1     2699   135080   277669   -11941   -5743
"IT00001040286" 2010        0     5400   131600   248055    -5837    -764
"IT00001040286" 2011     6400     6400   128120   233292    -3028    2290
"IT00001040286" 2012     5400     5400   124700   264849    -1899    2650
"IT00001040286" 2013     5400     5400   119840   258989    -1364    3053
"IT00001040286" 2014        0     6429   116480   170133      632    4004
"IT00001040286" 2015     5400     5400   113120   167147     -656    2708
"IT00001360122" 2009   402201   402443    17607   283804    40617   46408
"IT00001360122" 2010   403520   408400    15223   363101    38968   47663
"IT00001360122" 2011   392889   391759    10885   396854   116857  124483
"IT00001360122" 2012   303709   303831     7427   409889   -49864  -39967
"IT00001360122" 2013   255774   255774   245621   419876    69920   82934
"IT00001360122" 2014   224270   225059   243744   321980    62431   71904
"IT00001360122" 2015   246292   246292   242588   440809    94374  101931
"IT00001360122" 2016   266095   266634   261903   452450   108753  115128
"IT00001400357" 2008    39522    47944   923774  1507487    -5650     986
"IT00001400357" 2009  1113846  1037611   923551  1554318    19147   70587
"IT00001400357" 2010  1340253  1348209  1028293  1668404    66667  111666
"IT00001400357" 2011  1198768  1238429  1071966  1571061    76868  145952
"IT00001400357" 2012   751980   750988  1002430  1396219    61361  141951
"IT00001400357" 2013   524771   526860   930523  1200020    23725  115105
"IT00001400357" 2014   673649   701357   863767  1211166   170125  252365
"IT00001400357" 2015   544573   548729   811349  1047829   106182  160984
"IT00001400357" 2016   496679   499778   773973  1075726   106866  151054
"IT00001510288" 2007  1330848  1330848    98733   631458    36357   74895
"IT00001510288" 2008  1342931  1342931   252290   742536    42720   87041
"IT00001510288" 2009  1406438  1406457   234390   698107    47343   81992
"IT00001510288" 2010  1543250  1543330   248630   747756    56198   84145
"IT00001510288" 2011  1567760  1567760   239832   802583    25959   54091
"IT00001510288" 2012  1432435  1432875   222393   744590    10959   38356
"IT00001510288" 2013  1332689  1332689   205171   678913    29724   54245
"IT00001510288" 2014  1339473  1339473   188653   735777    12335   34747
"IT00001510288" 2015  1373913  1374156   176139   740178    18444   30978
"IT00001510288" 2016  1287539  1293215   168293   750931    -7618    1099
"IT00001640242" 2007 15740424 16025828  1116503 12133969   880216 1357846
"IT00001640242" 2008 14312996 14183567  1503583 11763963   198143  778084
"IT00001640242" 2009  8945304  9053252  1511865 10059415  -283859  289323
"IT00001640242" 2010 33666015 35581574 10157776 41785970   172919 1044520
"IT00001640242" 2011 41152728 42269631  9951328 45288997 -1519738  576928
"IT00001640242" 2012 35504005 33881317  9297949 38877673 -1983926  -84304
"IT00001640242" 2013 39705464 37623867  7455399 31884012  -481423 2017783
"IT00001640242" 2014 35231594 34807016  6010975 33500213   530819 2649223
"IT00001640242" 2015 33791135 34858254  5934892 33287601   753491 2504363
"IT00001640242" 2016 32969794 32996685  5562248 33980114   952592 2543605
"IT00001650282" 2007 16347302 16379210  2018189 11697332   696898 1097368
"IT00001650282" 2008 14529958 14927982  2572684 10415776   160268  650802
end