-date- means daily date (only).
-time- means time of day (only).
-time- has values of the form "hh:mm:ss", say "01:23:45", "12:34:56",
"21:34:56".
If so, -time- will sort fine in its string form. And -sort id date time-
will do what you want.
If not, you need some one to make a smarter guess or to give more
information.
To get -time- into numeric form, there are various ways. For one, see
the help for -split-.
Nick
[email protected]
Hugh Colaco
I have 3 variables; id, date, time.
"date" and "time" both have a storage type of str8 and are both in %9s
display format. I need to sort on "id", "date" and "time" in that
sequence.
I am able to get "date" as float %td, but I am having a problem with
"time". I got "time" as a double %tc, but it obviously comes out with
the date "01jan1960" plus the time. I have over 2 million
observations. I am using Stata 10.
*
* 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/
