Following with my previous doubts: I have a hospital discharges database,
and two of the variables from the list are: diaest1 and clave1. i already
processed the data to find the 10 most frequently diagnoses with the help of
egen group. What do I need to do if I want the same thing, but this time I
want to separate the variable diaest1. Let's say that I need the first 10
diagnoses for the discharges that have a duration of 6 or more days, and the
first 10 diagnoses for the discharges that have a duration fewer than 2
days. I already make a variable with establish those durations (called
rank_estancia2).
rank_estancia2=1 (diaest <2 days)
rank_estancia2=2 (diaest 2-5 days)
rank_estancia2=1 (diaest 6 or more days)
I tried to do something with egen group but my tries didn't seem to be
useful. I already tried typing:
tabsort clave1 if rank_estancia2==1 & group<11 (where group being the
variable calculated for the first answer of the day to this list and Nick
Cox help me to build). Sorry for my ignorance.
Rodrigo
begin 666 winmail.dat
M>)\^(BP6`0:0" `$```````!``$``0>0!@`(````Y 0```````#H``$(@ <`
M& ```$E032Y-:6-R;W-O9G0@36%I;"Y.;W1E`#$(`0V ! `"`````@`"``$&
M@ ,`#@```-('!P`,`! `$ ````4`$0$!`Y &`%@'```F````"P`"``$````+
M`",```````,`)@``````"P`I```````#`#8``````!X`< `!````'0```$]N
M92!L87-T('%U97-T:6]N(&%B;W5T(&5G96X``````@%Q``$````6`````<(I
M\<VR=XD3.>KD2.B>Y!0K% ^6RP```@$=# $````;````4TU44#I20E))0T5.
M3T!304Y)1T535"Y#3TT```L``0X`````0 `&#@#0R;/Q*<(!`@$*#@$````8
M`````````(DOD*ZI'LU/K(F*650/:K3B@@```P`4#@$````+`!\.`0````(!
M"1 !````( ,``!P#```W!0``3%I&=942B^X#``H`<F-P9S$R->(R`T-T97@%
M00$#`??_"H "I /D!Q,"@ _S`% $5C\(50>R$24.40,!`@!C:.$*P'-E=#(&
M``;#$27V,P1&$[<P$BP1,PCO"?>V.Q@?#C U$2(,8&,`4#,+"0%D,S864 NF
M($9'!O 7L /P;F<@`_!T0&@@;7D@<!@@=A9I"& $(&0(8&)T<R Z("!)(!/@
M=F7$(&$?0&]S<!V@!T"7'I $`!/29P>19&$!D0IA%! L'Y!N9"!TH'=O(&]F
M(=!H'X!^=@K !S "8 >1`U(B0VRW! `%0 K 91\`(%!A!Y T=#$ADV,+8!]P
M,2Z4(&D?D&P8(&%D'?+\;V,'D!00(<$B82$"(=#M(@!F"X FQ#$64 1@(^'9
M`U!E<0I0`C!L'? D87QG;A_0!Y$=DR)2(F!L>G B$F4@P .@"< (8'"])8!7
M$^ %0!Z@'R%N">#?(<$B`"PA!I ?(7<`< 5 >2)2<V$'@")!'5$A@&+^=2VB
M! `AT =Q+4<B`!00OPJQ(1 N,B)X)%8E@$P4(/XG!" N`!WP'; K\2Q6(F'_
M)Z 4``5 *#$I: (0!< FX_<@:#+3'U5D"' A$!Y0`Z!](B$V(A %P 1@&" @
M\7F^<R&%,Z\TOS7/-MEF!]#_$H$RT0.@%$ X4B6 'S EQOT`P&L?@C$7'9,D
MD2+1! #/*C(IL3;G!" H8P= (O C(< P@&YK7T ";F/Q!S R*2X*H@J$"H!"
M+$H]), H)&0@/#V4*8]#CT22%$!$]C(M-46?OT0_(^$WO$AE0R0?,'0(@?TL
MIG,#<!0@+F(_I2LG+K.''>%,,AZ!:61N)P5 [10092-A(@!B'X >< $0['5L
M/?I,-7D?\!U@'P#_0R0!D4SP`" E%2T22-U$P=(F*U0\,431=R)@."'=3C5E
M'5(PVT&Q8U# ,)'_(< Z9CDT`'$]`B(E.%$G8E<O`R/$(;%.#>!K$B%XURJ$
M+B)0,74#$&1#``8`W06P<AWP.F(=X6DID4(AER9P0QL(`&0%$&=O0R0"?6!@
M`P`)60$````+`!& "" &``````# ````````1@`````#A0````````,`$H (
M( 8``````, ```````!&`````!"%`````````P`3@ @@!@``````P ``````
M`$8`````4H4``(YJ`0`>`!2 "" &``````# ````````1@````!4A0```0``
M``0````Y+C `'@`5@ @@!@``````P ```````$8`````-H4```$````!````
M`````!X`%H (( 8``````, ```````!&`````#>%```!`````0`````````>
M`!> "" &``````# ````````1@`````XA0```0````$`````````"P`8@ @@
M!@``````P ```````$8`````#H4````````#`!F "" &``````# ````````
M1@`````1A0````````,`&H (( 8``````, ```````!&`````!B%````````
M"P`;@ @@!@``````P ```````$8`````!H4````````#`!R "" &``````#
M````````1@`````!A0````````(!^ \!````$ ```(DOD*ZI'LU/K(F*650/
M:K0"`?H/`0```! ```")+Y"NJ1[-3ZR)BEE4#VJT`@'[#P$```!P````````
M`#BANQ %Y1 :H;L(`"LJ5L(``&US<'-T+F1L; ``````3DE40?F_N $`J@`W
MV6X```!$.EQ->2!$;V-U;65N='-2;V1R:6=O7%)E<W!A;&1O<UQ/=71L;V]K
M7')E<W M,#(M,#$M,#(N<'-T``,`_@\%`````P`--/TW```"`7\``0```#$`
M```P,# P,# P,#@Y,D8Y,$%%03DQ14-$-$9!0S@Y.$$U.34T,$8V04(T,#1#
M-C)!,# ``````P`&$'1#8IT#``<0/0,```,`$! ``````P`1$ `````>``@0
M`0```&4```!&3TQ,3U=)3D=7251(35E04D5624]54T1/54)44SI)2$%614%(
M3U-0251!3$1)4T-(05)'15-$051!0D%312Q!3D145T]/1E1(159!4DE!0DQ%
84T923TU42$5,25-405)%.D1)`````'2K
`
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/
