It is not clear (to me) what you want or how you want the observations
split.
If you mean that since the time span for observation 1 is 4 years there
should be 4 observations, you could use -expand- Something like this:
gen entry = date(date1, "md19y")
format entry %d
gen exit = date(date2, "md19y")
format exit %d
gen y1 = year(entry)
gen y2 = year(exit)
gen diff = y2 - y1
expand diff
sort entry
l
Hope this helps,
Scott
> -----Original Message-----
> From: [email protected] [mailto:owner-
> [email protected]] On Behalf Of [email protected]
> Sent: Monday, January 31, 2005 11:28 AM
> To: [email protected]
> Subject: st: Query
>
> I am working with a multi-record-per-case observational data set and have
> a
> problem. Specifically, it turns out that within cases, duration times for
> single records can span more than one year. Accordingly time-varying
> explanatory variables that carry different information by year are not
> accurate for that record. For example,
> ID Entry Exit pwom
> 4 01/14/82 07/08/86 50.2
> 4 07/08/86 12/31/86 52.6
> 4 01/01/87 04/30/87 57.5
> As you see, pwom varies for records 2 and 3 but not so for record 1, which
> covers a period of nearly 4 yrs but nonetheless carries a constant value
> for pwom. I cannot not locate a procedure in Stata for splitting record 1.
> Any suggestions would be greatly appreciated. Thanks.
>
>
> *
> * 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/
*
* 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/
