Reshape Problem

Dear Statalist, I downloaded data from the UN National Accounts. Unfortunately the layout of the data is not in the format I would like it...

Need help creating tex table by two variables

I would like to create a table that includes the mean and standard deviation of a group of variables by the study region and year. I can cre...

Replace value in one row based on another variables

ID year open near_2 near_3 competition exposed 1 2005 1 1 1 0 0 1 2006 1 1 1 0 1 1 2007 1 1 1 0 1 2 ...

When "append" is more suitable than "merge" for datasets?

Hello everyone, I have a question. I have to append/merge a dataset with another one. My question is the following : when have I to use ...

How to create a progressive variable (CEO tenure)

Hi everyone, I want to create CEO’s tenure based on “Date become CEO” and “Date left as CEO”. My problem is how to create a progressive te...

MI imputed chained interaction terms

Hello guys, I am using MICE approach. I have some continuous variables (e.g., income) and categorical variables (e.g., race as dichotomous) ...

Question: How do I test the difference between two diff-in-diff coefficients?

Hi Statalist, I want to test whether a normal MA event will have different effect on the outcome from a PEVC event. The regression is out...