[Date Prev][Date Next][Thread Prev][Thread Next][Date index][Thread index]
Re: st: Formatting of dates
I. Mosca wrote:
we have an entry that looks like the following:
It is a string variable str19 %19s.
We'd like to transform it into a numerical/date format, but the
information we want to keep is only the year.
How can we do that?
Looking at your date format it seems that the year precedes the first
blank in the string. I create two observations, identify the position of
the first blank character with strpos(), and use that in the substr()
input str19 datetime
gen x = strpos(datetime," ")
gen year = substr(datetime, x-4, 4)
In Stata 8 it is not strpos(), but index():
gen x = index(datetime," ")
Hope this helps
Institut for Folkesundhed, Afdeling for Epidemiologi
(Institute of Public Health, Department of Epidemiology)
Vennelyst Boulevard 6
DK-8000 Aarhus C, Denmark
Phone: +45 8942 6090
Home: +45 8693 7796
* For searches and help try: