Standard errors and 95% Confidence Intervals for Proportions - Differences between different Stata versions

Dear community: I am having doubts about how Stata calculates standard errors and 95% confidence intervals for proportions, especially bec...

Identifying common observations between two groups

Dear Statalist, I have a dataset with firms and owners. This is a minimum working example: Code: * Example generated by -dataex-. To in...

Commands for sleep and retry if a file being accessed at the moment

I have multiple instances of Stata accessing the same excel file to record some information. Every once in a while they try to access the ex...

sqom subcost matrix problem?

Hi, I am trying to run the latest version of sqom on Stata16 using subcost(meanprobdistance) and am getting an error. My command is: sq...

Histogram with lpattern(non-solid line) adds a weird slant line

Hi all, I have just found that, when I specify 'lpattern(dash)' or 'dot' or, anything other than the solid line for 'two...

Restructuring data for survival analysis

Hello everyone, Please I need help here on re-structuring my data (Nigeria Demographic and Health Survey) for survival analysis. I'm...

Happy birthday to statalist.org

Statalist re-invented itself as a forum on March 31, 2014. That doesn't sound that long ago, but in the last 7 years, there have been mo...

Combinations of binary variables

Hello, I have a dataset with 10 variables and 5 binary variables (A, B, C,D,E). I'm trying to get all possible combinations of 2,3, 4 ...

convert hexadecimal to binary

I have variables whose values come as hexadecimal strings 32 characters long as a rusult of an md5 hash function to an original string. I ne...

HGLM - Model 2 level variables not siginificant but postestimation plot shows variation

Good day, I am using a two level HGLM model model 1 - Level 1 variables have significant effect on outcome Model 2 - Level 2 variables d...

Robustness checks

Dear statalist, I am running a bootstrap on an OLS model with the dependent variable being log(maximal grip strength) on a set of independ...

Comparing coefficients while keeping difference between other coefficients constant in mixed model

Dear Statalist users, I would like to compare whether the slope is statistically different between two groups while pretending that the in...

How to calculate year in month with conditions

Dear all, Year of birth and month of birth of each individual in a given dataset, now I want to generate two variables as follows: 1) Yea...

Interpreting Sargan-Hansen Tests

Hi all, I am running diff GMM using Sebastian's xtdpdgmm command. However, I am not sure how to interpret the 2 different Sargan-Hanse...

How to generate a variable which takes for every combination another value?

Dear all I have a question. I have a dataset with lots of different variables and want to generate a new variable which takes for every pos...

sort row with string variables?

Dear All, Is it possible to sort "string" variable? Suppose that the data set is Code: * Example generated by -dataex-. To insta...

outreg2 keep option does not work

Hello, I am in desperate need for some help for my thesis regarding Stata. I would like to make use of the outreg2 command. However, whe...

Difference in Consecutive Values by Group Labels

Dear Statalisters, I need to generate another variable called 'difference' which contains the difference between 'consecutive...

IV ordered probit using CMP (syntax help)

Hi There, I am estimating the causal effect of maternal education on child health. My dependent variable ==> Breastfeeding duration. It...

Reshape data in order to calculate gini coefficient panel data using income groups

Dear Statalist, I'm trying to calculate the Gini of counties using the the population of 20+ income groups and the median income of sa...

Series 0 not found using grc1leg2

Dear all, I am using Stata 14 on Windows 10. The following code is supposed to create a combined graph of several scatter plots for two vari...

Drop if Strmatch with multiple conditions

Hello everyone, I'm new to STATA and i have the following problem: I want to drop all observations, that don't contain the words ...

Merger Simulation Nested Logit Model (Björnerstedt & Verboven, 2013)

Dear forum, I follow the paper written by Björnerstedt and Verboven (2013) and Berry (1994) to simulate a merger: In Berry (1994) they u...

ITSA Error on Monthly Time Series Data with a Gap Due to Zero Count

Hi, I am currently looking at datasets from several hospitals to assess the impact of COVID-19 pandemic on the surgical volume changes throu...

Combined plots

Hi I recently came across a graph where instead of making bar graphs the authors/researchers had combined three plots (namely scatter, viol...

Graphing variables with extreme values

Hi Statalist. I want to graph a number of financial variables, such as total household assets, and compare the values between a few dichot...

Extract substring between nth and (n+1)th commas in a variable

How can I extract a substring between the nth and (n+1)th commas in a variable? For example, consider ID = 3 and beta = "eight,nine,t...

How to adjust (select or handpick) correlation matrix column(s) output to be esttab after estpost correlation table?

Dear Statalisters, I would like to find out whether it is possible to select the specific column(s) to be produced in the correlation matrix...

MATCHIT- Stata for data consolidation and cleaning using fuzzy string comparisons

Hello, I came across your matchit command in Stata for data consolidation and cleaning using fuzzy string comparisons. I would like to us...

need help: panel data analysis

Hello, I have a panel data sample consisting of obervations of several years. For each year I have some duplicates which I won`t drop sinc...

probleme to perform ado function

Dears, i am a new one on this forum and on stata, thank you for your help my question is : I want to run an ado program according to the...

Can i pick the Model with lower AIC but higher BIC?

Good day Everyone, I was comparing two models Model2 has a lower AIC but a higher BIC. can i pick model 2 as the better model since its ...

probleme to perform ado function

Dears, i am a new one on this forum and on stata, thank you for your help my question is : I want to run an ado program according to the...

Controlling for year when appending two datasets

Hello, One newbie question but I'm stuck on this basic task. I'm pooling two datasets from two different years and have successful...

Quantile regression (QR) for panel data

Dear all, i hope you are doing good i'm trying to work on a non linear relationship. does quantile regression an appropriate model...

Reverse Causality and Panel Data

Hi all, I hope all is well. Please, I am studying if some of the variables affect firm instrument issuance. Assume that I have these varia...

Table1_mc stata 16 issue

Hello, I am trying to create a table 1 in stata 16. I am using the following code: table1_mc, by(race_ethnicity) vars(age contn %4.0f \...

Analysis of Demographic Factors Across Syllabi

Hi all! I'm very new to Stata so apologies in advance if my question isn't very well formed. I am performing an analysis of gender...

why I need to run the command keep twice to delete some observations?

Code: ------------------------------------------------------------------------------------------------------------------------------------...

Panel regression model / Multiple regression model?

Hi everyone, I have a dataset available which links the the Covid-19 situation to the change in port activity (expressed in difference of ...

Regressing a variable recorded in 2018 on a variable of 2011

Hello everybody, I'm a beginner of Stata and I'm already facing the first issues. I have a panel data where my dependent variable (...

Omitted interaction terms in the fixed effect due to collinearity

Hi all, I have a question when I am running a fixed effect regression which is used to investigate how the dependent variable will be when...

Replace odd commas by spaces in a variable

Hi, Thanks in advance for your help. Maybe, what I am going to ask is an easy question for many of you but I have been unable to find a sol...

Importing an Imputed File

Hi everyone, I created an Imputed version of my data on a PC machine using Stata/SE. I've now opened the data set using Stata/IC on a ...

Mark latest observation with unbalanced paneldata

I want to mark the latest observation in an unbalanced dataset with panel data Timevaribel: t (varies som 0 to 17) person id: id The ...

Need help with sampling process

Hello, I am working with a dataset with merged data from 2 survey rounds (2005 & 20011). The first column/variable 'id' is t...

Cartesian product of Columns

Dear Statalisters, I have 2 sets Set_1= {HH, HT, TT, TH} and Set_2 = {1, 2, 3, 4}. These are the initial column values and names. I want ...

GMM for time series

Hello Statalist, 1.I am using time series data. my main equation is pb t = a 0 +a 1 pb t-1 +a 2 pd t-1 +og t +e but there is a problem o...

Stationarity, Markov switching

Hi everyone, I was trying to model times series with markov switching regimes. Preliminarily, do I need to have my time series to be station...

Out of sample estimation following xtdpdgmm

Stata throws a 301 error (last estimates not found) whenever I try to use estimates from a dynamic model (using xtdpdgmm) to predict out of ...

Identifying missing Data & Interpolation of Panel Data

Hello, I've created a dataset of 30 countries over 30 years for 29 different variables. For some of these countries, the 30-year time ...

Shifting observations across rows

Hello, I am fairly new to Stata and am having trouble even starting on this problem. I am working with the National Longitudinal Survey of ...

Reading image properties such as GPS and date taken

Hi everyone, I was wondering if there is a way to read photo/ image properties such as date taken, data modified and GPS coordinates. I have...

Alternatives to Propensity Score Matching (PSM)

Hello everyone, I have a large dataset of forest pixels with different control variables such as altitude, slope, distance to nearest rive...

FE constant vs RE constant

Hi, I am estimating a model by FE and the constant I get is not close to the mean of my only explanatory variable, but when I run the same...

Categorical x Categorical interaction

Hi all, I am hoping someone can clear something up for me. I want to run a poisson regression model - with a continuous dependent variab...

xttab

Hi, I am busy with creating a word doc with my panel data descriptive statistics. I am using the following code, which works. asdoc xttab...

Shaping graphs using grc1leg

Hi all, I'm making a set of different scatters using the following code: Code: foreach x in physical_strength conceptualisation s...

create dataset based on all possible pairs of identifiers within each group in Stata

Hi, I have a dataset that looks like this: Code: * Example generated by -dataex-. To install: ssc install dataex clear input str7 coun...