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 18:57:13 +0100 (BST)

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 it 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 2 questions
1) In STATA how can I manage to get 
totalstayeeachvisit regarding that it depends on id
and any continues stay refer to columns DateCame
DateWent.  What is the command to manage getting 2
outputs for SD101 and not 3?
2) How can I tell STATA replace 0 with 0.5 if
difference between Came and Went is 0?

I donít know where that 0.1 came from, the data are
here again.
Your help is very much appreciated.

id	DateCame	DateWent	datecamedatewent
totalstayeachvisit
SD101	05nov2005	05nov2005	.5	_
SD101	05nov2005	11nov2005	6	6.5
SD101	28apr2005	28apr2005	.5	0.5
SD105	03jul2006	03jul2006	.5	0.5
SD105	29mar2006	29mar2006	.5	0.5
SD105	13jan2006	14jan2006	1	-
SD105	10jan2006	13jan2006	3	4
SD105	24may2004	25may2004	1	1
SD217	22sep2005	22sep2005	.5	0.5




--- Nick Cox <n.j.cox@durham.ac.uk> 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 
> n.j.cox@durham.ac.uk 
> 
> 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/
> 



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



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index