Align rows based on common group

Dear Statalist I have a starting dataset that looks like the following Code: * Example generated by -dataex-. To install: ssc install d...

inquire data problems: gen week

I have a large data set which contains from Oct 2002 to Feb 2007. The procedure is: From Oct 19, 2005 to Oct 31, 2005 is week 0. And after ...

Exporter_Time_FE, Importer_Time_FE and Pair_FE

Dear, Prof.Joao, Prof. Tom, Dr. Sergio Correia & Others Stata Users, I am an economics graduate student, using gravity model in my dis...

Replacing column values with values of another variable by household id

Hi everyone, I have 5 variables in my dataset namely, household id, wealth rank, and household ids of three friends for the household bein...

Calculating growth in unbalanced panel data

Can someone help me with calculating the growth percentages of a variable in panel data where I don't have the same number of years per ...

Logit Marginal Effects at means with interaction terms

Hi all, I am working on my MSc. and I have data for 201 participants who each made 457 choices (total choices ~ 91,000 choices). I am usin...

Amazon Porter’s Five Forces Analysis

Porter’s Five Forces analytical framework developed by Michael Porter (1979)[1] represents five individual forces that shape the overall ext...

Graph question for growth model "xtmixed"

Hi, I'm having a problem in making a line graph for my growth model. The outcome variable is depression level: dep_ (categorical) The ...

Seemingly Unrelated Regression with endogeneity and sample selection

Hello everyone! I wish to see the impact of income from an activity on various types of household expenditure. Thus, i wish to use seemingl...

Reassigning records with missing values to existing categories considering the existing distribution within the population

Dear Statalist, I am struggling to reassign records with a missing value on the categorical variable that assigns each record to a provinc...

Removing duplicates across several variables in panel data and keep the dup with non-missing values

Hi As the title suggests, I am trying to remove duplicate values across several variables (c30) in a panel data set (sorted by firm id and...

xtreg

hello, I have a dataset on which I want to perform an OLS. The dataset looks like this: dependent variable: percentage change of carbon e...

Problem with saving graphs with wildcard in names

Hi there! I'm having some difficulties saving and combining graphs that I have created using a foreach loop and the mrgraph command. T...

Writing GMM moment conditions for IPW

Hi all, I am trying to estimate the ATE of an IPW model by writing a GMM code. I am having trouble writing the moment conditions. gmm (e...

Stata evalautes what comes after an if statement that it's not true

Hi all, I have a do-file (Testing ceqef.do, attached) which I'm using to test an ado-file (ceqef.ado, attached). For the sake of simpl...

Never allow Stata to replace dataset

I have ingrained in my muscle memory to press "ctrl+s" every time before I run a .do file in case Stata crashes. Once in a while I...

Merging data

Hello, I am trying to merge variables from the original Demographic and Health surveys (DHS) with the IPUMS-DHS data. The unique identifie...

Blinder-Oaxaca decomposition for probit model

Hello, I have assessed online materials available for the decomposition of both linear and non-linear models but am not quite understandin...

Replacing missing values in a panel data

Dear All, hope you are all safe and in good health. Kindly I have balanced panel data with missing values for some years, I am intereste...

Spell-type data for Cox regression

Hello, dear users of the Stata program. Now I'm conducting a reserach on duration of unemployment. I want to use Cox regression to deter...

drop all zero variables

Hello, I have created dummy variables for industries, resulting in 35 dummies. However, I deleteted some observations, resulting in a coup...

Predictions with and without BLUP after melogit

I am attempting to calculate predictions after a melogit model with and without best linear unbiased predictors. In SAS I would do this as f...

Three-level mix-effect model for ordered logistic regression in Stata- meologit regression

Dear all, I am currently working with a cluster data collected from 3229 respondents in 40 counties, half of which are policy pilot sites....

Correlation Pb

Hello, I am pretty new to Stata and econometrics in general so please excuse me if my question seems stupid or is redundant. I really can...

Composite Index

Hi! I am trying to generate a composite index for 2 numerical variables. what is the best way to do it? This question may sound stupid but I...

Sample size & power for quantile regression

Hello, For a clinical trial using quantile regression to test the null hypothesis, could anyone advise on the correct method to use to det...

DID (Differences-in-difference) regression

Dear All, I’m having a problem with DID regression equation. I am using Stata 12. when I ran the regression xtreg lnDSL DID ADD EDD SRD ...

Help with merging two datasets

Dear all, I am using Stata 16, on mac. I have attached the two excel datasets that I am working with for my project. Both have a variable ...

replace with the last row in each goup

Hi STATALIST, Could you please help me to replace meacstdivol_1 with last row within each study_1? Code: study_1 meanctdivol_...

Problem with variables names inside loops

Hi all, I have a set of variables named "ratio_##########_co_###" (where # are numbers). My problem is when applying loops as:...

Amazon Ansoff Matrix

Amazon Ansoff Matrix is a marketing planning model that helps the e-commerce and cloud computing company to determine its product and market...

Fine and Gray calculate individual risks

Dear all, I would like to calculate the 10-year risk of stroke for each individual in my dataset, given a set of baseline covariates. I a...

Dummy variables in first difference regression

Hi guys, I have a potentially very stupid question to ask, but for the life of me I can not figure this out. I am estimating cartel dama...

line graphic of series from 1st occurrence Covid-19

Hello! I am using the data set provided in this study, "Oxford COVID-19 govt response tracker' here to graph the different measur...

Quick question: winsor right only & interaction

Dear members I have 2 very quick questions. First: I need to winsorize a variable further ONLY on the right side. I think this is done b...

similar observations within one variable

Hi, I would like to spot the observations that are very much alike within one string variable. Let's say for instance that I have a ...

chi2 test with probability weights

Dears I would lke to run a chi2 test but using pw rather than fw. If i use fw stata of course will not account for the proportion of my r...

If statement within foreach

Hey! So I would like to run a regression if income is within the range of (0-10727.88). Code: local vars "spending inp out...

Panel data format

Hi I would like to transform my panel data so that the years are grouped from 1989 to 2016, consecutively, with each of my country observat...

Principle Component Analysis: using weights and comparison of PCA between countries

Hello Statalist Forum Users, We wish to summarize several dichotomous variables of individual level data into an index using Principle Com...

Generating variable that contains (partly) the value of another variable

Hi everyone, I am currently working with M&A-data and I came across a challenge. I have constructed variables that show the years (2 bef...

Instrumental variables for multilevel data.

Good morning, I am writing to ask you a question about the use of instrumental variables if my data has a hierarchical structure. Specific...

nlcom: Maximum number of iterations exceeded

Hello everyone, I used nlcom to estimate marginal effects after craggit and I keep getting this error. * Maximum number of iterations ex...

combine columns and rows into one row

Hello Users, Please help with data transformation. The current data format: sub-var1 sub-var2 sub-var3 var1 2 5 7 var2 9 10 6 var3 3 ...

Standard errors for each replication(iteration) in bootstrap

Hello, I am trying to figure out if there is a way of saving all the individual standard errors one may obtain from each replication that o...

Independent t-test for differences other than 0

Dear Stata Experts, I would like to run the independent t-test for the following dataset and want to test the null hypothesis for a differ...