Bookmark and Share

Notice: On March 31, it was announced that Statalist is moving from an email list to a forum. The old list will shut down at the end of May, and its replacement, statalist.org is already up and running.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: RE: Remove part of a string variable


From   "Philip Ryan" <philip.ryan@adelaide.edu.au>
To   <statalist@hsphsun2.harvard.edu>
Subject   st: RE: Remove part of a string variable
Date   Sun, 22 Aug 2010 02:13:40 +0930

<<>>

The dofc() function which converts %tc values to %td values might help.  See
-help dates- and click on the hyperlink to -Converting date and time
values-.

* ===========
clear
set obs 1
input str20 mytime
"21aug2005 15:21:22"
gen double cx = clock(mytime, "DMYhms")
list
format cx %tc
list
* the above gives a (formatted) double precision observation on date and
time

gen long dx=dofc(cx)
list
format dx %td
list
* ==========




Phil

Philip Ryan
Professor and Director
Data Management & Analysis Centre
Discipline of Public Health
University of Adelaide
Australia 

T: +61 8  83033570
F: +61 8  82234075
E: philip.ryan@adelaide.edu.au
W: www.dmac.adelaide.edu.au


-----Original Message-----
From: owner-statalist@hsphsun2.harvard.edu
[mailto:owner-statalist@hsphsun2.harvard.edu] On Behalf Of Beatrice Crozza
Sent: Sunday, 22 August 2010 1:27 AM
To: statalist
Subject: st: Remove part of a string variable


Dear All,

when I upload my data into Stata from my Access file (using the odbc
function) the time variable that I have becomes:

30dec1899 09:30:14

And it is in a double format.

I want to remove from my variable time the part 30dec1899.

I tried with generate splitat and with split time, p("30dec1899") but they
don't work.

Could you please help me?

Thank you very much.
Bea

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

No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 8.5.441 / Virus Database: 271.1.1/3085 - Release Date: 08/21/10
06:35:00


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


© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   Site index