Thursday, October 1, 2020

error in copying table from stata to excel

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.

No comments:

Post a Comment