Thanks Nick, right now you are my statahero. The option number 2 give me
exactly what I want.
Let me explain two more things:
1. CIE-10 is the international clasification of sicknesses. I think that I
can assign the code with the corresponding description in Excel, is not a
big deal.
2. Months ago I asked to the list how can I generate some age groups. I use
that help in order to have a frequency of the hospital discharges by age
groups. The problem here is that I found that my variable age was a string8
variable. Then the options to generate a new variable was restricted: I
tried typing:
gen str8 rank_edad=1 if inrange(edad,0,0) to construct my age groups (less
than 1 year, between 1 and 4, between 5 and 9, 10-19, 20-29, 30-39, 40-49,
50-59 and the last one 60 or more)
This not work for me so I try:
encode edad, gen (edad2) like I learned from my net course on Stata. The
things appear to be ok, because when I type tab edad2 I see all the ages
correctly. The problem here is that I'm building three groups (the first
three) that don�t have data on it. But Stata is calculating something on
it, I don't know why.
gen byte rank_edad=1 if range(edad2,0,0)
replace rank_edad=2 if inrange (edad2,1,4)
replace rank_edad=3 if inrange (edad2,5,9)
replace rank_edad=4 if inrange (edad2,10,19)
and so on.....
tab rank_edad
rank_edad | Freq. Percent Cum.
------------+-----------------------------------
1-4_anos | 90 1.73 1.73
5-9_anos | 1190 22.88 24.61
10-19_anos | 2114 40.64 65.24
20-29_anos | 892 17.15 82.39
30-39_anos | 304 5.84 88.24
40-49_anos | 202 3.88 92.12
50-59_anos | 162 3.11 95.23
Mas_60_anos | 248 4.77 100.00
------------+-----------------------------------
Total | 5202 100.00
Do you know or guess why Stata is putting data on the first three groups
that is supposed to be empty (I build those groups because I'm making a do
file, that I can apply to other databases).
Thanks....
Rodrigo
begin 666 winmail.dat
M>)\^(A 1`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$&
M@ ,`#@```-('!P`,``L`% ````4`$ $!`Y &`'P*```I````"P`"``$````+
M`",```````,`)@``````"P`I```````#`"X```````,`-@``````'@!P``$`
M```7````475E<W1I;VX@86)O=70@=&%B<V]R= ```@%Q``$````E`````<(I
MN7V>DA.N0@YV3PV[17#68\:X,@``)_7 ``(DC; ``*N1( ````(!'0P!````
M&P```%--5% Z4D)224-%3D] 4T%.24=%4U0N0T]-```+``$.`````$ `!@X`
MX !:R"G"`0(!"@X!````& ````````")+Y"NJ1[-3ZR)BEE4#VJTXH(```,`
M% X!````"P`?#@$````"`0D0`0```-$%``#-!0``(0H``$Q:1G7.SC!)`P`*
M`')C<&<Q,C7B,@-#=&5X!4$!`P'W3PJ `J0#XP(`8V@*P'/P970P( <3`H /
M\P!0?P16"%4'LA'%#E$#`1#',O<&``;#$<4S!$80R1+;$=/;".\)]SL8OPXP
M-1'"#&#.8P!0"PD!9#,V$5 +IF0@5!#P;FL'H0W@:R0L( 409V@%0&YO%0?@
M>0A@( K 92!M6'D@<P&0`9!H!)!OUBX=@1]@;P4P:0(@'K".=0;0$R$4X&=I
M=A]AIQ]@#L `T'1L'Y!W$/#-!4!)(I `<'0N"J(*@ Y,$3 AY M3('1W;R<?
M< 6P'V!T: N 9W,6.B-D(V0Q($!#247\+3$14 0`)3$?8 N #K#/!* ?T"#1
M!T @8PM@`)!N9@W@)^,@D&8?H!X1;KL'D!$@<R! (O E0FLE,=\BPRC0`Z H
M@ "09R21('&W!: !`"*0:25 *\5R&,#4<W "(&0E82 !``3T@R#2)(%%>&-E
M;!Y QR<1'L %0&$@8AYP+<%W!T C52-D,B! != "(6BY!"!A9R30(O H@&L)
M@+<DH"30)T)L! `%0&@>T7LK(B+P9PGP!) ?T!]@<[\#<!]@,< ?8 G "&!P
M*@/.=1$@*J0@`&QP+H(%L#\$@3)R$/ AP2^@`U!E<?D*4&YC'Y I02=",T M
M0'\L<"@Q+8 $\!#Q,^ $(&(W'Y TRB!B< -@`F!E;=\V(1]1)Q,BPP(0=2UP
M*J3]'X%V"L ',#MA-+,C$#&A]Q^A!1 E<#@]=R!#*[0@I/\G(230,^<OH"FP
M!^ ]ASY2[RTA/L$B4 F .BHB"($R8?YY./ E<"6K,^$^HC\0-""%'<!?"8!A
M9#TQ)P`O*5 +@$71,^ H1B(L,/U'@"DR<@6@`( ^P!MP/3/Y-,@@*#MP!!$J
ML0.@1G#Z>3 0<AY (4 DL GA2C&K`' R8#1*J#5+4SD>0$\FX";03+$!T"TR
M3+$S54SP,TRQ-$SP-$RQ-?E,\#4Y2U,RLRB !4 "(.\?8!S1!;$D\BDENAV0
M+S5]),!R*I "$%!1-%)#@WE_):LX`2PB1T,STDF 1B(R_T? ,O R0"+A.W *
MP"FP,F#_`U(?<BFP!4 %H AP-;$@X9Y3'\(@1"5$'S!P<$IQ_S)R(4 @D!XQ
M(4 HT#6B(J#_/_$J,40@)2$!H%2#%. B\/L1(#2A; ,@)T(TP00@+/.7(E(Z
MWSOI)SN08G4#$/\M@R5 "=%)%R="*+ 1$ 5 %V!31\$BLF0"(%PG8OXT,R$W
M4D8P`9!7PBQP,2$\0G4%0%@#)P(HT&QC_G4+8"# +:$T<B5#8[0>0/LB\&*1
M)P5 *: >T2*@7<#?1(XZ`#1!1=U&Z#)'@R-D?QC "U$NX$7)%.!&F%4E+-@Q
M+#1K+T7V,VS/:M#8-2PY;B]%]C1OSVW1OT>031!0M4MB4M$"("YU0I\ENEMR
M1<@ENG:)('PQ,-UXPD8WP3$A>,%0!) NX+<",'C$,3!#(2 C52U[67XK>UI\
MWWM4=Y9*,$Y07^\`<#C0>*9XP3D14'HU)G".-V^P@$E^5S4M.7\<UC%-$( F
M,C$0.#\0@Z5X-"XV&Y-WT4SC?QPR/X-0<K!XQ$XPA."&YC8UGBZ$P'>535-_
M'3@Y%.#Q@%4W+C%,4(G%,1!-\/]WE4W#?QU-P(;F3$"$((;F_X0PB$A.,W\=
M`="*1DVPA"@_BC"*X Y0=Z1.HW\=,39?D0F#4'^FB#&!I4TH@%^['-"/_C2$
M1DN0@, W@%7^,(=PF0!Z_WP/FV]^*GC!_E0O<"@Q?W8.0)#VF/HC9-Y$)- ?
M`F=C!;%G"E $$?MGL61X<&1098-C=F$]21;[*K,G$7,U,"U0$2 R8UG!]UZ
M!3 ?D"@B\%_#)3&E8>])%EHV7X(`P&LMDB^@8I#_86%><!Y *KI9,")Q,H$O
M<-L@`6-C8BB !Y I,$L=E*MU7@@`9!YA;R-D?:\`````'@!"$ $````T````
M/$5$15!+2TY,3TA-2%!!0TY"3TI%145'04-&04$N;BYJ+F-O>$!D=7)H86TN
M86,N=6L^``,`"5D!````"P`1@ @@!@``````P ```````$8``````X4`````
M```#`!* "" &``````# ````````1@`````0A0````````,`$X (( 8`````
M`, ```````!&`````%*%``".:@$`'@`4@ @@!@``````P ```````$8`````
M5(4```$````$````.2XP`!X`%8 (( 8``````, ```````!&`````#:%```!
M`````0`````````>`!: "" &``````# ````````1@`````WA0```0````$`
M````````'@`7@ @@!@``````P ```````$8`````.(4```$````!````````
M``L`&( (( 8``````, ```````!&``````Z%`````````P`9@ @@!@``````
MP ```````$8`````$84````````#`!J "" &``````# ````````1@`````8
MA0````````L`&X (( 8``````, ```````!&``````:%`````````P`<@ @@
M!@``````P ```````$8``````84````````+`!Z "" &``````# ````````
M1@````""A0```0````(!^ \!````$ ```(DOD*ZI'LU/K(F*650/:K0"`?H/
M`0```! ```")+Y"NJ1[-3ZR)BEE4#VJT`@'[#P$```!P`````````#BANQ %
MY1 :H;L(`"LJ5L(``&US<'-T+F1L; ``````3DE40?F_N $`J@`WV6X```!$
M.EQ->2!$;V-U;65N='-2;V1R:6=O7%)E<W!A;&1O<UQ/=71L;V]K7')E<W M
M,#(M,#$M,#(N<'-T``,`_@\%`````P`--/TW```"`7\``0```#$````P,# P
M,# P,#@Y,D8Y,$%%03DQ14-$-$9!0S@Y.$$U.34T,$8V04(T,#1#,S)!,# `
M`````P`&$%YXF\,#``<0Z 4```,`$! ``````P`1$ `````>``@0`0```&4`
M``!42$%.2U-.24-++%))1TA43D]764]505)%35E35$%404A%4D]42$5/4%1)
M3TY.54U"15(R1TE614U%15A!0U1,65=(051)5T%.5$Q%5$U%15A03$%)3E17
23TU/4D542$E.1U,Z`````
