Array ----------------------- copy starting from the next line -----------------------
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input int YEAR double FARM_WORK_DAYS int NF_WORK_DAYS double(own_lst own_dome own_farm) str1 GENDER
2009  76 249   0  109   0 "M"
2009  68  62   0   50   0 "F"
2009  51 325  37   65  18 "M"
2009   . 377   0   62   6 "M"
2009  65 352  14  174   3 "M"
2009   . 670   0  168  58 "M"
2009  31  12   0  117   0 "M"
2009   3 446   0  221   0 "M"
2009  44 119   0  100   0 "M"
2009  96 380 134  138  18 "M"
2009   . 864  81  355  77 "M"
2009  10 125 312  128 142 "M"
2009   . 206   0   70   3 "F"
2009   .   . 218  148  75 "M"
2009   . 502 106  155 121 "M"
2009   .  18   0   73   0 "F"
2009  20 351   0   87   0 "M"
2009  12 482 120  182  96 "M"
2009  31 108 130  174 133 "M"
2009  56 247  58  124  59 "M"
2009   6 695  49  164  71 "M"
2009   . 388  52   94  62 "M"
2009   5 412  96  214  70 "M"
2009  42 622   0  282   0 "M"
2009  20  15 142  172 106 "M"
2009   . 370 220  119 115 "M"
2009   .   .   6  111  17 "M"
2009 199 374  21   76   0 "F"
2009  37 377  55  100  82 "M"
2009   2 374  38  114  60 "M"
2009   8 312   0  115  53 "M"
2009  19 399  49   55  33 "M"
2009 126 412   0  116   0 "M"
2009  15 315   0   78   0 "M"
2009   . 249  98  127 113 "M"
2009   . 429  95   89 101 "M"
2009 111 263   0  149   0 "F"
2009  37 342   0  133   0 "M"
2009  52   . 150  168   2 "M"
2009  15  11 131   89  92 "M"
2009  34  54 139   80 104 "M"
2009  34 432 115  128  69 "M"
2009   . 702  51  225  26 "M"
2009   .  10 176  121  45 "M"
2009   .   2   0  109  24 "M"
2009   9   .  97  223 144 "M"
2009 239  89 172   91   0 "M"
2009 407   .   0  107   0 "M"
2009 107 367 128  136  19 "M"
2009  83 185   0  124   0 "M"
2009 129  48   0   87  10 "M"
2009   . 497 116  116  50 "M"
2009   . 378  78  130  62 "M"
2009   .   . 210  130  74 "M"
2009  53 284   0   65   0 "F"
2009   .  15 225   93 109 "M"
2009   .   . 230  135  26 "M"
2009 277 122   0   93   0 "M"
2009  38 474   0   76   0 "M"
2009   . 190   0   65   0 "F"
2009   .   . 211  121  37 "M"
2009   . 285  22  146  20 "F"
2009 259 383   0  130   0 "M"
2009  55 416   0  159   0 "M"
2009   . 338   0   61   0 "M"
2009  37 251   0  147  12 "M"
2009   7 277   0   97  27 "M"
2009  18 281   0 95.5   8 "M"
2009  95  68   0  120  20 "F"
2009  81 254 163   90  29 "M"
2009   7 139   0  202   0 "M"
2009  12  21 117  192  94 "M"
2009  65 227   0  239   0 "F"
2009  52 500   0  198   0 "M"
2009  73 827   0  431   0 "F"
2009  49 763   0  315  10 "M"
2009  24   . 172  212 109 "M"
2009   .   .   0  182   0 "F"
2009   . 374 109  441 138 "M"
2009  96 242 101  354 390 "M"
2009   . 458   0  287   0 "M"
2009   . 204   0   99   0 "M"
2009   . 157   0  225   0 "M"
2009  47 194 144  218 149 "M"
2009  39   .  95  244 261 "M"
2009   .   .   0  213  83 "M"
2009   . 246   0  272  11 "M"
2009   . 234 211  283 168 "M"
2009 114  88 255  176  97 "M"
2009  47 115   0  151   0 "M"
2009  23  72 326  235 105 "M"
2009   .  93   0  147 114 "M"
2009  11 358   0  363   0 "F"
2009  57 244   0  215 143 "M"
2009   .  27   0  242 171 "M"
2009   . 400   0  237   0 "M"
2009 104 107   0  200   0 "F"
2009 119 126   0  214 110 "F"
2009  66 325   0  178   0 "M"
2009   . 384   0  253   0 "M"
end
Code:
------------------ copy up to and including the previous line ------------------

Listed 100 out of 5195 observations
Use the count() option to list more

. table GENDER YEAR, contents(mean FARM_WORK_DAYS mean NF_WORK_DAYS mean own_farm mean own_dome mean own_lst ) format(%9.2f)

----------------------------------------------------------
          |                      YEAR                    
   GENDER |   2009    2010    2011    2012    2013    2014
----------+-----------------------------------------------
        F |  92.51  183.09  174.51  212.80  169.88  178.70
          | 213.62  313.04  383.80  365.82  370.90  387.51
          |  28.14   57.55   64.17   56.33   63.05   63.91
          | 166.92  320.98  262.06  266.16  241.07  258.98
          |  27.98   63.48   46.19   36.49   41.54   44.19
          |
        M |  95.42  216.83  197.90  197.82  193.83  183.56
          | 166.79  330.65  347.30  371.75  359.47  365.45
          |  59.99  164.85  164.28  181.89  166.98  155.86
          | 211.88  397.51  357.10  378.47  371.83  371.11
          |  76.03  140.10  126.76  115.82  122.23  121.28
----------------------------------
when i copy this table to excel then for years 2011 and 2012 data comes in one column which must come in two different columns.
please help me to resolve this error.