Advertisements Say I have these data: clear all input id var1 var2 var3 key 1 23 45 8 2 2 11 7 99 3 3 29 22 1 1 4 5 61 5 2 end How can I create another variable called want that uses the key variable as a key to identify which variable… Read More Create variable that uses value of another variable to determine which other variable from which to take value
Advertisements 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… 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
Advertisements 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… Read More Using cross-sectional data for OLS/logit models
Advertisements 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… Read More Loop over half-yearly dates
Advertisements 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
Advertisements 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… Read More Add days to datetime
Advertisements 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… Read More syntax command syntax issue