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/
