Statalist


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

RE: st: add up the total stay


From   "Nick Cox" <n.j.cox@durham.ac.uk>
To   <statalist@hsphsun2.harvard.edu>
Subject   RE: st: add up the total stay
Date   Fri, 12 Oct 2007 16:10:14 +0100

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/



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