Stata Date-type data processing _stata

1. Convert character data to date: (use Stata's Self help datetime to check for specific actions)

For example, convert a character 2010-01-05 14:04:31.890 (variant1) to a 05jan2010 of a numeric type:

Gen Double Eventtime=clock (variant, "YMDHMS")

Gen Eventdate=dofc (Eventtime)

Format EVENTDATE=%TD

2. Extract character date data: 2010-01-05 14:04:31.890 (VARIANT1) extracts the year

Gen Year=real (substr (variant1,1,4))

3. Extract data of numeric date: 05jan2010 (VARIANT2) Extract the Year

Gen Year=year (Variant2)

Other analogy: gen Date=date (Variant2)

Gen Q=quarter (Variant2)