Problems corresponding to variable names in stata double-layer loops

I encountered a problem in the process of data merging. I put 5 control variables into 5 sheets of an excel table. After converting the pane...

How to loop through multiple locals instead of all variables inside each local?

Code: local ipv "angry fear intimacy_idx cont12_idx ev12_idx pv12_idx sv12_idx ipv_ovall_idx" local ipv_12_entire "cont12_i...

How to loop through two locals instead of all variables inside each local

Code: local ipv "angry fear intimacy_idx cont12_idx ev12_idx pv12_idx sv12_idx ipv_ovall_idx" local ipv_12_entire "cont1...

Transformation of values

Hi, I have a data set on tumors with the variables karnofsky index/KI (categorical with values 40, 60, 80, 90, 100) and gross tumor volume...

keep observations if first 2 character of the string is capital letter

I have a dataset where the variable x is a string. I need to keep only observations at which the first 2 characters in the variable x is cap...

Latent growth curve modeling

Dear experts, I am currently trying to fit an unconditional growth curve model (as a first step before looking forward to more complex mode...

Heckman

Hi, How do I apply weights in Heckman selection model? Thank you

Compare coefficients with xtreg i.year and fe

Hello, I have two models: Model A: Y = α1 + β1X1 + Σθ∙C + firm-fixed effect + year-fixed effect Model B: Y = α1 + β2X2 + Σθ∙C + firm-f...

adjustrcspline error

I'm trying to fit an stcox model with cubic splines to see the association between mortality and ratiopasit where ratiopasit is the rati...

Clarification on Methods used for 95% CI Calculation in sts list Commands

Hello, Would anyone be able to clarify the following three questions about the methods Stata uses to calculate confidence intervals for th...

Resize graphs for putexcel but obtain good quality

Dear all I am creating a data report with Excel and use putexcel to transfer the Stata graphs to excel. The height option has to be large ...

GLS Fixed Effects regression, Omitted because of Collinearity

Dear Stata community, Hi, I have a panel data (Company ID, years) independent variables(MTB, size, growth, roa, tangibility, covid19: dumm...

generating a new variable based on 2 conditions

hello there new stata user i have a dataset that look like this date_m com date com_ret Date com_cap smb_group groupmean 2018m12 Comp7...

Plot the estimated hazard curve at mean-1*SD mean, and mean+1*SD after fitting survival analysis using Stata.

Hi, everybody, I have a dataset like this, * Example generated by -dataex. clear input int id int time byte injury byte safescore 1 1 1...

Unbalanced Panel - Structural Breaks

I have an unbalanced panel dataset. I am looking to do structural break analysis and came across xtbreak and estat sb commands. However, the...

45-Degree Line with Marginsplot

Dear all, I am trying to add a diagonal/45-degree line to my marginsplot, but (function y=x, ...) does not work. Could anyone tell me whethe...

Using CRSP to calculate the Cumulative Abnormal Return

Hello everyone, This is a very noob question, I am trying to get the quarterly CAR. However, my school's subscription only provides da...

True Random Effect Greene

Dear sir, Recently i've been trying using SFA to determine the efficiency of Gov't Spending. Im using Greene true random effect (T...

New package -rori- on the SSC

Thanks to Kit Baum, there is a new package -rori- on the SSC. rori -- Immediate command for estimation of selection bias through relative ...

Drop observations if not meeting frequency criterium

My dataset consists of time-series observation of US firms with identifiers like gvkey, cusip and a construct variable cusip_fiscalyear. I u...

Creating a 2 Y-axis line using two datasets

Hello Stata community; I have 2 Stata datasets: one is called Republicans, and the other one is Sunspots. Example of Republicans data: C...

sample size-new

From a published study we have the following information. Here there is only one group (preterm infants, 56 infants) in which the variable ...

Reference group with multiple dichotomous variables

Hello Statalist I have a question regarding how to interpret the reference group in my logistic regression. I have four independent variab...

Portfolio average

Hi, I'm currently writing my bachelor thesis and I'm new to Stata. I have monthly data and I want to sort the data monthly in 5 port...

Sample size

Hello everyone, I ask for advice on the calculation of the sample size ... From a previous study (which considered 56 highly preterm infant...

Running Multinomial Probit on unbalanced Panel data

I have unbalanced panel data on household cooking energy, with total observations equal to 1762 as follows: Year Count 2010 2013 ...

Reshaping long for variables with two indexes

Dear Statalisters, I am having a little issue with the -reshape long- command as I'm discovering it for the first time and I'm not...

Split string variable by the last word that meets character length limit

I am trying to upload a csv on website however, it requires that the character length for the field should not be greater than 500. Since ...

How to count firm number in panel data?

Hello, I have some troubles in counting the firm number in panel data. I have 3741 fiscal year observations during 1994-2006. And I want t...

Trailing but not leading zeros in display format

I would like to display a set of probabilities at two decimal places but with no leading zeros. E.g. I would like .95 to display as .95 and ...

GMM estimation and Agumented taylor rule

How to estimate the four parameters of the Augmented Taylor Rule i_t=(1-ρ)α+(1-ρ)βπ_(t+n)+(1-ρ)γx_t+ρi_(t-1)+ε_t using Generalized Method...

Color for figure: twoway (tsline)

Hi all, I am making a figure and I would like to differentiate between colors. Specifically, I want the K2K CEMs to have a different colo...

graph x-axis not legible

I used the code below to generate the attached plot but the values on the x-axis are not legible. Kindly assist. coefplot /// Array (De...

Formatting datetime from one format to another in same variable

Hello everyone! I am facing some issues with my timestamp variable. The data that I have received from the field are in 2 formats: 1) 17...

How to weight the Gini coefficient decomposition?

hi all, i want the Gini coefficient decomposition in Lerman-Yitzhaki's method. but "descogini" doesn't support weights....

Accessing Files Created within Subprogram

I am writing a Stata .ado program that performs the same subroutine many times. As such, I would like to turn this subroutine into its own s...

Overlay graphics in Stata / Export graphic with transparent background?

I have 2 graphics (attached, .gph and .png versions of each) that I created with a user-written command (gsa) in Stata 17. They stem from th...

Fixed Effects: how to report in a table

Hi all, I would like to ask a question, please, about how to report a fixed effects regression in a table. Should I, for a fixed effects...

5*5 bivariate dependent sorting for portfolio creation

Code: * Example generated by -dataex-. To install: ssc install dataex clear input str15 companies byte stock_id int date double(Returns Id...

Prediction interval (not confidence interval) calculations for glm w/ robust VCE model?

In reference to the two threads below, did anybody ever figure out how to get prediction intervals/individual intervals/the stdf command to ...

Difficulty with margins: Wald estimate discrepency between ivreg2 and margins

Hello, I am trying to estimate the Wald estimand and calculate standard errors using margins and suest, but I'm not able to exactly rep...

Problem with Gen & string/numeric variable conversion

Dear forum members, I am new to Stata and having a problem that I can't seem to find a straightforward answer to. I'm dealing with...

Meta analysis using stata 15

How can I test/visualize subgroup difference. I use metan by(subgroup) but I can’t get the difference between subgroups? anyone can help?

svy: tabulate seems to misprint the extended missing value .z

Hello Statalist members, I am using Stata 17 (ver.10May2022). I found that svy: tabulate doesn't seem to work properly, if either the...

Scaling fitted values obtained from first stage of IV

Hi everyone: I am running the following regression where I instrument my binary endogenous treatment variable adhd_dx with my instrument q...

Reducing repeated responses to find actual sample size from a multiple imputed dataset

Hi there I am hoping someone can advise me on this complex dataset that is derived from a dual frame complex sample design that is provided...

Multiple time-failure analysis, event-specific coeffcients?

Dear all, I am using stcox along with a stratification variable to estimate the hazard functions for a model with recurrent events. Howeve...

How to create control group against fraud firms?

Dear all, I want to create a control sample of non-fraud firms against firms that committed fraud. I want the matching based on the firm...

Estimate GARCH-DCC with asymmetries

Has anyone had experience estimating GARCH-DCC models with asymmetries (GJR for example)? Can this be done within the mgarch command? Thank...

bysort query

Hello, I am trying to use bys to generate sequential and total number of Lines of treatments by patient by disease phase (CLL vs RT). The to...

Elasticities

Hello, I would like to estimate the exports elasticity and the imports elasticity of some countries using STATA. I have the bilateral exp...

Would constant annual variables across firms in a year be fully absorbed by the year dummy?

Hi all, I am running the following regression using reghdfe written by @ Sergio Correia : reghdfe f.Dependent U c.U#c.Q Q $xlist i.year, ...

Storing the value of a variable from one observation in a local macro or scalar

Dear Statalist, I'm using Stata 16.0 trying to store a variable value from one observation in a local macro (if the variable is a stri...

Collapse variables by country, category, year

Hi! I have the following data (dataex below) and I just want to confirm if I am doing the right approach given what I want to find. Initia...

How would you export ANOVA tables

foreach var in Subclass { anova ATF4Targetgenes `var' export ?????????? } Hello everyone, I have created a for each loop to make m...

Criteria to apply xtpcse

Hello everyone. I have a dataset with N = 178 and T =14 . Is it right to go for panel corrected standard errors model.

Questions about pseudo-strata/psu in complex survey design

Hi: This is not a stata related question, so please forgive me if this is not allowed. I am dealing with the NHIS database which has a c...

convergence not achieved in GMM Model

Dear Statailist I run the GMM regression of my variables in STATA and I have error that w that "convergence not achieved" an...

Base category not displayed

Fellow stata users, I am having trouble getting state to display the base category of the interaction between two variables that are both th...

Panel Data - Random effect model vs Pooled OLS

Hi Statalist This is my first post, so bear with me if I make some mistakes. I am conducting a Panel Data regression by looking at facto...

ARIMA Model

I am trying to find the arima model that has uncorrelated residuals. I plotted the AC and PAC. I observe that in any of the cases (PAC, AC) ...

reshaping OECD panel data with not unique within i(var1 var2) problem

Hi, Stata masters. I have a problem with reshaping the common panel data which shows " with not unique within i(var1 var2) problem...