How to create a weighted average for multiple observations for a variable by borrower_id and year

Borroer_id Year Loan amount Loan maturity Loan interest 1 2011 101 60 8.5 1 2011 95 55 5.7 2 2011 85 55 8.6 3 2011 90 44 6.5 3 2012 82 ...

Calculating differences between adjacent elements

Dear all, I wonder if there is any easy solution available in Mata for calculating the difference between adjacent elements of a (column) v...

save regression results for margins ploting

My question is straightforward. Could Stata save regression results so that I do not have to re-run the model when trying to use margins an...

Estimate the difference-in-differences estimator

Hi, I restricted my wave sample from 1-10 to 9-10 and I was wondering how would i use the command bysort to create a covid variable. To sh...

Combining variables in the variable list by country

I am looking at the dataset where I have three variable lists: life expectancy by country for specific age groups . The age interval for n...

Interpretation of Competing Risk with stcrreg

I'm new to using competing risk analysis and want to make sure I'm interpreting and using it correctly (given that I'm getting g...

Multiplying observations in a variable list

In a dataset of multiple variable lists, I would like to multiply the value of only selected variables in one variable list by 4. Namely, I ...

Zero event meta analysis with ipdmetan

Hey everyone, I'm trying to run a two-stage meta-analysis to generate a forest plot with individual participant data using ipdmetan to p...

Traj command (dropout model)

Hello everyone, I am using the traj command to examined gait speed trajectories and I have a question about the dropout model option. When...

Making a dummy for threshold

Hi, I am going to make a dummy Ii ( Em (i)<= Em) that selects firms whose employment (Em(i)) is below a certain threshold, the median ...

Selecting Date Range

I have a data where one of the variables is CloseDate whose Variable Type is int and Format is %tdnn/dd/CCYY. I would simply like to select ...

How are p-values calculated in an Oaxaca-Blinder Decomposition

Hi all, I am trying to interpret the results of an Oaxaca-Blinder Decomposition. I am using the popular Oaxaca command. For my project I a...

Solve dynamic non linear deterministic system

Dear forum, After several hours of work, I am looking for the forum to help me to find a solution to my problem. I am used to work with GA...

Calculating summary statistics for correlation coefficients

Hello, I have calculated some pairwise correlation coefficients between observations in a panel data set within a grouping variable, and I ...

Country-pair specific id for gravity model

Hello all, I'm trying to estimate a gravity model with trade data that is disaggregated at industry level and trying to include countr...

How to merge datasets using joinby?

I have the following data. In Data set A, I have rows of children with "h13hhidc" indicating their household ID including the rele...

Describe variables

I have a dataset (example below) and I would like to know the frequency of males (sex==1) and females (sex==0) that mentioned (resinsulted3_...

How to perform relative mortality in STATA?

Hi Everyone. I have a dataset of cancer patients from 2004-2014 with survival status until 2015. Now I've been asked to do relative mort...

Sactter plot with different groups while adding label for one particular observation (sepscatter command)

Hi everyone, I have a cross section data for a group of countries and three variables: government spending, test scores and regions (pleas...

Creating a combined averaged using a panel dataset

I have a panel dataset in vertical form with 6 countries; each shows values for 14 indicators between 2000 and 2020. There is a column that ...

How to deal with multicollinearity when adding fixed effects dummies in regression with cross sectional data?

Hello, I have cross sectional data with 26 groups. I estimated a probit and fracreg regression for my two research questions. Since my key...

scatter Y X || lfit Y X ||, by(variable)

Good evening, I'd like to run scatter Y X || lfit Y X ||, by(variable) but have everything on one graph instead of multiple graphs. I...

Brant Test Significance Question

Hello everyone. Thank you all for taking the time to answer other questions on this forum, it had been very helpful. This is my first time p...

Best way to improve processing speed for large data sets (~3gb)

How much will more RAM help me with processing speed. I am working with a dataset of 87 million records and is about 3gb in size. Its a 20...

Hausman Test Failed

Hi! my name is Karina. I run a Hausman test on my stata using command: quietly xtreg ecgrowth jubgrowth sukubunga inflation, fe estimates...

Running ANOVA in loops

Hi, I want to run repeated measures ANOVA on math scores and semester, but the analysis has to be done for all levels of stress (high/mid/lo...

Time invariant dummies.

Hi, I am performing a fe model and I am adding a series of country dummies to control for country fe. Unfortunately, all the country dumm...

How can I check if a string has repeated words?

I know the moss package is related to this but I cannot make it work yet(one similar post can be found here ). For example for the string ...

forvalue loop for discontinuous variable

How I can use a forvalue loop over the variable whose values are not sequentially continuous? I want to use forvalue loop for the industry c...

Panel Data

Hi, I am using panel data with the wave variable ranging from 1 to 10 however i would like to focus on wave 1 to 8 instead when testing fo...

Testing stability of reggression discontinuity model (TED)

Hello Statalisters, I need your valuable advice. Having applied in my analysis regression discontinuity design (RD), I want to check the ...

matching single county with unique congressional district

According to us house election data a single county for a specific state belongs to multiple congressional districts . However, based on th...

Jackknife xtqreg

Using the Grunfeld data, this works: Code: bootstrap, reps(50) cluster(company) idcluster(comp): xtqreg invest mvalue kstock i.comp#c.tim...

Combine multiple rows into one when end_date = start_date

Hi there, I am looking for a code that combine the rows when end_date = start_date for a certain ID when all the variables have same value...

Wild bootstrap with ML

Dear users, I need to estimate a maximum likelihood model with wild bootstrap as I have few cluster issue. I wonder if I can get any advice ...

Bug in the dir extended macro

Dear All, I wonder if anyone can interpret the below syntax line for me. Thank you, Sergiy Array

New Stata package: ddml for Double/debiased Machine Learning

I am happy to announce a new package that I have written together with Christian Hansen, Mark Schaffer and Thomas Wiemann. We introduce t...

Predicitve Margins and Marginsplots dor continuous variable

Hello together, I am completely new to margins and marginsplots an have the following question: I have this regression: Code: reghdf...

Merging problem of congressional district data with counties

This is my one set of data where I have statefip , district ( which stands for congressional district) and county. I want to merge this data...

Is there a way to make Python stop on error when running PyStata ?

Suppose I have the following (toy) code Code: import stata_setup stata_setup.config("C:/Program Files/Stata17", "mp")...

Create empty graph in a loop

Dear Statlisters, I have a series of graphs made in a loop which are then amalgamated using grc1leg (a wrapper for graph combine). There ar...

Changing an estimation stored macro with a previously stored macro

I am trying to change an estimation stored macro with the stored result from the previous estimation. I manage to do so with `e(cmd)' bu...

Discrete Choice Experiment - Fractonnial factorial design

Dear collegues, As PhD student, I want to set up a Discrete Choice Experiment in a consumers survey. The main objective is to measure cons...

10000 posts by William Lisowski

Congratulations William Lisowski on reaching the milestone of 10,000 posts on Statalist! Your contributions have greatly enriched the commu...

Need some help dealing with duplicates

Hi all, I need some help with dealing with duplicates in my data. I have something like this: var1 var2 var3 var4 a x Red 1 ...

Mediation effects with MLM?

I'm trying to do a somewhat tricky mediation test. Basically, I'm looking at the relationship between parental education (4 levels) ...

Very large T- Statistics

Hi Stata Community, I'm running some regressions using Fixed Effect Methodology. The issue is that the outcome of my regression shows ve...

Calculate economic significance for censored (Tobit) regression with multiple imputation

Hi, I'm trying to calculate economic significance from a censored (Tobit) regression with multiple imputation according to this defini...

creating table following multiple imputation with svy suite

Hello. Is it possible to create tables using "collect" series of commands using mi estimate:svy, subpop (subpopulation): logit x...

Computing a cumulative score

Hi, I have the following sample of data. I have an indicator of 1 and 0 in once column and I want to compute the sum of consecutive 1s (i....

Adding Number of Observations Label to Stacked Bar Chart

Hi all, I'm trying to make a stacked bar chart that shows the number of observations within each group. My current code looks somethin...

Dates in Stata

I am trying convert some dates in quarters. I am doing this by going into the variables manager and changing the format to quarters, as seen...

Dynamic Panel Equation

Hello I am trying to build a Dynamic Panel Equation with the following information - Variables: Y, X, and C (controlling variable) - Time...

Sorting data

Hello, I have the following data below: Code: * Example generated by -dataex-. To install: ssc install dataex clear input double(ID st...

Graphign Functions

Hello, any idea on how to graph the following function: y=35+2x^2-ln(x*3) I tried this: twoway function y=35+2x^2-ln(x^3), range (0 1) ...

stpm2cr - Maximum Number of Iterations Reached

Hi everyone, I'm using -stpm2cr- to model the effect of a treatment on a set of cardiovascular outcomes over a three year period. I ca...

Line graph of percent of frequencies within categories instead of bar graph

Dear statalist, I have a dataset of skin cancer over ten years. I want to plot a line graph (instead of a bar graph) of the percent of fre...

Interpreting Log transformed ITSA model

This question might not be so much as a programming question as an interpretation question. I have a sample dataset as follows: Code: *...

Why line, bar, and pie plot dominate publications

Dear Stata users, There are so many plot types in statistical world, line, bar, pie, box, histogram, violin, radar, mosaic, and diagnose s...

Regression output featuring a period for one variable

I'm using logit regression to link state-level policies with an individual's probability of reemployment. As controls, I feature a h...

Filling in missing data from previous values?

Below I have included an example of a wide dataset in which children have ages reported at each wave (ex: wave 5 age is k5agebg). In some in...

Table1 command issue

Hello, when I write this command: table1, by (pes) vars(edad conts \ par_cat cat \ hta cat \ preprev cat \ diabm cat \ diabg cat \ imc conts...

Regression analysis with panel data

Hello Everyone, I have a panel dataset with approximately 5300 observations and I am analysing if a firm's ESG score has a significant...

cannot run GMM

Dear Statalist, I am using stata v.14... I have unbalanced panel data with T = 17 and N = 18. I mostly have reversal causality from 2 of ...

What does "star" option in pwcorr mean?

Normally I used pwcorr to have a correlation matrix. And for such a command, we have a star option. From the description, they stated: ...

Why using the same code but can run in one machine and cannot run in another machine resulting r(123)?

Hi all, I suspect the problems previously but I can confirm today that some code of mine can work in my shcool's machine but my person...