I am trying to do summation of the below code
Since some of the variables have missing values, it's mechanical for Stata for the summation to be "missing value". I have gone through some useful threads in the forum about using "rowmean" or "mvencode" but I want Stata to just to ignore and execute the summation.
Thank you in advance for your useful advice
Code:
gen NET_OA_X = WC03995_X + WC03255 - WC02003 - WC02008_X
Thank you in advance for your useful advice
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str9 Ticker int Year long WC02003 float(WC02008_X WC03995_X) long WC03255 "TH:2S" 1995 . . . . "TH:2S" 1996 . . . . "TH:2S" 1997 . . . . "TH:2S" 1998 . . . . "TH:2S" 1999 . . . . "TH:2S" 2000 . . . . "TH:2S" 2001 . . . . "TH:2S" 2002 . . . . "TH:2S" 2003 . . . . "TH:2S" 2004 . . . . "TH:2S" 2005 . . . . "TH:2S" 2006 . . 345320 236730 "TH:2S" 2007 . . 439690 253030 "TH:2S" 2008 . . 391530 117320 "TH:2S" 2009 . . 554153 289213 "TH:2S" 2010 . . 575584 396171 "TH:2S" 2011 . . 603719 390936 "TH:2S" 2012 . . 626362 578524 "TH:2S" 2013 87609 0 690686 471997 "TH:2S" 2014 65468 . 700135 460828 "TH:A" 1995 . . . . "TH:A" 1996 . . . . "TH:A" 1997 . . . . "TH:A" 1998 . . . . "TH:A" 1999 . . . . "TH:A" 2000 . . . . "TH:A" 2001 . . . . "TH:A" 2002 . . . . "TH:A" 2003 35078 . 656796 1149964 "TH:A" 2004 107446 . 1517721 2153251 "TH:A" 2005 37647 . 1450641 2571542 "TH:A" 2006 42356 . 1458833 2510792 "TH:A" 2007 27664 . 1380197 2983879 "TH:A" 2008 51572 . 1408293 3386083 "TH:A" 2009 166292 . 1926301 2530846 "TH:A" 2010 112267 . 2354251 2585774 "TH:A" 2011 87237 . 2423938 2927868 "TH:A" 2012 224595 . 2495551 4019053 "TH:A" 2013 78700 28747 2858784 5672756 "TH:A" 2014 220895 81 2873635 8331479 "TH:AA" 1995 37146 0 5437123 7579417 "TH:AA" 1996 17199 0 4524140 13011105 "TH:AA" 1997 1715441 45 6205142 31847758 "TH:AA" 1998 80577 870415 13593839 24750901 "TH:AA" 1999 464220 128117 4186183 25115631 "TH:AA" 2000 479444 86888 4770155 24588753 "TH:AA" 2001 341432 1282 4976994 23064131 "TH:AA" 2002 200963 0 6178108 19990430 "TH:AA" 2003 387898 74306 7685882 19143927 "TH:AA" 2004 518683 0 9189273 16261586 "TH:AA" 2005 740597 0 12222964 15378311 "TH:AA" 2006 773469 0 14246269 13304430 "TH:AA" 2007 303370 0 14632162 11318921 "TH:AA" 2008 . . . . "TH:AA" 2009 . . . . "TH:AA" 2010 . . . . "TH:AA" 2011 . . . . "TH:AA" 2012 . . . . "TH:AA" 2013 . . . . "TH:AA" 2014 . . . . "TH:AAV" 1995 . . . . "TH:AAV" 1996 . . . . "TH:AAV" 1997 . . . . "TH:AAV" 1998 . . . . "TH:AAV" 1999 . . . . "TH:AAV" 2000 . . . . "TH:AAV" 2001 . . . . "TH:AAV" 2002 . . . . "TH:AAV" 2003 . . . . "TH:AAV" 2004 . . . . "TH:AAV" 2005 . . . . "TH:AAV" 2006 . . . . "TH:AAV" 2007 . . . . "TH:AAV" 2008 . . . . "TH:AAV" 2009 654076 8868 . 4017 "TH:AAV" 2010 557822 8978 . 202537 "TH:AAV" 2011 1374161 9120 . 513186 "TH:AAV" 2012 3870222 2295901 18310504 1920255 "TH:AAV" 2013 1971994 4481179 19345888 8160839 "TH:AAV" 2014 4795174 1503199 19534212 12076968 "TH:ABICO" 1995 . . . . "TH:ABICO" 1996 . . . . "TH:ABICO" 1997 . . . . "TH:ABICO" 1998 . . . . "TH:ABICO" 1999 . . . . "TH:ABICO" 2000 3585 0 . 2637924 "TH:ABICO" 2001 648 340 . 1578877 "TH:ABICO" 2002 531 0 . 955646 "TH:ABICO" 2003 317 0 . 898699 "TH:ABICO" 2004 574 0 . 2816856 "TH:ABICO" 2005 4333 . 16072 770019 "TH:ABICO" 2006 . . 21277 681535 "TH:ABICO" 2007 1640 . . 668853 "TH:ABICO" 2008 1801 0 . 624209 "TH:ABICO" 2009 4515 0 . 518439 "TH:ABICO" 2010 4907 . . 484172 "TH:ABICO" 2011 1596 . 26999 434821 "TH:ABICO" 2012 2952 . 374249 415137 "TH:ABICO" 2013 2578 5576 422297 322983 "TH:ABICO" 2014 8124 4550 534200 319266 end format %ty Year
Comment