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 <[email protected]> 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 <[email protected]> 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/
