Re: st: RE: ordering records

["Ricardo Guimaraes" <ricardo.guimaraes@uni-bonn.de>]

Dear Alex Organ,
Thanks a lot!
Cheers
Ricardo

On Tue, 6 Jun 2006 12:11:27 -0400
 "Alex Ogan" <aogan@ArrowstreetCapital.com> wrote:
> . list
>
>     +--------------------------------------+
>     | surmonth    iddom   i   sthome   age |
>     |--------------------------------------|
>  1. |        1   560036   1        1    57 |
>  2. |        1   560036   2        2    51 |
>  3. |        1   560036   3        3    27 |
>  4. |        1   560036   4        3    16 |
>  5. |        1   560036   5        3    13 |
>     +--------------------------------------+
>
> . gen dep_seq = .
> (5 missing values generated)
>
> . bysort surmonth iddom sthome (age): replace dep_seq = 
> _N - _n + 1 if
> sthome==3
> (3 real changes made)
>
> . list
>
>     +------------------------------------------------+
>     | surmonth    iddom   i   sthome   age   dep_seq |
>     |------------------------------------------------|
>  1. |        1   560036   1        1    57         . |
>  2. |        1   560036   2        2    51         . |
>  3. |        1   560036   5        3    13         3 |
>  4. |        1   560036   4        3    16         2 |
>  5. |        1   560036   3        3    27         1 |
>     +------------------------------------------------+
>
> .
>
> Hope this helps.
>
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu
> [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf 
> Of Ricardo
> Guimaraes
> Sent: Tuesday, June 06, 2006 12:01 PM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: ordering records
>
> I have the following panel data .
>
>
>
>      | surmonth    iddom     i   sthome   kid_seq   age 
> |
>      |--------------------------------------------------|
>   1. |        1   560036     1        1         .    57 
> |
>   2. |        1   560036     2        2         .    51 
> |
>   3. |        1   560036     3        3         1    27 
> |
>   4. |        1   560036     4        3         1    16 
> |
>   5. |        1   560036     5        3         1    13 
> |
>
> "surmonth" is time; "iddom" identifies a family; "i" an 
> individuo in the family;
> "sthome" is the status in the family (1=head, 2=spouse; 
> 3=kids) and "age". kid_seq was my attempt
> to create a order from the older to the younger kid.
>
> Question:
> How to create a variavel (let`s say, dep_seq) for each 
> family ordering the kids from the older to the
> younger.
>
> sincerely,
> Ricardo
>
>
>
> Ricardo Guimaraes
> Junior Researcher
> Center for Development Research (ZEF) - University of 
> Bonn
> Walter-Flex Str., 3
> 53113 Bonn
> Germany
> *
> *   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/
>
>
> This message is intended solely for the designated 
> recipient(s). It may contain confidential or proprietary 
> information and may be subject to confidentiality 
> protections. If you are not a designated recipient, you 
> may not review, copy, or distribute this message. If you 
> receive this in error, please notify the sender by reply 
> e-mail and delete this message. 
> Arrowstreet Capital, L.P. is an Equal Opportunity 
> Employer. 
>
>
> *
> *   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/
Ricardo Guimaraes
Junior Researcher
Center for Development Research (ZEF) - University of Bonn
Walter-Flex Str., 3
53113 Bonn
Germany
*
*   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/