foreach loop and local

Dear all‘ The code below is too long for me.I know it could be replaced by a foreach loop,but I don't know how to write the loop。Could ...

Subhazard estimates from stcrreg with multiple (>2) competing hazards.

Hi All, I am trying to estimate a competing hazard model ala Fine & Grey (1999). I have three different transition states, all of wh...

Removing duplicate permutations

Hi, I am trying to remove "duplicate permutations". For instance: ID source target 1 A B 2 A C 3 B C 4 B A 5 C B Here, ...

How to move State Application

I have Stata 13 MP on my current laptop (Macbook Air)). I have just bought a new laptop (MacBook Air) and want to transfer Stata to my new l...

Avoiding merge m:m problem...

Dear Statalisters: I have the following file #1: clear input byte(firmid ownerid) float own byte level 1 4 10 1 1 3 53.8 1 2 5 100 2...

How to set width Stata MP 16.1 for Unix

Hello, I am using Stata 16.1 (64-bit, total usable memory 1510.3 GB), and trying to change an extremely large data set to "long"...

Panel data with messy time, very large N

Dear users, My data consists of N=1033 and T=1-15, with a total number of observation of 2300. Time is very messy in the sense that the to...

Reshaping from "strange" to long format

Dear StataListers, I use Stata 14.2. Here is a simplified example of my data (three cities, three years, three variables (co, gas,waste))...

Regressing Firm-specific variables against Macroeconomic variables

Hello, I am using panel data with the following observations: The firm-specific dependent variables (3 variables) have 41944 observations...

Blinder-Oaxaca Decomposition with group specific variables

I would like to run a Blinder-Oaxaca Decomposition on black-white differences. I have panel data where all variables are race-specific group...

how to split datae and time

dateofvisit 1/25/2020 1:02 1/12/2020 11:55 variable type double. how can i split date and time in to two variable.

Converting DMS coordinates to decimal in Stata

Hi! Can someone please tell me if it's possible to convert DMS coordinates to decimal in Stata? I am using Stata 14.2. Thank you!

stcox: Continuous Time Varying Covariates

When evaluating the effect of a continuous covariate that changes from one wave to the next, (in this instance, the relationship between a c...

Two ID variables for each row

Hey all, In advance would like to say sorry for experienced users for asking this (just cannot find the answer). I have a dataset which is ...

.dta files do not open from project manager

Dear all, I cannot open .dta files by double-clicking on them in the project manager window. To be precise, I cannot do that in my Stata ...

Random match between two large surveys with weights

I have two different large-ish surveys of the US adult population. The two in principle are measuring similar labor market and demographic c...

fractional probit regression with interaction term. Margins command dyes() does not work for the interaction term.

Hello, I used a fractional probit regression and added an interaction term. The latter has a significant positive effect. When I try estim...

How to properly read a longitudinal dataset in Stata

Dear Statalist I am interested in analyzing a longitudinal dataset with several observations per individual. However, each individual may s...

Why weak association and wide confidence intervals?

Dear All, I am interested to examine the effect of IPV (Intimate Partner Violence) on my proxy outcome measurement for skilled maternal hea...

How to deal with I(1) and I(0) variables in econometric analysis

Dear Users, I am working on a balanced panel with 50 countries observed over 19 years. My main dependent variable is I(1) while my main in...

How to tell Stata not to ignore missing values in bysort: egen mean command

Dear Stata-Listers, I am posting a question for the first time, so I hope I'm doing it correctly. I have a panel data set and I want...

I'm converting a date but the new date variable is all missing values

I'm using Stata 14.2. i have a dataset with dates in a string variable e.g. 01-Apr-2018. I have used the below code to convert them to f...

Difference between areg and xtset for firmxyear fixed effect

Dear all, I would like to find the effect of bank liquidity risk (my independent variable) on loan pricing (y). Professor suggested me to...

Estimating Modified Jones Model ,No final values generated for Jones model

Hi, I am trying to estimate the discretionary accruals through the modified Jones model in Stata. This is the code I am running for, to es...

Dashed line graph for parts of the line

Hello, I would like to use two line styles for the same graph to denote value above and below a certain threshold: twoway (tsline var if v...

Fixed-effects on sibling data: which N to report?

Dear colleagues, good day! I would be very grateful if you could help me with an issue. Setup: I have data on siblings, 2-3 children per f...

Issues with Creating a New Variable for Observations with the Same ID

Hi, I'm putting together an NBA Dataset for each season that includes data on the outcome of each game of the season. Each game has 2...

help

Hi, everyone, I would greatly appreciate the help that you can give me, it is the following, I have a panel data structure, in long forma...

farvalue command showing error messages

Dear Professors, hope everyone is blessed with good health. I use the following loop command for a number of regressions, the command is s...

Rename using regex?

Is it possible to rename a variable using regex? Let's say I have a variable: g wth_t1_xxx = . Is it possible to rename this vari...

Group by xtabond2

What's wrong with this command ? by COUNTR, sort xtabond2 ROA L.ROA GRTH MIX EFFIC SIZE SOLV RISK LIQUID LEVR INFL ECOGRTH, gmm(L.ROA G...

Scatter plot with bar graph

Hi, I have an issue with plotting a scatter plot combine with bar graph. x-axis is exchange rate (usd) y-axis is stock market return (m...

Survival analysis - creating "failure" variable

Dear all, I'm hoping for some advice re. creating a 'failure" variable for a survival (or time till event) analysis I'm w...

Calculating advertising returns after estimation

Hello everyone, the following question may sound a bit silly but I have been a bit puzzled about this and wanted to share it with you - also...

Export unit root test results to excel?

Hello, We have estout/esttab, outreg2 commands to exports regression output. Is it possible to export unit root test (Harris–Tzavalis test...

Can STATA shows the p-value for each variable used in the discriminant functions?

I get my results and I can interpret the coefficient of each independent variable in each function. However, can we also get a Prob>F c...

Recode Var

Hello How can we find duplicates in a database? Which command I can use to change the observations of a variable. for example Occupation var...

Triple conditions such as relimp==relat==1 do not do what I expect them to do. Why? Where is this behaviour explained?

Working on a problem posed in this thread https://www.statalist.org/forums/for...other-variable I discovered to my shock that triple condi...

svydescribe for mi set data

I have been hunting around and trying everything I can think of but cannot figure out how to get the information I need. I have some mi svy ...

Panel data preparation and xtreg function

Hi I am new to econometrics and stata, and appreciate some help for the following qns related to my dissertation. I am investigating prope...

the conclusion for the correlation of variables

Hi I am doing with panel data ( N=760. T=8) / When I check the correlation of variables the result as below Code: . cor lgdp lpgdp llpit...

How to fix heteroskedasticity and autocorrelation on OLS

Hi I did OLS test for my panel data ( n= 760 and t=8) and checked heteroskedasticity and autocorrelation as below ( the result show that th...

AR(1) and AR(2) test in dynamic panel GMM estimation?

Hi, I am using diff-GMM and sys-GMM for an unbalanced panel with time (T=5) and country (N=84). I am trying to get Maintained Statistical ...

Correcting the problem of Multicollinearity in categorical variables

Dear All, I have among my explanatory variables, a number of categorical variables and after testing for multicollinearity, I had some of ...

Finding duplicate variables

Dear Statalisters, I am writing you because I would like to find out if I have duplicate variables in my database. I have been looking in...

Coding a new variable: where a category selects 'high' responses for one variable only if there are low responses for another variable

Hi Statalist. I want to code 'impat' with three categories (1 = both low, 2 = one high, 3 = both high). These three levels reflect...

Count and record

Hi all, My data has four variables: acty, deady, nation, and id. "acty" is the year when company is listed in stock market. ...

Creating a variable equal to 1 if a name (i.e., string) at time t-4 appears at time t

I have Brazilian electoral data with the names of candidates who ran for mayor from 2000 to 2016. The dataset contains information about the...

Threshold for small/large T in quarterly panel data

Dear all, Sorry for basic question. I am estimating dynamic panel data model for 40 countries & 20-30 years at quarterly frequency. I ...

Creating variables for husband and wife using data for respondent and their partner

Dear Statalist. I would like help to generate a variable, say level of education "educ" for the male partner and female partner ...

Choose Which Fixed Effect Has Coefficient 0

Hi Statalisters, I'm running a fixed-effects regression with fixed-effects by region (e.g. Americas, Africa, Oceania) using standard O...

help exporting lstat results after logistic regression into word/excel documents

hi all, does anyone know of a way to export the results of lstat into a word document or a table/excel? I have tried using outreg2 and asd...

Heckman Procedure for Gender Wage Gap (Oaxaca Decomposition)

I am trying to decompose the gender wage gap into explained and unexplained factors using the Blinder Oaxaca decomposition technique using l...

ppmlhdfe in panels

Dear everyone, I post this because I am confused with bilateral fixed effect estimates: I estimate the effects of restrictions in servic...

vector of control variables for panel data

i want to know the command to get vector of control variable. I want to get vector of country level control variables - democratic accountab...