Skip to content

brycewang-stanford/Auto-Empirical-Research-Skills / skills/32-dylantmoore-stata-skill/plugins/stata/skills/stata

Comprehensive Stata reference for writing correct .do files, data management, econometrics, causal inference, graphics, Mata programming, and 20 community packages (reghdfe, estout, did, rdrobust, etc.). Covers syntax, options, gotchas, and idiomatic patterns. Use this skill whenever the user asks you to write, debug, or explain Stata code.

FileKindSize
SKILL.mdskill md16.4 KB
packages/asdoc.mdmarkdown8.5 KB
packages/binsreg.mdmarkdown10.1 KB
packages/coefplot.mdmarkdown10.1 KB
packages/data-manipulation.mdmarkdown10.1 KB
packages/diagnostics.mdmarkdown15.3 KB
packages/did.mdmarkdown16.0 KB
packages/estout.mdmarkdown17.7 KB
packages/event-study.mdmarkdown29.8 KB
packages/graph-schemes.mdmarkdown14.1 KB
packages/ivreg2.mdmarkdown11.1 KB
packages/nprobust.mdmarkdown12.4 KB
packages/outreg2.mdmarkdown11.2 KB
packages/package-management.mdmarkdown10.2 KB
packages/psmatch2.mdmarkdown18.6 KB
packages/rdrobust.mdmarkdown13.4 KB
packages/reghdfe.mdmarkdown10.4 KB
packages/synth.mdmarkdown23.0 KB
packages/tabout.mdmarkdown12.1 KB
packages/winsor.mdmarkdown6.7 KB
packages/xtabond2.mdmarkdown14.9 KB
references/advanced-programming.mdmarkdown10.1 KB
references/basics-getting-started.mdmarkdown5.8 KB
references/bootstrap-simulation.mdmarkdown8.4 KB
references/data-import-export.mdmarkdown7.4 KB
references/data-management.mdmarkdown11.0 KB
references/date-time-functions.mdmarkdown6.8 KB
references/descriptive-statistics.mdmarkdown6.4 KB
references/difference-in-differences.mdmarkdown20.9 KB
references/external-tools-integration.mdmarkdown20.1 KB
references/filing-issues.mdmarkdown4.7 KB
references/gmm-estimation.mdmarkdown8.8 KB
references/graphics.mdmarkdown8.6 KB
references/limited-dependent-variables.mdmarkdown8.2 KB
references/linear-regression.mdmarkdown12.4 KB
references/machine-learning.mdmarkdown12.4 KB
references/mata-data-access.mdmarkdown8.2 KB
references/mata-introduction.mdmarkdown6.4 KB
references/mata-matrix-operations.mdmarkdown6.3 KB
references/mata-programming.mdmarkdown8.4 KB
references/matching-methods.mdmarkdown19.2 KB
references/mathematical-functions.mdmarkdown7.4 KB
references/maximum-likelihood.mdmarkdown16.6 KB
references/missing-data-handling.mdmarkdown18.5 KB
references/nonparametric-methods.mdmarkdown11.7 KB
references/panel-data.mdmarkdown8.7 KB
references/programming-basics.mdmarkdown8.1 KB
references/regression-discontinuity.mdmarkdown13.4 KB
references/sample-selection.mdmarkdown17.7 KB
references/sem-factor-analysis.mdmarkdown15.2 KB
references/spatial-analysis.mdmarkdown19.4 KB
references/string-functions.mdmarkdown8.7 KB
references/survey-data-analysis.mdmarkdown13.7 KB
references/survival-analysis.mdmarkdown12.3 KB
references/tables-reporting.mdmarkdown24.2 KB
references/time-series.mdmarkdown9.9 KB
references/treatment-effects.mdmarkdown23.1 KB
references/variables-operators.mdmarkdown4.9 KB
references/workflow-best-practices.mdmarkdown25.8 KB

references/date-time-functions.md

View on GitHub
# Date and Time Functions in Stata

## How Stata Stores Dates

Dates are numeric values counting time units from January 1, 1960. This enables arithmetic and comparisons with standard operators.

## Date Formats

| Format | Description | Example Display |
|--------|-------------|-----------------|
| `%td` | Daily | 15feb2023 |
| `%tw` | Weekly | 2023w7 |
| `%tm` | Monthly | 2023m2 |
| `%tq` | Quarterly | 2023q1 |
| `%th` | Half-yearly | 2023h1 |
| `%ty` | Yearly | 2023 |
| `%tc` | Datetime (milliseconds) | 15feb2023 14:30:00 |
| `%tb` | Business dates | Varies by calendar |

## Creating Dates from Components

| Function | Purpose |
|----------|---------|
| `mdy(m,d,y)` | Month, day, year -> daily date |
| `ym(y,m)` | Year, month -> monthly date |
| `yq(y,q)` | Year, quarter -> quarterly date |
| `yw(y,w)` | Year, week -> weekly date |
| `mdyhms(m,d,y,h,m,s)` | Full datetime |

```stata
gen date_var = mdy(month, day, year)
format date_var %td

gen month_var = ym(year, month)
format month_var %tm

gen double datetime_var = mdyhms(2, 15, 2023, 14, 30, 0)
format datetime_var %tc
```

## Converting Between Date Types

| Function | Converts |
|----------|----------|
| `mofd(d)` | Daily -> monthly |
| `qofd(d)` | Daily -> quarterly |
| `wofd(d)` | Daily -> weekly |
| `yofd(d)` | Daily -> yearly |
| `dofm(m)` | Monthly -> daily (first day) |
| `dofq(q)` | Quarterly -> daily (first day) |
| `dofw(w)` | Weekly -> daily (first day) |
| `dofc(c)` | Datetime -> daily |

```stata
gen monthly = mofd(date_var)
format monthly %tm

gen daily = dofm(monthly)     // Returns first day of month
format daily %td
```

## Converting String Dates

### date() Function

| Mask Symbol | Meaning |
|-------------|---------|
| `D` | Day |
| `M` | Month (numeric, full name, or 3-letter) |
| `Y` | Year (4-digit) |
| `20Y` / `19Y` | Two-digit year (assumes 2000s / 1900s) |
| `#` | Ignore this element |

```stata
gen date1 = date("2023-02-15", "YMD")
gen date2 = date("15/02/2023", "DMY")
gen date3 = date("Feb. 15 2023", "MDY")
gen date4 = date("12/31/99", "MD19Y")   // Assumes 1999
format date1 %td
```

The function handles various delimiters (`-`, `/`, `.`, spaces) and month formats (numeric, abbreviated, full name).

### clock() for Datetime
```stata
gen double dt = clock("2023-02-15 14:30:00", "YMDhms")
format dt %tc
```

### Other String-to-Date Functions
```stata
monthly("2023-02", "YM")
quarterly("2023-Q1", "YQ")
weekly("2023-W7", "YW")
```

## Extracting Date Components

### From Daily Dates
| Function | Returns | Range |
|----------|---------|-------|
| `year(d)` | Year | 1000-9999 |
| `month(d)` | Month | 1-12 |
| `day(d)` | Day of month | 1-31 |
| `quarter(d)` | Quarter | 1-4 |
| `dow(d)` | Day of week | 0 (Sun) - 6 (Sat) |
| `doy(d)` | Day of year | 1-366 |
| `week(d)` | Week of year | 1-52 |

### From Datetime
```stata
gen dt_year = year(dofc(dt))
gen hour_val = hh(dt)
gen minute_val = mm(dt)
gen second_val = ss(dt)
```

### Current Date/Time
```stata
gen current_date = today()
format current_date %td

gen double current_datetime = now()
format current_datetime %tc
```

### Month/Leap Year Functions
```stata
daysinmonth(mdy(2, 15, 2023))           // 28
firstdayofmonth(mdy(2, 15, 2023))       // Feb 1, 2023
lastdayofmonth(mdy(2, 15, 2023))        // Feb 28, 2023
isleapyear(mdy(2, 15, 2024))            // 1

// Stata 17+
age(birthdate, today())                  // Age in complete years
age_frac(birthdate, today())             // Precise fractional age
```

## Date Arithmetic

Dates are numbers, so arithmetic works directly.

```stata
gen days_elapsed = date2 - date1               // Days between dates
gen end_date = start_date + 30                 // Add 30 days
gen last_week = today() - 7

// Datetime: subtraction yields milliseconds
gen duration_hours = (end_time - start_time) / (60 * 60 * 1000)

// Add 2 hours to datetime
gen double new_time = original_time + (2 * 60 * 60 * 1000)

// Stata 17+
gen years_diff = datediff(date1, date2, "year")
gen months_diff = datediff(date1, date2, "month")
gen exact_months = datediff_frac(date1, date2, "month")
```

### Using Dates in Conditions
```stata
keep if date_var > mdy(3, 15, 2020)
gen pandemic = (date_var >= mdy(3, 15, 2020) & date_var <= mdy(12, 31, 2021))
keep if year(date_var) == 2023
```

## Time-Series Setup

### tsset Command
```stata
gen quarterly = yq(year, quarter)
format quarterly %tq
tsset quarterly

// Panel time series
tsset company_id date_var
```

### Time-Series Operators (require tsset)
| Operator | Meaning |
|----------|---------|
| `L.` / `L2.` | Lag / 2-period lag |
| `F.` / `F3.` | Lead / 3-period lead |
| `D.` | First difference |

```stata
gen price_lag1 = L.price
gen price_change = D.price
gen price_lead = F.price
```

### Subsetting Time Periods
```stata
regress unemp interest if tin(1957q1, 1999q4)     // Inclusive
regress unemp interest if twithin(2000q1, 2005q1)  // Exclusive
```

### Converting Daily to Other Frequencies
```stata
gen monthly = mofd(date_var)
format monthly %tm
collapse (mean) price volume, by(monthly)
tsset monthly
```

## Business Dates

Business calendars skip non-trading days (weekends, holidays).

```stata
// Create calendar from data gaps
bcal create sp500, from(date)
format trading_date %tbsp500
tsset trading_date

// L. and F. now reference trading days, not calendar days
gen prev_price = L.price    // Previous TRADING day
gen price_5days = L5.price  // 5 TRADING days ago
```

## Display Format Customization

```stata
format date_var %tdMon_dd,_CCYY    // Feb 15, 2023
format date_var %tdCCYY-NN-DD      // 2023-02-15
format date_var %tdDD.Month.CCYY   // 15.February.2023
```

| Code | Meaning |
|------|---------|
| `DD` | 2-digit day |
| `NN` | 2-digit month |
| `CCYY` | 4-digit year |
| `Month` / `Mon` | Full / 3-letter month |
| `hh` / `HH` | 24-hour / 12-hour |
| `MM` | Minute |
| `SS` | Second |
| `am` | AM/PM indicator |
| `_` | Single space |

## Common Recipes

### Age Calculation
```stata
gen age_years = floor((today() - birthdate) / 365.25)
// Or Stata 17+:
gen age_exact = age(birthdate, today())
```

### Fiscal Years (April start)
```stata
gen fiscal_year = year(date_var)
replace fiscal_year = fiscal_year + 1 if month(date_var) >= 4
```

### First/Last Day of Quarter
```stata
gen quarter_start = dofq(qofd(date_var))
gen quarter_end = dofq(qofd(date_var) + 1) - 1
```

### Excel Date Conversion
```stata
// Excel counts from Jan 1, 1900; Stata from Jan 1, 1960
// Difference: 21,916 days
gen stata_date = excel_date - 21916
format stata_date %td
```
**Note:** Excel incorrectly treats 1900 as a leap year; dates before March 1, 1900 may need adjustment.

### Fill Missing Dates / Identify Gaps
```stata
bysort id (date_var): replace date_var = date_var[_n-1] if missing(date_var)
sort date_var
gen date_gap = date_var - date_var[_n-1] if _n > 1
```

### Date Validation
```stata
gen valid_date = !missing(mdy(month, day, year))
gen in_range = (date_var >= mdy(1, 1, 2000) & date_var <= mdy(12, 31, 2023))
```
finishing-a-development-branchobra/superpowersUse when implementation is complete, all tests pass, and you need to decide how to integrate the workStars: 323kUpdated Claude CodeCodexVerifiedInstall
systematic-debuggingobra/superpowersUse when encountering any bug, test failure, or unexpected behavior, before proposing fixesStars: 323kUpdated Claude CodeCodexVerifiedInstall
test-driven-developmentobra/superpowersUse when implementing any feature or bugfix, before writing implementation codeStars: 323kUpdated Claude CodeCodexVerifiedInstall
skill-creatoranthropics/skillsCreate new skills, modify and improve existing skills, and measure skill performance. Use when users want to create a skill from scratch, edit, or optimize an existing skill, run evals to test a skill, benchmark skill performance with variance analysis, or optimize a skill's description for better triggering accuracy.Stars: 198kUpdated Claude CodeCodexVerifiedInstall