Re: st: Extracting Time from Excel Sheet

[Phil Schumm <pschumm@uchicago.edu>]

On Feb 23, 2009, at 1:37 PM, jasonm@ucla.edu wrote:
> I want to extract the time from v1
> Sep/09/1998 08:42:00 PM
> where v1 is
> str24  %24s
> However, all I can extract is
> 08:42:00 PM
> when using substr.
> I would like to extract the hours (eg 8) and PM or AM.
> Any suggestions?


Assuming that v1 contains only datetime values with the same mask:


. gen foo = string(clock(v1, "MDYhms"), "%tchh_AM")

. cl

                          v1        foo
  1. Sep/09/1998 08:42:00 PM       8 PM


-- Phil

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