Search results
Quick start. Convert strdate1, with dates such as "Tue January 25, 2013", to a numerically encoded Stata date variable, ignoring the day of the week from the string generate numvar1 = date(strdate1, "#MDY") Convert strdate2, with dates in the 2000s such as "01-25-13", to a Stata date variable generate numvar2 = date(strdate2, "MD20Y")
6 lip 2015 · The Stata date function is smart about removing separator characters. See help datetime_translation under the section "the date function". If your dates are in v1 and in the form yyyy-mm-dd you can specify the commands: generate v2 = date(v1, "YMD") format %td v2.
Two commands, date and format, are used to convert a string date into a numeric date. Within these functions you will need to specify how the date-time information is formatted in the string. Use upper case for day, month, and year (e.g. “DMY”) but lower case if you want to specify hours, minutes or seconds (e.g. “DMYhms”).
Use a conversion function (F) Format the new variable. (B) Numerically encoded dates/times brought into Stata with import excel, import sas, or import spss will automatically be converted to Stata dates/datetimes.
Date and time variables are best read as strings. You then use one of the string-to-numeric conversion functions to convert the string to an appropriate numeric value: Format String-to-numeric conversion function %tc clock(string, mask) %tC Clock(string, mask) %td date(string, mask) %tw weekly(string, mask) %tm monthly(string, mask)
We can convert string dates to date data using Stata's date () function along with the generate command. . generate daten = date(dob, "MDY") (2 missing values generated) The first argument in the date () function is the variable that contains the date stored as a string.
10 wrz 2020 · This page lists commands you may find useful when working with date variables in STATA. Commands include extracting different date components (such as day, month, year), converting from one date frequency to another (e.g. daily to monthly date variable), and some other related commands.
