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/
