Separating a character and a number part of a variable

I have a variable consisting of characters and numbers in a string format. How can I separate the character part of a variable and the numbe...

specifying stored coefficients in test

I am running two multilevel models and storing the coefficients. I then want to test of the product of two coefficients, one from each model...

How to use If condition to restrict t test on only two groups with a categorical var that has 3 groups

Hi Family, I have 1 categorical variable that has 3 grps( blue,yellow, green), I wanted check if the variance between only these two groups...

Make a list table in Stata

Dear Stata users, Thank you in advance. I want to make a table that has all items listed in cells that are grouped by a categorical variab...

OLS vs. Ordered Logistic Regression

Hello, I have five employee-level variables as below, and I was wondering if I could use the OLS with fixed effect or ordered logistic reg...

How to realize data deformation operation

How to perform the following data operations as follows: (1) Place the data scattered in multiple rows on one row Code: * Example gene...

Clarifying interpretation of marginal effects after reghdfe

Hello, I am looking for clarification on post-estimation margins command after reghdfe. I am running a pretty standard Diff-in-Diff (effect ...

Performing Regressions on Panel and Time Series Data

Good afternoon, first time poster here. I'm an undergraduate student trying to run some regressions on data I have been compiling. I tho...

Automatically run a do file when opened

Hello all, Is there a feature that will have Stata automatically run designated DO files when they are opened? Thanks! Deguza

Model fitness

Dear all, Good morning! How could I measure the model fittness of teffects ipwra (inverse probability weighted regression adjustment for i...

Entity fixed effects model - repeated time values within panel

Hello, I want to run a regression in which the explained variable is the bond coupon and there are some explanatory variables, such as size ...

Plot survival curve of the interaction in Stratified Cox Model

Dear all, I ran a Cox model with strata(year), stcox X1 X2 c.X1#i.X2, strata(year) vce(robust) X1 is a continuous variable, X2 is a cate...

estout test results

I am trying to obtain the test results using estout command however I am unable to put them there. Code: reg y x1 x2 x3 x4 eststo 1 xt...

Loop to fill missing values

Hello, I am using a panel data set that has a unique firm id called 'firm_id'. However, this firm_id has some missing values. Thes...

test "dose-response" with categorical variable

Hi! I am performing cox regressions with a categorical indep. variable. In the survey, we have a likert-scale with 7 responses from "ne...

Using nlcom after postestimation margins

Dear forum, Thanks in advance for any guidance you may give. I would like to estimate the ratio (95%CI) of two (2) predicted probabilities...

Generating tables using the eststo and esttab commands in Stata and exporting the tex. file into Latex

Hi, I am currently trying to generate a table in stata to import into Latex using the following code: esttab using OLS_Tables.tex, replace...

Callaway and Sant'Anna Diff in Diff

Hi: I am trying to estimate the effect of a policy using the dynamic DID model by Callaway and Sant'Anna using the CSDID package. I ha...

Difference-in-Differences (DiD) Methods with Jeff Wooldridge -- livestream workshop

Hi everyone Instats presents Difference-in-Differences (DiD) Methods with Panel Data by Jeff Wooldridge, running April 4-5 (starting 11am...

Drawing the yearly production of 16 region in one graph

Hello Stata users; I have this data: Code: * Example generated by -dataex-. To install: ssc install dataex clear input str15 year int(...

Long data formatting and Clogit model for discrete choice experiments with multiple choice questions

I have survey data from a discrete choice experiment where each survey respondent was asked to complete 8 discrete choice questions (choose ...

Exporting psmatch2 results on the matched sample: a solution with esttab

I am writing my thesis right now and have had many troubles trying to export the results of the user-written command psmatch2. Eststo and es...

Creating filename as columns in multiple files dta files before appending

Hi, I am trying to include the name of the file as a variable before appending. Please see code below, which works well. ideally the var...

converting "None"(python) to "" (Stata).

Hi , manipulating a list in python I ended up with the following tuple, which I need to send to stata default frame ('47313362',...

Interpretation of a Regression Output

Dear experts, I would like to kindly ask for your help in the interpretation of a regression output. Compare statistical significants and ...

Count unique appearance of values across multiple variables in wide format

Hello! It has been a while since I have used Stata and I need a bit of help. I have a wide dataset with variables activ1-active27. Acros...

Generating IDs

Dear all, Suppose I have the following dataset Code: clear input var1 var2 1 1 1 2 1 3 1 4 2 1 2 2 2 3 2 4 3 1 3 2 3 3 3 4 4 1 4 2 4 3...

Adjacency matrix

大家好： 如何使用统计码构建中国各省的（0，1 ）空间邻接矩阵

Bysort and egen code not carrying over correct data

Hello, I have a long data set containing college enrollment data by term, multiple instances per student ID. If a student enrolled 10 term...

Panel Var and Fan Charts

Hi all, Its bit urgent please I'm using panel var in my project, i need little help could anyone please share command to generate ...

Fix a coefficient to the value it had in previous mlogit

Hi everyone, this may be a very simple problem and I am just not getting it, but here's what I am trying to do. I want to use -mlogit-...

How to change the format of numbers stored in a local macro?

Dear Statalist, I am trying to format the number stored in a local macro using the string(n, s) function. Here is my code: Code: versio...

Unexpected error with -bayes:mixed-

The following Code: sysuse bplong bayes: mixed bp i.when || patient: , noconstant residuals(exchangeable) aborts with the following error...

R-squared and -didregress-

Good evening all, Is there a way to have -didregress- show a value for r-squared- as you would see if you did a difference-in-difference r...

Mixed-Effect Zero Inflated Negative Binomial model ??

Hello, I have a study where I am evaluating the relationship between the total number of health care visits and geographic access (measured...

Why does the asreg command give me values for the first observations of my sample even thought I specified a min?

Hello everyone! I am using the asreg command to calculate betas using one year of daily data, but I want the year to have at least 150 obs...

Appending excel files - Error r(601)

Hi. I am trying to append all excel files in a single folder into one big file, but the code below throws the r(601) error. I've made su...

Counts in a long dataset taking into account other variables including time

Hello, I have a very large dataset that includes people ("personid") who could have been seen at 4 multiple sites (distinguished...

Perturb with Mlogit

Hi All, I estimate a multinomial logit model with 10 independent variables. I suspect that there might be a multicollinearity issue. So, I...

Endogeneity concerns

I am working with a dataset of about a total of 28000 observations for over a period of 10 years. I ran a probit model for my baseline resul...

Control variables for intraday data.

Hi everyone, I would like to add control variables (BookToMarket, Size...) to my data to regress Abnormal return on text sentiment. For eac...

Different colors for graph bars

Hello, I have a basic doubt. I am trying to plot a graph on GDP per capita which has 2 bars- one for OECD and another for non OECD countri...

Compute a difference rate between two variables

Hello everyone, I have to use the variables lonely and ca_couple, calculate the proportions of individuals who feel lonely some of the tim...

Descriptive Statistics at Baseline

Hi, Suppose I have two waves of a survey. I make use of a DID. The treatment is whether a particular HH_member passed away by wave 2. I...

guidance on minimum sample size for 'medsem' package

My understanding was that SEM typically requires a larger sample size, ideally over 200 observations for reliable results, but the 'meds...

Nesting foreach loops within a while loop

I am trying to create a foreach loop within a while loop, and the issue is that the foreach loop executes completely, even if the condition ...