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]
st: RE: Remove part of a string variable
From
"Philip Ryan" <[email protected]>
To
<[email protected]>
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: [email protected]
W: www.dmac.adelaide.edu.au
-----Original Message-----
From: [email protected]
[mailto:[email protected]] 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/