|
1.将字符型数据转换成日期型:(用stata的自带help datetime可查具体操作)
例如将字符型2010-01-05 14:04:31.890 (variant1)转换成数值型的05Jan2010:
gen double eventtime=clock(variant,"YMDhms")
gen eventdate=dofc(eventtime)
format eventdate=%td
2.提取字符型日期的数据:2010-01-05 14:04:31.890 (variant1)提取出年份
gen year=real(substr(variant1,1,4))
3.提取数值型日期的数据:05Jan2010(variant2)提取出年份
gen year=year(variant2)
其他类推:gen date=date(variant2)
gen q=quarter(variant2) |
|