# st: RE: RE: Question about tabsort (shorter alternative)

 From "Rodrigo Briceņo" To Subject st: RE: RE: Question about tabsort (shorter alternative) Date Fri, 12 Jul 2002 11:20:15 -0600

```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.

and so on.....

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`````![9
`
end

*
*   For searches and help try:
*   http://www.stata.com/support/faqs/res/findit.html
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/
```