I have a dataset of individuals. Each individual is observed across different years and countries. I have two independent variables x2002 and x2010 (see Dataex example: Before). These contain the values of a variable X for each year for a specific country. For example, all individuals observed in 2002 in France have a value of… Read More Create new variable x by selecting the value of a cell in a row conditional on the variable name containing the value of a variable z

I have a cross-sectional dataset with the data example below, where the variable (id) refers to each individual in the df and rows represent the different number of Reddit posts written by each username, which vary across individuals. My goal is to use OLS regression to predict average sentiment, based on individual-level covariates which are… Read More Using cross-sectional data for OLS/logit models

I am running an event study in Stata and I would like to interact each of my dates with a dummy variable. The dates are divided into semesterd, i.e., half years, %th format. Here below what I tried: foreach yh = yh(1933h1)(1)yh(1958h2){ gen d_`yh’=dummy*(sdate==`yh’) label var d_`yh’ "`yh’" } Do you have any idea of… Read More Loop over half-yearly dates

I have two datasets: Panel – years from 2010 to 2020 Ranges for each firm (one or many) when they took a loan – also the range indicates the loan duration First can look like this (each company has all the year-observation records): id year 1 2010 1 … 1 2020 2 2010 2 …… Read More Working with date ranges – creating a flag in panel

I would like to add 24 hours or 1 day to my timedate variable in Stata. read_date Desired_date 2009-01-01 14:00:00 2009-01-02 14:00:00 I formatted my read_date with format read_date %tcCCYY-NN-DD_HH:MM:SS which worked without errors. I have been trying to add days by adding 86400 seconds as: replace Desired_date = Desired_date+86400 It executes without errors but… Read More Add days to datetime

I’ve spent hours reading Stata help file (17SE) but I’m unable to understand why the syntax in this syntax command is wrong: syntax, n(integer) interact(real) infage(integer min=45 max=75) supage(integer min=45 max=75) For sure the part until interact(real) works, but what’s wrong with the following part? >Solution : I suspect that you want something more like… Read More syntax command syntax issue