Notice: On April 23, 2014, Statalist moved from an email list to a forum, based at statalist.org.
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: st: dates
From
Nick Cox <[email protected]>
To
[email protected]
Subject
Re: st: dates
Date
Fri, 7 Oct 2011 19:44:07 +0100
Intelligent support for run-together dates was added in Stata 10. (For
Stata 8 and 9. -todate- (SSC) is a work-around.)
If such dates are numeric, then a conversion can be used like
. di date(string(20080105, "%12.0f"), "YMD")
17536
Your splitting, back transforming and recombining are then all
unnecessary. The format argument is needed because otherwise the
-string()- conversion will change the large integer to a power of 10.
. di string(20080105)
2.01e+07
Nick
On Fri, Oct 7, 2011 at 7:07 PM, Pedro Nakashima
<[email protected]> wrote:
> For the days that are in the format like 20080105, I usually transform
> them to string, break it with substr() (day, month, year), transform
> back to numeric, and then build the date with the function td=mdy().
>
> I don't know a faster way to do that..
>
> 2011/10/6 Michael Eisenberg <[email protected]>:
>> Colleagues,
>>
>> I have a list of visit dates for patients. Unfortunately, the format
>> is not constant.
>>
>> Most are listed with the year, month, day such as 20080105 for Jan 5,
>> 2008 but some are listed only with the year and month 200801 for Jan
>> 2008.
>>
>> I attempted to convert them into stata dates with the commands below
>> without success.
>>
>> gen ndate = date(dx_date, "YMD")
>> or
>> gen ndate = date(dx_date, "CCYYNNDD")
>>
>> Can stata handle such inconsistent data?
*
* For searches and help try:
* http://www.stata.com/help.cgi?search
* http://www.stata.com/support/statalist/faq
* http://www.ats.ucla.edu/stat/stata/