Hi all. I am organizing a panel data with information on the spending with government advertising by Brazilian municipalities for three 4-year periods (2005-2008, 2009-2012, 2013-2016). Here I reproduce the data for the 2013-2016 period. I am aggregating the amount spent with advertising per municipality for the years 2013, 2014, 2015, and 2016 (i.e., variables r_spend_com_social_13, r_spend_com_social_14, r_spend_com_social_15, and r_spend_com_social_16). My goal is to create a variable "r_spend_com_social_total", which will be the sum of the four aforementioned variables.

The problem: there is a considerable amount of missing cells in the data. That can be easily seen by inspecting which observations have missing cells with the variable "anymiss". For instance, observation #2 has a missing cell.

The question, then, is: What should I do with observations containing missing cells? Should a whole row of data be dropped if it contains at least one missing cell, as it is the case with observation #2?


Thank you.


Variables:
ibge_uf_code = state ID
ibge_mun_code = municipality ID
obs_number: observation's number
r_spend_com_social_13 = spending with govt ads at year 2013
r_spend_com_social_14 = spending with govt ads at year 2014
r_spend_com_social_15 = spending with govt ads at year 2015
r_spend_com_social_16 = spending with govt ads at year 2016


Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input byte ibge_uf_code long ibge_mun_code float(obs_number r_spend_com_social_13 r_spend_com_social_14 r_spend_com_social_15 r_spend_com_social_16) byte anymiss
11 1100015   1         0         0         0         0 0
11 1100023   2         0         . 534165.25 150514.45 1
11 1100031   3         0         0         0         0 0
11 1100049   4         0         0         0         0 0
11 1100056   5         0         0         0         0 0
11 1100064   6         0         0         0         0 0
11 1100072   7         0         0         0         0 0
11 1100080   8         0         0         0         0 0
11 1100098   9         0         0         0         0 0
11 1100106  10         0         0         0         0 0
11 1100114  11         0         0         0         0 0
11 1100122  12         0         0         0         0 0
11 1100130  13         0         0         0         0 0
11 1100148  14         0         0         0         0 0
11 1100155  15         0         0         0         0 0
11 1100189  16         0         0         0         0 0
11 1100205  17         0         0         0 2217387.3 0
11 1100254  18         0         0         0         0 0
11 1100262  19         0         0         0         0 0
11 1100288  20         0         0         0         0 0
11 1100296  21         0         0         0         0 0
11 1100304  22         0         0         0         0 0
11 1100320  23         0         0         0         0 0
11 1100338  24         0         0         0         0 0
11 1100346  25         0         0         0         0 0
11 1100379  26         0         0         0         0 0
11 1100403  27         0         0         0         0 0
11 1100452  28         0         0         0         0 0
11 1100502  29         0         0         0         0 0
11 1100601  30         0         0         0         0 0
11 1100700  31         0         0         0         0 0
11 1100809  32         0         0         0         0 0
11 1100908  33         0         0         0         0 0
11 1100924  34         0         0         0         0 0
11 1100940  35         0         0         0         0 0
11 1101005  36         0         .         0         0 1
11 1101104  37         0         0         0         0 0
11 1101203  38         0         0         0         0 0
11 1101302  39         0         0         0         0 0
11 1101401  40         0         0         0         0 0
11 1101435  41         0         0         0         0 0
11 1101450  42         0         0         0         0 0
11 1101468  43         0         0         0         0 0
11 1101476  44         0         0         0         0 0
11 1101484  45         0         0         0         0 0
11 1101492  46         0         0         0         0 0
11 1101500  47         0         0         0         0 0
11 1101559  48         0         0         0         0 0
11 1101609  49         0         0         0         0 0
11 1101708  50         0         0         0         0 0
11 1101757  51         0         0         0         0 0
11 1101807  52         0         0         0         0 0
12 1200054  53         0         .         .         . 3
12 1200104  54         0         0         0         0 0
12 1200138  55         0         .         .         . 3
12 1200179  56         0         0         0         0 0
12 1200203  57  432696.5 379902.75 308668.53  315201.4 0
12 1200252  58         0         .         0         0 1
12 1200302  59         0         0         0         0 0
12 1200328  60         0         0         0         0 0
12 1200336  61         0         0         0         0 0
12 1200344  62         0         0         0         0 0
12 1200351  63         0         0         0         0 0
12 1200385  64         0         0         0         0 0
12 1200393  65         0         0         0         0 0
12 1200401  66   6220746         0         0         0 0
12 1200427  67         0         .         0         0 1
12 1200435  68         0         .         0         0 1
12 1200450  69         0  69092.03         .         . 2
12 1200500  70         0         0         0         0 0
12 1200609  71         0         0         0         0 0
12 1200708  72  208677.9  521431.5  479175.3  346828.7 0
12 1200807  73         0         0         0         0 0
13 1300029  74         0         0         0         0 0
13 1300060  75         0         0         0         0 0
13 1300086  76         0         0         0         0 0
13 1300102  77         0         0         0         0 0
13 1300144  78         0         0         0         0 0
13 1300201  79         0         .         0         . 2
13 1300300  80         0         0         0         0 0
13 1300409  81         0         0         0         0 0
13 1300508  82         0         0         0         . 1
13 1300607  83         0         0         0         0 0
13 1300631  84         0         0         0         0 0
13 1300680  85         0         0         0         0 0
13 1300706  86         0         0         0         0 0
13 1300805  87         0         0         0         0 0
13 1300839  88         0         0         0         0 0
13 1300904  89         0         0         0         0 0
13 1301001  90         0         0         0         0 0
13 1301100  91         0         0         0         . 1
13 1301159  92         0         0         0         0 0
13 1301209  93         0         0         0         0 0
13 1301308  94         0         0         0         0 0
13 1301407  95         0         0         .         . 2
13 1301506  96         0         0         0         0 0
13 1301605  97         0         0         0         0 0
13 1301654  98         0         0         0         . 1
13 1301704  99         0         0         0         0 0
13 1301803 100         0         0         0         . 1
13 1301852 101         0         0         0         0 0
13 1301902 102  612033.8  856509.7  311725.3         . 1
13 1301951 103         0         .         0         0 1
13 1302009 104         0         0         0         0 0
13 1302108 105         0         0         0         0 0
13 1302207 106         0         0         0         0 0
13 1302306 107         0         0         0         0 0
13 1302405 108         0         0         0         . 1
13 1302504 109         0         0         0         0 0
13 1302553 110         0         0         0         0 0
13 1302603 111  59281824  93353808 102807768  62416628 0
13 1302702 112         0         0         0         0 0
13 1302801 113         0         0         0         0 0
13 1302900 114         0         0         0         0 0
13 1303007 115         0         0         0         0 0
13 1303106 116         0         0         0         0 0
13 1303205 117         0         0         0         . 1
13 1303304 118         0         0         0         0 0
13 1303403 119  742396.3  729511.6  380142.8         . 1
13 1303502 120         0         .         .         0 2
13 1303536 121         0         0         0         0 0
13 1303569 122         0         0         0         0 0
13 1303700 123         0         0         0         0 0
13 1303809 124         0         0         0         0 0
13 1303908 125         0         0         0         0 0
13 1303957 126         0         0         0         0 0
13 1304005 127         0         0         0         0 0
13 1304062 128         0         0         .         . 2
13 1304104 129         0         0         0         0 0
13 1304203 130         0         0         0         0 0
13 1304237 131         0         0         0         0 0
13 1304302 132         0         0         0         0 0
13 1304401 133         0         0         0         0 0
14 1400027 134         0         0         0         0 0
14 1400050 135         0         0         .         . 2
14 1400100 136   4271962  13037366  17497512   9401562 0
14 1400159 137         0         0         0         0 0
14 1400175 138         0         0         0         . 1
14 1400209 139         0         0         0         . 1
14 1400233 140         0         0         0         0 0
14 1400282 141         0         0         .         . 2
14 1400308 142         0         0         0         0 0
14 1400407 143         0         .         0         0 1
14 1400456 144         0         0         0         0 0
14 1400472 145         0         0         0         0 0
14 1400506 146         0         0         0         0 0
14 1400605 147         0         .         .  694446.8 2
15 1500107 148         0         0         0         . 1
15 1500131 149         0         0         0         . 1
15 1500206 150         0         0         0         0 0
15 1500305 151         0         .         0         0 1
15 1500404 152  437.2232         0         0         0 0
15 1500503 153 116843.53 156885.27  20091.87         0 0
15 1500602 154 1953603.6   2931706         .         . 2
15 1500701 155  9414.873         0         .         . 2
15 1500800 156 2060956.5   2734569   3513713  506685.8 0
15 1500859 157         0         0         0         0 0
15 1500909 158  234134.5 137841.66  866.2955         . 1
15 1500958 159         0         0         0         0 0
15 1501006 160         0         .         .         . 3
15 1501253 161         0         0         0         0 0
15 1501303 162  902664.8 2280950.5  176533.7 1146923.9 0
15 1501402 163  16719332         0         0         0 0
15 1501501 164  321305.1 32871.617         0         0 0
15 1501576 165         0         0         0         . 1
15 1501709 166         0         0         0         . 1
15 1501725 167  26280.03         0         .         . 2
15 1501758 168         0         0         .         . 2
15 1501782 169 158545.88  627183.6    192278 264652.28 0
15 1501808 170 15614.698         .         .         . 3
15 1501907 171         0         0         0         . 1
15 1501956 172         0         0         .         0 1
15 1502004 173         0         0         .         . 2
15 1502103 174         0         .         .         . 3
15 1502152 175         0         0         0         0 0
15 1502202 176         0         0         0         0 0
15 1502301 177         0         0         .         . 2
15 1502400 178         0         0         .         . 2
15 1502509 179  6294.557         0         0         . 1
15 1502707 180         0         0         0         0 0
15 1502756 181         0         0         .         . 2
15 1502764 182 1734.3187         .         0         . 2
15 1502772 183  352579.7 287506.13         0         0 0
15 1502855 184         0         0         .         . 2
15 1502939 185 114355.73  70069.96  55777.05 103945.09 0
15 1502954 186         0         .         .         . 3
15 1503002 187         0         0         0         . 1
15 1503044 188         0         0         0         0 0
15 1503077 189         0         0         .         . 2
15 1503093 190 344109.25         0  1732.591         0 0
15 1503200 191         0         0         0         . 1
15 1503457 192         0         0         0         . 1
15 1503507 193         0  10546.31         .         . 2
15 1503606 194 377387.75  354713.5         .         . 2
15 1503705 195         0         0         0         0 0
15 1503754 196         0         0         0         0 0
15 1503804 197  9381.353         0         0         0 0
15 1503903 198  808559.8 540906.56 309795.94    286485 0
15 1504000 199         0         0         .         . 2
15 1504059 200  11009.28         0         0         . 1
15 1504208 201 1068471.5   3767498   7719586   2015447 0
15 1504307 202  84760.09 123735.62  61547.82         . 1
15 1504406 203  2914.821         0         .         . 2
15 1504422 204  653368.9         0         0         0 0
15 1504455 205         0         0         0         0 0
15 1504604 206         0         .         .         . 3
15 1504703 207         0         0         0         0 0
15 1504802 208         0         0         0         . 1
15 1504950 209         0         0         0         0 0
15 1504976 210         0         0         0         0 0
15 1505007 211         0  32385.39         .         . 2
15 1505031 212  81842.35         0         0         0 0
15 1505064 213  702136.8 66997.836  216623.4  78972.09 0
15 1505106 214  96480.59  178739.4 206189.47 166735.03 0
15 1505205 215         0         0         0         . 1
15 1505304 216         0         0         0         0 0
15 1505403 217         0         0         0         0 0
15 1505437 218         0         0         .         . 2
15 1505486 219  66312.19         0         0         0 0
15 1505502 220         0         0         0         0 0
15 1505536 221 2018968.5   6104638         0         0 0
15 1505551 222         0         0         0         . 1
15 1505601 223         0         0         0         0 0
15 1505635 224  387.6712         0         0         0 0
15 1505650 225  7287.053 15633.193         .         . 2
15 1505700 226  40242.02  9351.976  5634.634   5558.61 0
15 1505809 227         0         0         0         . 1
15 1505908 228         0  6648.285         .         . 2
15 1506005 229         0  42427.67         .         . 2
15 1506104 230         0         0         0         0 0
15 1506138 231         0         0         .         0 1
15 1506161 232         0         0         0         0 0
15 1506187 233 13214.343  97373.95 152715.53 124784.63 0
15 1506195 234         0         0         .         . 2
15 1506203 235         0         0  9899.283 14508.975 0
15 1506302 236         0         0         0         . 1
15 1506351 237         0         .         .         0 2
15 1506401 238 12982.614         0         0         . 1
15 1506500 239 14772.314         0  8910.469         0 0
15 1506559 240         0         0         0         . 1
15 1506583 241         0         0         0         0 0
15 1506609 242         0         0         0         0 0
15 1506708 243  3452.606  84448.55         0         . 1
15 1506807 244  326642.2 2008625.6 2449789.8  662017.3 0
15 1507003 245         0         .         .         . 3
15 1507151 246         0  8033.001   9661.67  3582.707 0
15 1507300 247         0         0         0         0 0
15 1507409 248         0         .         .         . 3
15 1507458 249         0         0         .         . 2
15 1507607 250         0         .         0         0 1
15 1507706 251         0         0         0         . 1
15 1507755 252   45998.8 10409.346  12375.65  8150.455 0
15 1507805 253         0         0         0         0 0
15 1507904 254         0         0         0         0 0
15 1507953 255         0         0  80999.87  166973.7 0
15 1507979 256         0         0         0         0 0
15 1508001 257         0         0         0         0 0
15 1508035 258  26516.13         0         .         0 1
15 1508050 259         0         0         0         0 0
15 1508084 260         0         0         0         0 0
15 1508100 261 2243616.8 1055617.3   1650355 1412796.4 0
15 1508126 262         0         0         0         0 0
15 1508159 263         0         0         .         0 1
15 1508209 264         0         0         .         . 2
15 1508308 265         0         0         0         0 0
15 1508357 266 2075237.8         .         .         . 3
15 1508407 267  100395.2         .         0         0 1
16 1600105 268         0         0         .         . 2
16 1600204 269         0         0         .         . 2
16 1600238 270         0         0         .         . 2
16 1600279 271         0         0         0         . 1
16 1600303 272 2186844.8 4811547.5   6564863  611271.3 0
16 1600402 273         0 19206.611         .         . 2
16 1600535 274         0         0         0         . 1
16 1600600 275         0         .         .         . 3
16 1600709 276         0         0         .         . 2
16 1600808 277         0         0         0         0 0
17 1700251 278 511.55115         0         0         0 0
17 1700301 279         0         0         0         0 0
17 1700350 280         0         0         0         0 0
17 1700400 281         0         0         0         0 0
17 1700707 282         0         0         0         0 0
17 1701002 283         0         0         0         0 0
17 1701051 284         0         0         0         0 0
17 1701101 285         0         0         0         0 0
17 1701309 286         0  89299.86         0  40691.73 0
17 1701903 287         0         0         0         0 0
17 1702000 288         0         0         0         0 0
17 1702109 289  33940.18         .         0         0 1
17 1702158 290         0         0         0         0 0
17 1702208 291         0         0         0         0 0
17 1702307 292         0         0         0         0 0
17 1702406 293         0         0         0         0 0
17 1702554 294         0         0         0  325290.5 0
17 1703008 295         0         0         0         0 0
17 1703057 296         0         0         0         0 0
17 1703073 297         0         0         0         0 0
17 1703107 298         0         0         0         0 0
17 1703206 299  29084.09         0 2309.2964         0 0
17 1703305 300         0         0         0         0 0
17 1703602 301         0         0         0         0 0
17 1703701 302         0         0         0         0 0
17 1703800 303         0         0         0         0 0
17 1703826 304         0         0         0  16236.87 0
17 1703842 305         0         0         0         0 0
17 1703867 306         0         0         0         0 0
17 1703883 307         0         0         0         . 1
17 1703891 308         0         0         0         0 0
17 1703909 309         0         0         0         0 0
17 1704105 310         0         0         0         0 0
17 1704600 311         0         0         0         0 0
17 1705102 312         0         0         0         0 0
17 1705508 313  353072.3  644650.8  934740.3         0 0
17 1705607 314         0         0         0         0 0
17 1706001 315         0         0         0         0 0
17 1706100 316         0         0         0         0 0
17 1706258 317         0         0         0         0 0
17 1706506 318         0         0         0         0 0
17 1707009 319         0         0         0         0 0
17 1707108 320         0         0         0         0 0
17 1707207 321         0         0         0         0 0
17 1707306 322         0         0         0         0 0
17 1707405 323         0         0         0         0 0
17 1707553 324         0         0         0         0 0
17 1707652 325         0         0         0         0 0
17 1707702 326         0         0         .         0 1
17 1708205 327         0         0         0         0 0
17 1708254 328         0         0         .         . 2
17 1708304 329         0         0         0         0 0
17 1709005 330         0         0         .         . 2
17 1709302 331         0         0         0         0 0
17 1709500 332    879030   1786979 291674.28         0 0
17 1709807 333         0         0         0         0 0
17 1710508 334         0         0  673.2354         0 0
17 1710706 335         0         0         0         0 0
17 1710904 336         0         0         0         0 0
17 1711100 337         0  434.1793         0         0 0
17 1711506 338  3935.009         0         0         0 0
17 1711803 339         0         0  55923.09         0 0
17 1711902 340         0         0         0         0 0
17 1711951 341         0         0         0         0 0
17 1712009 342         0         0         0         0 0
17 1712405 343         0         0         0         0 0
17 1712454 344         0         0         0         0 0
17 1712504 345         0         0         0         0 0
17 1712702 346         0         0         0         0 0
17 1712801 347         0         0         0         0 0
17 1713205 348         0         0         0         0 0
17 1713304 349         0         .  1817.983   2456.78 1
17 1713601 350         0         0         0         0 0
17 1713700 351         0         0         0         0 0
17 1713809 352         0         0         0         0 0
17 1713957 353         0         0         0         0 0
17 1714203 354         0         0         0         0 0
17 1714302 355         0         0  967710.3         0 0
17 1714880 356         0         0         0         0 0
17 1715002 357         0         0         0         0 0
17 1715259 358         0         0         0         . 1
17 1715507 359  140976.8  176324.7 281273.78  243336.5 0
17 1715705 360         0         0         0         . 1
17 1715754 361         0         0         0         0 0
17 1716109 362         0         0         0         0 0
17 1716208 363         0         0         0         0 0
17 1716307 364         0         0         0         0 0
17 1716505 365         0         0         0         0 0
17 1716604 366         0         0         0         0 0
17 1716653 367         0         0         0         0 0
17 1716703 368         0         0         0         0 0
17 1717008 369         0         0         0         0 0
17 1717206 370  9910.393         0         .         0 1
17 1717503 371         0         .         0         0 1
17 1717800 372         0         0         0         . 1
17 1717909 373         0         0         0         0 0
17 1718006 374         0         0         0         0 0
17 1718204 375  261424.5  193646.7  365408.4 197360.94 0
17 1718303 376         0         0         0         0 0
17 1718402 377         0         0         0         0 0
17 1718451 378         0         0         0         0 0
17 1718501 379         0         0         0         0 0
17 1718550 380         0         0         0         0 0
17 1718659 381         0         0         0         0 0
17 1718709 382         0         0         0         0 0
17 1718758 383         0         0         0         0 0
17 1718808 384         0         0         0         . 1
17 1718840 385         0         0         0         0 0
17 1718865 386         0         0         0         0 0
17 1718881 387         0         0         0         0 0
17 1718899 388         0         0         0         0 0
17 1718907 389         0         0         0         0 0
17 1719004 390         0         0         0 16567.547 0
17 1720002 391         0         0         0         0 0
17 1720101 392         0         0         0         0 0
17 1720150 393         0         0         0         0 0
17 1720200 394         0         0  618.7825 14038.577 0
17 1720259 395         0         0         0         0 0
17 1720499 396         0         0         0         0 0
17 1720655 397         0         0         0         0 0
17 1720804 398         0         0         0         0 0
17 1720853 399         0         0         0         0 0
17 1720903 400 1101.8025         0         0         0 0
17 1720937 401         0         0         0         0 0
17 1720978 402         0         0         0         0 0
17 1721000 403         0         0         0         0 0
17 1721109 404         0         0         0         0 0
17 1721208 405         0         0         0         0 0
17 1721257 406         0         0         0         0 0
17 1721307 407         0         0         0  93882.77 0
17 1722081 408         0         0         0         0 0
17 1722107 409         0         0         0         0 0
21 2100055 410  834134.4  837737.3         0         0 0
21 2100105 411         0         0         0         0 0
21 2100154 412         0         0         .         . 2
21 2100204 413         0         0         0         0 0
21 2100303 414  5928.747   6941.39         0  6147.772 0
21 2100402 415         0         0         0         0 0
21 2100436 416         0         0         0         0 0
21 2100477 417         0         0         0         0 0
21 2100501 418         0         0         0         0 0
21 2100550 419         0         0         0         . 1
21 2100600 420         0  56.15568         0         0 0
21 2100709 421         0         0         .         0 1
21 2100832 422         0         0         0         0 0
21 2100873 423  85848.77         0         0         0 0
21 2100907 424         0         0         0         0 0
21 2100956 425         0         0         0         0 0
21 2101004 426         0         0         .         0 1
21 2101103 427         0         0         0         0 0
21 2101202 428  500812.9  821.7904   779.666 144519.22 0
21 2101251 429         0         0         0         0 0
21 2101301 430         0         0         0         . 1
21 2101350 431         0         0         0         0 0
21 2101400 432         0         0         0         . 1
21 2101509 433         0         0         0         0 0
21 2101608 434         0         0         0         0 0
21 2101707 435         0         0         0         . 1
21 2101731 436         0         0         0         . 1
21 2101772 437         0         0         0         0 0
21 2101905 438         0         0         0         0 0
21 2101939 439         0         0         0         0 0
21 2101970 440         0         0         0         0 0
21 2102002 441         0         0         .         0 1
21 2102036 442         0         0         .         0 1
21 2102077 443         0         0         0         0 0
21 2102101 444         0         0         0         . 1
21 2102150 445         0         0         0         0 0
21 2102200 446         0         0         0         0 0
21 2102309 447         0         . 290477.56 115744.62 1
21 2102325 448         0         0         0         0 0
21 2102358 449  177913.4 169102.56 208142.34 214742.38 0
21 2102374 450         0         0         0         0 0
end