Statalist


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

Re: st: add up the total stay


From   STATA Dndee <statadndee@yahoo.co.uk>
To   statalist@hsphsun2.harvard.edu
Subject   Re: st: add up the total stay
Date   Fri, 12 Oct 2007 19:04:47 +0100 (BST)

I defiantly got the answer to replace 0 with 0.5
thanks a lot. Still I need help about calculating
total stay per each visit (last column).
Regards

--- Arun Rajamohan <arajamoh@uwo.ca> wrote:

> Hi,
> 
> Oh yes having the dataset in stata helps. I have
> pasted the log here  
> that probably shows how to manipulate your data.
> 
> /*beginning of the log - I have your sample data
> stored as stay.dta  
> on my desktop
> . use ~/desktop/stay.dta
> 
> . list
> 
>       +-------------------------------+
>       |    id    datecame    datewent |
>       |-------------------------------|
>    1. | SD101   05-Nov-05   05-Nov-05 |
>    2. | SD101   05-Nov-05   11-Nov-05 |
>    3. | SD101   28-Apr-05   28-Apr-05 |
>    4. | SD105   03-Jul-06   03-Jul-06 |
>    5. | SD105   29-Mar-06   29-Mar-06 |
>       |-------------------------------|
>    6. | SD105   13-Jan-06   14-Jan-06 |
>    7. | SD105   10-Jan-06   13-Jan-06 |
>    8. | SD105   24-May-04   25-May-04 |
>    9. | SD217   22-Sep-05   22-Sep-05 |
>       +-------------------------------+
> 
> . gen datein=date(datecame, "DM20Y")
> 
> /* if you use stata9 or less "DM20Y" in the commands
> above and below  
> can be in lowercase
> 
> . gen dateout=date(datewent, "DM20Y")
> 
> /* by using format datein %td you can convert the
> resulting 5 digit  
> number (like 16745) to normal dates (like 05Nov2005)
> 
> . list
> 
>      
> +--------------------------------------------------+
>       |    id    datecame    datewent   datein  
> dateout |
>      
> |--------------------------------------------------|
>    1. | SD101   05-Nov-05   05-Nov-05    16745    
> 16745 |
>    2. | SD101   05-Nov-05   11-Nov-05    16745    
> 16751 |
>    3. | SD101   28-Apr-05   28-Apr-05    16554    
> 16554 |
>    4. | SD105   03-Jul-06   03-Jul-06    16985    
> 16985 |
>    5. | SD105   29-Mar-06   29-Mar-06    16889    
> 16889 |
>      
> |--------------------------------------------------|
>    6. | SD105   13-Jan-06   14-Jan-06    16814    
> 16815 |
>    7. | SD105   10-Jan-06   13-Jan-06    16811    
> 16814 |
>    8. | SD105   24-May-04   25-May-04    16215    
> 16216 |
>    9. | SD217   22-Sep-05   22-Sep-05    16701    
> 16701 |
>      
> +--------------------------------------------------+
> 
> . gen stay_duration=dateout-datein
> 
> . replace stay_duration=0.5 if stay_duration==0
> (5 real changes made)
> 
> . list
> 
>      
>
+-------------------------------------------------------------+
>       |    id    datecame    datewent   datein  
> dateout   stay_d~n |
>      
>
|-------------------------------------------------------------|
>    1. | SD101   05-Nov-05   05-Nov-05    16745    
> 16745         .5 |
>    2. | SD101   05-Nov-05   11-Nov-05    16745    
> 16751          6 |
>    3. | SD101   28-Apr-05   28-Apr-05    16554    
> 16554         .5 |
>    4. | SD105   03-Jul-06   03-Jul-06    16985    
> 16985         .5 |
>    5. | SD105   29-Mar-06   29-Mar-06    16889    
> 16889         .5 |
>      
>
|-------------------------------------------------------------|
>    6. | SD105   13-Jan-06   14-Jan-06    16814    
> 16815          1 |
>    7. | SD105   10-Jan-06   13-Jan-06    16811    
> 16814          3 |
>    8. | SD105   24-May-04   25-May-04    16215    
> 16216          1 |
>    9. | SD217   22-Sep-05   22-Sep-05    16701    
> 16701         .5 |
>      
>
+-------------------------------------------------------------+
> 
> .
> Hope it works for you,
> -A
> 
> On 12-Oct-07, at 5:04 AM, STATA Dndee wrote:
> 
> > Hi Arun Rajamohan
> >
> > Thanks for your reply.
> > The database is in STATA format and I had better
> to
> > should manage everything there. Total number of
> > records is so high that I would prefer to work
> with
> > STATA and not to enter them in Excel.
> > ID	DateCame	DateWent	DateWent-DateCame
> > TotalStayEachVisit
> > SD101	05-Nov-05	05-Nov-05	0.5	_
> > SD101	05-Nov-05	11-Nov-05	6	6.5
> > SD101	28-Apr-05	28-Apr-05	0.5	0.5
> > SD105	03-Jul-06	03-Jul-06	0.5	0.5
> > SD105	29-Mar-06	29-Mar-06	0.5	0.1
> > SD105	13-Jan-06	14-Jan-06	1	_
> > SD105	10-Jan-06	13-Jan-06	3	4
> > SD105	24-May-04	25-May-04	1	1
> > SD217	22-Sep-05	22-Sep-05	0.5	0.5
> >
> > What I need is calculation of TotalStayEachVisit
> > which depends on 1) ID and 2) number of visits. As
> can
> > be seen in sample some visitors came only to one
> > department and some to more than one. I need
> syntaxes
> > in STATA.
> > There is no problem with formatting for dates.
> > Regards
> >
> >
> >
> >
> > --- Arun Rajamohan <arajamoh@uwo.ca> wrote:
> >
> >> Hi,
> >>
> >> I am not sure what you mean by database.
> Hopefully
> >> it is convertible
> >> to excel or raw or csv file. I draged the sample
> >> data from your email
> >> and saved it as a raw file. Then I loaded it into
> >> stata using infix. T
> >>
> >> Your sample dataset is,
> >>
> >> SD101 05-Nov-05 05-Nov-05
> >> SD101 05-Nov-05 11-Nov-05
> >> SD101 28-Apr-05 28-Apr-05
> >> SD105 03-Jul-06 03-Jul-06
> >> SD105 29-Mar-06 29-Mar-06
> >> SD105 13-Jan-06 14-Jan-06
> >> SD105 10-Jan-06 13-Jan-06
> >> SD105 24-May-04 25-May-04
> >> SD217 22-Sep-05 22-Sep-05
> >>
> >> I  sucked it up into stata  using infix ...
> >>
> >> infix str id 1-5 str d1 7-8 str m1 10-12 y1 14-15
> >> str d2 17-18 str m2
> >> 20-22 y2 24-25 using ~/desktop/stay.raw, clear
> >>
> >> Now you will have your data in stata looking like
> >> this...
> >>
> >> id d1 m1 y1 d2 m2 y2
> >> SD101 05 Nov 05 05 Nov 05
> >> ...
> >>
> >> Then you may have to add 2000 to the year values.
> >>
> >> [I would appreciate if someone can update me on
> an
> >> alternate method.
> >> Some of my own datasets have years in the format
> 96,
> >> 97, 01, 04 etc.
> >> instead of 1996, 1997, 2001, 2004... Stata date
> >> system does not like
> >> years in 2 digit format. Am I right? I've always
> had
> >> to use a do file
> >> to sort through the years and convert them.]
> >>
> >>
> >> Then I recombine the date values using
> 
=== message truncated ===



      ___________________________________________________________
Yahoo! Answers - Got a question? Someone out there knows the answer. Try it
now.
http://uk.answers.yahoo.com/ 
*
*   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