Statalist The Stata Listserver


[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]

Re: st: RE: ordering records


From   "Ricardo Guimaraes" <ricardo.guimaraes@uni-bonn.de>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: RE: ordering records
Date   Tue, 06 Jun 2006 18:28:49 +0200

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/



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