Individual line colours in pcspike

Hello, I'm trying to create a parallel axis dot plot where each line has a different colour (I've managed to get everything else I...

Line Graph in Panel Dataset

Hi! I wanted to how to create a single line graph for a panel dataset? The dataset looks something like this: Country Year GDP A ...

Creating a treatment for DID analysis: how to do it the right?

Hi all. I have panel data containing the number of Brazilian institutions of higher education (variable "n_he_inst") across more t...

Weights in the rdbwselect command

I am trying to use the rdbwselect command and it has the the following syntax (from The Stata Journal (2017) 17, Number 2, pp. 372–404) rd...

Three-level ZINB in Stata

Hi, I use Stata 16.1 and I need to run a 3-level Zero Inflated Negative Binomial regression. I have seen some previous answers suggest usi...

generating separate variables from one variables's observations, is there a loop?

Dear all, From the variable v I would like to generate 3 variables: v1, v2, v3. Given that these are the 3 observations of v. I need to ma...

Cleaning for Optimal Modeling (ft. Panel Data)

Hello Everyone, Let's say I would like to do a linear regression on some Panel data without knowing if linear regression is the most a...

exporting many tables to excel

Hi , I have a question about how I can export many tables in a good format. I am trying to run regressions for 49 industries (later I need u...

Mean of means, with means obtained from by year, sort + weigths

Hello, I have obtained the mean, median, stdev by year (I have 18 years in the sample) for my expenditure variable a_rep_pos throught the...

parsing a variable based on digits

Dear All, I try to create a new variable (let's say caseid_copy) based on the original caseid. However, I have problems with its digit...

Replicating Excel Intercept/Slope

I have four variables, y1-y4 that I would like to regress on four fixed x's, x1-x4. (I have taken the logs of both the x's and y...

how to calculate pseudo-R2 using imputed data in a multinomial logistic regression

Dear all, I would like to calculate the pseudo-R2 for my multinomial logistic regression in multiple imputed data. This is my code for im...

Creating space between bar charts

Hi, I am using Stata 17 and need help in bar charts. Below is an example of my dataset: Code: * Example generated by -dataex-. For mor...

Multilevel model with olog?

I usally use the command: mixed dep_var || country_var: Problem is that my dependent variable is only scaled in two categories (0-1). I...

Generating new ID variable taking into account duplicates across 2 other variables

First time poster, so I’m sorry for any errors… I have two ID variables (ID1 and ID2). I want to create a new ID variable taking into acco...

Need help with Mean for Grouped Data

Array Good morning Stata Family, Please I want to create a new variable for the average wage earned by each worker for B and C shifts al...

Specification of treatment and control group in diff-in-diff

Dear all, I am doing a difference-in-differences estimation to see the effect of a parental leave reform on mothers' and fathers' w...

marginal effects

Dear everyone, I have a regression on GDP where I include both inflation, inflation^2 and one lag of these (I also have other control vari...

Endogeneity test for two endogenous variables using REIV (xtivreg, re)

Dear all, I am using an REIV using the command "xtivreg, re". I have two endogenous variables, y2 and y3 (y3 is an interaction o...

How to choose part of dataset based on date

Hi I need some help with Stata syntax. I have a dataset with persons who have participated in a health survey, and later had a specific su...

Multiple observations per year in the dependent variable and annual observations for the dependent variables

Hello Statalisters, I am trying to explore the impact of CSR expenses on the credit ratings of firms. Please find below a snapshot of the ...

Help needed: Export F-stats and P-values to an excel file

Hi, I am using Stata 17 and need help in exporting results from Stata to excel. Here is an example of my data: Code: * Example generat...

Direct, indirect and total marginal effect in the mvprobit

Please how to calculate the direct, indirect and total marginal effect in the mvprobit ?

Predicted Probabilities with Logit and Fixed Effect

Hello, I am trying to compare 4 different groups (black women, white women, black men, and white women) and their probability for leadership...

Measuring environmental innovation patents

Dear Stata experts, For my master thesis, I'm figuring out how to analyse in order to measure environmental innovation patents. I...

Plotting regression results in scatter plot

Hello, I have a regression of the form: Code: reg yvar xvar zvar i.year where year is a categorical variable from 1990 to 2020. I wan...

margins & marginsplot in LCA by group

Good morning colleagues, I'm having some trouble working out how to use margins and marginsplot to present bar charts for my Latent Cl...

Create a variable that summarizes the number of distinct combinations of string variables

Hi all, Apologies in advance if my problem is unclear. I'm a former Stata user who has since been using Excel and previously SAS so I...

Intersection among datasets

Hi all, so I have k databases (55) called name_country_mole.dta. Each database is an unbalanced panel of molecules observed for a certain ...

enquiry about using likelihood ratio test when employing conditional logistics regression !

Hello, I am testing a categorical variable (ethnicity) with a binary outcome (death). I want to obtain a single P value across all categori...

xtlogit with one dummy predictor

Hello all, I have been looking for days for an answer to this question, but have not found an answer so far. My problem is as follows: I...

Forecasting

I have been using STATA to do some forecasting on stock market data. When I generate the forecasts and look on a graph they are miles off, e...

Tesla McKinsey 7S Model

Tesla McKinsey 7S model illustrates the ways in which seven elements of businesses can be aligned to increase effectiveness. According to th...

No observations r(2000)

Dear everyone, I am working on my masters thesis and I am trying to make a twostep system gmm regression on gdp with a five-year average. ...

Generalise value of dummy variable to all observations of a given panel ID

Hi, I need to set the value of a dummy variable = 1 for all observations of a given panelID, if it already equals 1 for any observations o...

Creating a categorical variable with multiple dummy variables

Hello everyone, I am looking for a way to create one categorical variable out of multiple dummy variables. More specifically, I have ten d...

Help needed in loops

Hi all, I am using Stata 17 and would need some help in my loops. Below is an example of my dataset: Code: * Example generated by -dat...