st: Dates - collapsing variables for multiple records

[Hannah Moore <hannahm@ichr.uwa.edu.au>]

What I was meaning in my previous email was I have data in this order:

username  ID  entrydate   exitdate  num_obs   date_obs1   date_obs2  date obs3
1                0      entry           exit                 
3              date1                 date2          date3
 1                1      entry           exit                 
3              date1                 date2          date3
 1                2      entry           exit                 
3              date1                 date2          date3
 1                3     entry           exit                 
3              date1                 date2          date3
  2                0     entry           exit                 
1               date1                   .                         .
 2                1     entry           exit                 
1               date1                   .                         .

 And I would like data in this order:
username    ID    entry     exit    num_obs
1                     0      entry     date1     3
 1                     1     date1     date2     3
 1                     2     date2    date3     3
 1                     3    date3     exit          3
 2                     0    entry       date1        1
 2                     0    date1       exit        1


  I look forward to anyone's response

  Regards
  Hannah Moore
hannahm@ichr.uwa.edu.au</x-flowed>
--
_________________________________________
Hannah Moore BSc(Hons)
Research Assistant

InterRett - IRSA Rett Phenotype Database
Australian Rett Syndrome Study

Telethon Institute for Child Health Research
PO Box 855, West Perth
AUSTRALIA, 6872
Ph: +61 (8) 9489 7781
Fax: +61 (8) 9489 7700
Mob: 0409 100 007
Email: hannahm@ichr.uwa.edu.au
:)
__________________________________________

*
*   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/