I need expression and commands to tell STATA;
If �id� is the same as previous observation and if
�in� for this observation equals to �out� in previous
one, then add � stay� to previous one to calculate
StayEachVisit. And consider that number of
observations for total stay in each visit is not
defined (in the example it is 1-2 but it can be one
1-7 or more).
Many thanks
--- STATA Dndee <[email protected]> wrote:
> Thanks for replies.
> I am new to STATA and this discussion board and
> apparently I couldn�t describe my question. It is
> not
> about destring the variables to date format. I can
> manage that with this command for example for
> DateA::
> gen NewVar = date( DateA, "dm20y")
> format NewVar %td
> My problem is to calculate 2 variables :
> datecamedatewent and totalstayeachvisit in STATA
> for
> the example it�s been done manually.
> So there is 1 questions
> 1) In STATA how can I manage to get total staye
> each
> visit regarding that it depends on id and any
> continues staying refer to columns In and Out
> variables. What is the command to manage to get 2
> outputs for SD101 and not 3?
>
> I don�t know where that 0.1 came from, the data are
> here again.
> Your help is very much appreciated.
>
> +-------------------------------------------------+
> id In Out Stay StayEa~t
> -------------------------------------------------
> 1. SD101 05nov2005 05nov2005 .5 _
> 2. SD101 05nov2005 11nov2005 6 6.5
> 3. SD101 28apr2005 28apr2005 .5 0.5
> 4. SD105 03jul2006 03jul2006 .5 0.5
> 5. SD105 29mar2006 29mar2006 .5 0.5
> -------------------------------------------------
> 6. SD105 13jan2006 14jan2006 1 -
> 7. SD105 10jan2006 13jan2006 3 4
> 8. SD105 24may2004 25may2004 1 1
> 9. SD217 22sep2005 22sep2005 .5 0.5
> +-------------------------------------------------+
> Many thanks
>
>
>
> --- Nick Cox <[email protected]> wrote:
>
> > I think Arun later answered the question about
> > two-digit years in dates himself (or herself).
> >
> > Just one tip: If I see sample data like
> >
> > 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
> >
> > in a Statalist posting, I wouldn't go the -infix-
> > route. I copy and paste that into an empty
> > Stata data editor window. Often the results
> > end up as a single string variable, but that
> > is often fixable with a single
> >
> > split var1, destring
> >
> > followed by a little cleaning up. In this case
> > the dates remain together within single variables.
> >
> > Nick
> > [email protected]
> >
> > Arun Rajamohan
> >
> > > 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.]
> >
> > *
> > * 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/
> >
>
>
>
>
>
___________________________________________________________
> 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/
>
___________________________________________________________
Want ideas for reducing your carbon footprint? Visit Yahoo! For Good http://uk.promotions.yahoo.com/forgood/environment.html
*
* 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/
