Re: st: RE: summarizing dates

[Jeph Herrin <junk@spandrel.net>]

Learn something every day. I tried -sum, f(%d)-
but when that failed didn't check the documentation.

thanks,
Jeph


Steichen, Thomas J. wrote:
> Try the format option of summarise:
>
>   . sum admit_date if missing(disch_date), format
>
> Tom
>
> -----------------------------------
> Thomas J. Steichen
> steicht@rjrt.com
> -----------------------------------
>  
> -----Original Message-----
> From: owner-statalist@hsphsun2.harvard.edu [mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Jeph Herrin
> Sent: Friday, August 17, 2007 11:13 AM
> To: statalist@hsphsun2.harvard.edu
> Subject: st: summarizing dates
>
>
> I'm working with multiple observations per subject,
> each with multiple date fields (eg, admission to hospital,
> discharge from hospital, readmission, death). In trying
> to work with them, I would like to be able to summarize
> them. Eg,
>
>   .sum admit_date if missing(disch_date)
>
> But of course, this produces Stata elapsed date values,
> which are only barely meaningful without formatting.
> What I'd like to do is something like the above but get
> mean, median etc displayed as formatted dates. Is there
> a utility out there that can help? I know I can convert
> them all to Julian dates, but those will be barely more
> intelligible, and YYYYMMDD format will give distorted
> summary values.
>
> thanks,
> Jeph
> *
> *   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/
>
> -----------------------------------------
> CONFIDENTIALITY NOTE: This e-mail message, including any
> attachment(s), contains information that may be confidential,
> protected by the attorney-client or other legal privileges, and/or
> proprietary non-public information. If you are not an intended
> recipient of this message or an authorized assistant to an intended
> recipient, please notify the sender by replying to this message and
> then delete it from your system. Use, dissemination, distribution,
> or reproduction of this message and/or any of its attachments (if
> any) by unintended recipients is not authorized and may be
> unlawful.   
> *
> *   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/
*
*   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/