Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: Logout splits long value names across many cells in Excel


From   Ángel Rodríguez Laso <angelrlaso@gmail.com>
To   statalist@hsphsun2.harvard.edu
Subject   st: Logout splits long value names across many cells in Excel
Date   Wed, 14 Oct 2009 09:37:04 +0200

Sorry if this message appears twice. I'm having problems to post it.


Dear Statalisters,

I'm using Stata 9.2 with version 1.0.2 05May2009 of logout.

These are the commands I'm issuing:

use "C:\Documents and Settings\rodriguezla\Escritorio\ERSM 2007\No
respuesta\titulares_muestra_teorica.dta", clear
caplog using mylog.txt, replace: ///
bys sex:tab edadgr inciden, row
chewfile using mylog.txt, begin(11) end(.) save(chewed.txt) replace
logout, use(chewed.txt) clear fix
logout, save(resultados) excel fix(1) replace


and this is one of the tables (for men) I get. Note that "inciden" and
"edad" have some values with long labels:


    RECODE of |                                   inciden
         edad |  ausencia  defunción  dirección    enfermo  hospitali
larga aus   negativa |     Total
--------------+-----------------------------------------------------------------------------+----------
 16 a 24 años |       179          0          1          0          0
       33        107 |       742
              |     24,12       0,00       0,13       0,00       0,00
     4,45      14,42 |    100,00
--------------+-----------------------------------------------------------------------------+----------
 25 a 34 años |       343          1          2          1          0
       61        159 |     1.304
              |     26,30       0,08       0,15       0,08       0,00
     4,68      12,19 |    100,00
--------------+-----------------------------------------------------------------------------+----------
 35 a 44 años |       278          1          2          1          0
       47        148 |     1.104
              |     25,18       0,09       0,18       0,09       0,00
     4,26      13,41 |    100,00
--------------+-----------------------------------------------------------------------------+----------
 45 a 54 años |       226          2          2          1          0
       47        127 |       821
              |     27,53       0,24       0,24       0,12       0,00
     5,72      15,47 |    100,00
--------------+-----------------------------------------------------------------------------+----------
 55 a 64 años |       166          4          1          0          2
       33        119 |       661
              |     25,11       0,61       0,15       0,00       0,30
     4,99      18,00 |    100,00
--------------+-----------------------------------------------------------------------------+----------
 65 a 74 años |       155         18          3          2          3
       45        116 |       764
              |     20,29       2,36       0,39       0,26       0,39
     5,89      15,18 |    100,00
--------------+-----------------------------------------------------------------------------+----------
75 y más años |        72         40          6          3         12
       27         75 |       506
              |     14,23       7,91       1,19       0,59       2,37
     5,34      14,82 |    100,00
--------------+-----------------------------------------------------------------------------+----------
        Total |     1.419         66         17          8         17
      293        851 |     5.902
              |     24,04       1,12       0,29       0,14       0,29
     4,96      14,42 |    100,00


    RECODE of |                   inciden
         edad | no habla   no vive a      otros  realizado |     Total
--------------+--------------------------------------------+----------
 16 a 24 años |         1        137          8        276 |       742
              |      0,13      18,46       1,08      37,20 |    100,00
--------------+--------------------------------------------+----------
 25 a 34 años |         0        361         19        357 |     1.304
              |      0,00      27,68       1,46      27,38 |    100,00
--------------+--------------------------------------------+----------
 35 a 44 años |         2        278          9        338 |     1.104
              |      0,18      25,18       0,82      30,62 |    100,00
--------------+--------------------------------------------+----------
 45 a 54 años |         0        127          6        283 |       821
              |      0,00      15,47       0,73      34,47 |    100,00
--------------+--------------------------------------------+----------
 55 a 64 años |         0         58          6        272 |       661
              |      0,00       8,77       0,91      41,15 |    100,00
--------------+--------------------------------------------+----------
 65 a 74 años |         0         51         11        360 |       764
              |      0,00       6,68       1,44      47,12 |    100,00
--------------+--------------------------------------------+----------
75 y más años |         0         44          5        222 |       506
              |      0,00       8,70       0,99      43,87 |    100,00
--------------+--------------------------------------------+----------
        Total |         3      1.056         64      2.108 |     5.902
              |      0,05      17,89       1,08      35,72 |    100,00


In Excel, "RECODE of inciden" is split across 7 cells, "16 a 24 años"
(and the rest of "edad" labels) is split across 4 cells and hospitali
is split across two cells with two columns bellow it, one with blanks
and another one with the numbers. This is specially annoying when
copying cells inside Excel.

Is there any way to correct this behaviour?

Many thanks in advance.

Angel Rodriguez-Laso

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index