Ricardo
try this (untested)
sort idd i t
by idd i: gen vn=_n if v1!=. & v2!=.
by idd i: egen ob=sum(v1!=. & v2!=.)
Gruesse nach Bonn
Dirk NachbarAssistant Economist
Pensim2
Department for Work and Pensions
Level 4, The Adelphi
1-11 John Adam St
WC2N 6HT London
020 796 28531
Dear Members,I have the following panel data .
????????????? how to
calculate
| t idd i v1 v2 | vn ob |
|---------------------------------------------------|
1. | 1 560036 1 3 . | 1 4|
2. | 1 560036 2 2 . | 1 4|
3. | 1 560036 3 3 1 | 1 4|
4. | 1 560036 4 6 1 | 1 4|
5. | 1 560036 5 3 1 | 1 4|
|---------------------------------------------------|
6. | 2 560036 1 1 . | 2 4|
7. | 2 560036 2 2 6 | 2 4|
3. | 2 560036 3 3 1 | 2 4|
8. | 2 560036 4 3 7 | 2 4|
9. | 2 560036 5 2 1 | 2 4|
|---------------------------------------------------|
10.| 3 560036 1 . . | . .|
11.| 3 560036 2 . . | . .|
12.| 3 560036 3 . . | . .|
13.| 3 560036 4 . . | . .|
14.| 3 560036 5 . . | . .|
|---------------------------------------------------|
15.| 4 560036 1 1 . | 3 4| 16.| 4 560036 2 2 . | 3 4|
17.| 4 560036 3 7 1 | 3 4|
18.| 4 560036 4 3 1 | 3 4|
19.| 4 560036 5 5 1 | 3 4|
|---------------------------------------------------|
20.| 5 560036 1 1 . | 4 4|
21.| 5 560036 2 2 . | 4 4|
22.| 5 560036 3 8 1 | 4 4|
23.| 5 560036 4 3 1 | 4 4|
24.| 5 560036 5 3 1 | 4 4|
|---------------------------------------------------|
"t" is time (let's say, by month); "idd" identifies a family; "i" an individual in the family;
"V1", "v2" are variables about characteristics of
individuals. The panel is formulated in
a rotating basis: families are observed no more than 4
times (months) in a year. In my table
they would be the variable "ob". However, the observation
are not taken in a row. They "jump"
some months (like month 3 in my example), where the
members of the family are not observed. I do not have the
variables "Vn" and "ob".
Question:
How to create two variables, 1) "vn": 2) "ob" ) for each individual saying:
1) "vn" : a sequence (_n) of the months that the individuals are observed. For instance, in the
time "t" the individuals of the family were not observed.
2) "ob" : the total number (_N) of times that the
individual were observed. Note that in some
variables the values are (.), but the individual was
observed.
sincerely,
ricardo*
* 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/
PLEASE NOTE: THE ABOVE MESSAGE WAS RECEIVED FROM THE INTERNET.On entering the GSI, this email was scanned for viruses by the Government Secure Intranet (GSi) virus scanning service supplied exclusively by Cable & Wireless in partnership with MessageLabs.
In case of problems, please call your organisational IT Helpdesk.
The MessageLabs Anti Virus Service is the first managed service to achieve the CSIA Claims Tested Mark (CCTM Certificate Number 2006/04/0007), the UK Government quality mark initiative for information security products and services. For more information about this please visit www.cctmark.gov.uk
**********************************************************************
This document is strictly confidential and is intended only for use by the addressee.
If you are not the intended recipient, any disclosure, copying, distribution or other
action taken in reliance of the information contained in this e-mail is strictly prohibited.
Any views expressed by the sender of this message are not necessarily those of the Department
for Work and Pensions.
If you have received this transmission in error, please use the reply function to tell us
and then permanently delete what you have received.
Please note: Incoming and outgoing e-mail messages are routinely monitored for compliance
with our policy on the use of electronic communications.
**********************************************************************
The original of this email was scanned for viruses by Government Secure Intranet (GSi) virus scanning service supplied exclusively by Cable & Wireless in partnership with MessageLabs.
On leaving the GSI this email was certified virus free.
The MessageLabs Anti Virus Service is the first managed service to achieve the CSIA Claims Tested Mark (CCTM Certificate Number 2006/04/0007), the UK Government quality mark initiative for information security products and services. For more information about this please visit www.cctmark.gov.uk
