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/
