Stata The Stata listserver
[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

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


From   "Rodrigo Briceņo" <rbriceno@sanigest.com>
To   <statalist@hsphsun2.harvard.edu>
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.

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`````![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/



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