trend over years for categorical variable

Hi I am doing repeat cross sectional analysis over 10 years (discharge_year) for of a categorical measure (oc_mix) which have 3 categories(w...

how to create the start and end date for a year

Dear statalist, This might be an easy question, but I didn't figure out how to do this. Say I have a set of years, 2010, 2014, 2015, 2...

Perform a paired ttest on two substracts of the same variable

I have a dataset that looks like this: var1 var2 var3 attribute 1 0.93 0.88 1 1 0.76 0.20 1 1 0.40 0.18 0 0 0.3...

OLS Regression - explanation of coefficients with control variables

Good morning, I´m doing an OLS regression with the dependent variable having a health number ( Code: Health_Number - a dummy variable t...

How to write this with a loop (repetitive coding with numerical values that do not follow each other)

Hello everyone, How can I write this faster? Code: svy: prop rech if form1==2 & gan1==14 svy: prop rech if form1==2 & ...

Two way graph with multiple lines in a loop

Hello everyone, Iam trying to do a graph of multiple lines. What I want is a graph that shows in a same graph diffmain, diff4,diff5,diff21 a...

using newey west for heteroskedasticity and autocorrelation in vecm

So, I am trying to run a regression that requires me to log and take the first differences of it to render stationary. That is why I am usin...

creating a dummy variable based on percentage

In the following sample dataset the house election result in United States are given from 2002-2020. Candidatevotes indicate the person who...

local macro text with line break

Hi there Does anyone know if there is a way to spread the text contents of a local macro across multiple lines? Code: local lines ...

Editing graph with a TIFF file

Hi everyone, Trying to find out if there's a way for me to edit my graph using stata's graph editor with just the TIF file. The gr...

pweight with melogit

I have a Panel dataset with 260,647 data points consisting of 260,647 Respondents within 43,400 households and between 1 and 11 survey waves...

Formal tests of volatility in STATA17

Dear Statlist: I have longitudinal data on employee data across multiple years and organizations. I've been making a series of line gr...

Color changes with PNG export.

On the left, we have the graph I actually want (ignore please the slight transparency difference between legend and data colors). On the rig...

Generating the "opposing" variable in a long dataset

Hi all, I am using Stata 17/SE on Mac and I am having trouble generating a variable using another observation within a group. For contex...

convert string yyyy-mm-dd hh:mm:ss to %td format

Hello, As the title of this question suggests, I have a set of data with variable "Qtm" in string format, e.g., 2010-01-07 19:16...

Stata command for weighted M-estimator.

Dear all, Does Stata has commands or packages that can estimate parameters for weighted M-estimators? For example, how to estimate beta wi...

double-hurdle model not feasible

Hi, I'm using a panel double-hurdle model using Code: xtdhreg command. But I get the following error: Code: Obtaining starting ...

How I find the wrong data?

Dear Statalist, I have the note: multiple positive outcomes within groups encountered, followed by clogit Y asc fish_d2 fish_d3 vet_d2 vet...

Create Twoway Line Graph Forcing Gaps for Missing Periods

Hi all, My data: Code: input float(Datum_n total_unem_bymonth sum_newpositions_bymonth) 723 148245 2261 724 150673 4089 725 144790 85...

Treatment Variation Plot

Hello Statalist! I was wondering if it would be possible for Stata to plot this kind of variation figure. This figure shows how the treat...

Create a matrix or data set from current variables in stata

Hi everyone! I have a dataset with three variables: province_code (11 province codes), newnsector (14 sector codes) , r_output. In my Sata...

Reshape data

Hi I have the following data having following variables lat level lon time air dup time2. The level variables takes only two values 1000 ...

Loop with a synthetic control method

Hi everyone, I have a dataset at the state level with 39 states and I want to do a synthetic control regression (as shown) only for the st...

Method deriving weight of second level for mtobit model

I would like to analyse my data in the multi-level Tobit method (metobit) with applying two-level weights. In multi-level linear mixed model...

Leading zero

Hi statalist community, Code: * Example generated by -dataex-. For more info, type help dataex clear input RTR 1 2 3 4 5 6 7 8 9 10 11...

Multiple random slopes in a mixed linear model

Dear all, I have unbalanced panel data with repeated sampling over 6 years, hence I am employing mixed linear regressions. I want to incor...

Optimal lag selection in Granger Causality tests

I use [TS] varsoc to obtain the optimum lag length for the Granger causality test. This command reports the optimal number of lags based on ...

Main effects of two independent variables across five groups

Hi, I have unbalanced panel data for 160 companies from 5 different subgroups (g1,g2,g3,g4,g5) where group id is defined by business activ...

How to draw overlayed coefplot with only one regression

Suppose I have ran the following regression reg wage i.year#i.gender controls where gender takes two values. What I want is to use coef su...

Duplicate row*

Hi how once can check the duplicate row in the stata please

Formatted IQR using Collect

Hi, I am using the excellent Example 3 in the "Stata Customizable Tables" manual to help me build a table with frequency (percen...

About Foreach or Forvalue

Hi! I am trying to create seven summary variables named den_1 to den_7 to simplify the results I have from 34 variables named total1-total34...

GLM binomial logit model gof - Deviance

Good day, I'm using Stata 16 and trying to do gof for a glm logit model but the results show a lot of missing data. My commands are as...

Help: weights not allowed r(101)

Hi! I met a mistake in following command: egen x2 = group(sex re age educ) gen wm = sex == 1 & re == 1 egen wminc = mean(incwage) ...

Estimating latent class models in Stata using both categorical and continuous indicator variables

Hi Statalist community, I am trying to run latent class models and I am fairly new to this type of analysis. I have continuous and categor...

xtivreg2: endogeneity and overidentification

Hello everyone, I have an issue with interpret the result of xtivreg2: - Overidentification is significant - Endogeneity test is not sign...

Household Fixed Effect

Hello, Is there an issue with using HH fixed effects or individual fixed effects when the death of a family member is the treatment in a DI...

Problems with command "etable"

Hi there, My intention is to run "etable" to create a results table of two models. My code is: [ATTACH=CONFIG]temp_29317_166...

Which test should i use on Stata ?

Hello, I would like to know which test to use on Stata according to my configuration. So I want to compare 3 ways to collect data So I...

Understanding type of panel

Hi everyone, I have individual level data for 20 regions for 18 years. The question is to examine the impact of x on y (binary variable). ...

How to calculate days and hours between two dates

Hi, I am calculating days and hours between two dates (admission date/time and discharge date/time), thanks for any suggestions. Example...

Problem of missing observations in CAPM estimation

I have following variables from raw data and I want to estimate the return of Stock PG using CAPM model. I found that there are a lot of mis...

egen for numeric variables

Hi, I'm trying to concat two numeric variables whit the egen command, I know when it is used a string variable results, but, when I try ...

DiD

Dear All, I have ran into several general issues whilst starting to work with DiD. The data that I have is repeated cross-sections with 1...

Variable not recognized after modification

Hi everyone, For company data analysis for my thesis, I wanted to create industry dummy variables based on the company's SIC Code 2...

Unable to report & understand relogit marginal effects

Dear all, In my (regression) analysis I am trying to see when companies are more likely to demand aid from governments, considering 5 majo...

Rearranging columns and rows to make it country-level database

I want to create two columns: Column A with all the countries listed in the photo below Column B with one of 3 options (Advanced Economies...

Side-by-side boxplots with markers for means

Hello, I have country-level panel data for GDP per capita for the past 10 years that I wish to represent in a side-by-side boxplot (by yea...

Creating a scatterplot with two different variables

How to create a scatterplot with two different variables one being dependent and one being independent? the original question is: Create...

Callagain command by Behaghel et al.

Hi I'm currently trying to run the command "callagain" by Behaghel et al. (to be found here ). Unfortunately, the command do...

Writing a formula in which stata chooses a value or 1

Hi! I'm trying to use this formula to calculate eGFR: eGFR = 142*min(standardized Scr/K, 1)^α *max(standardized Scr/K, 1)^-1.200 *0.99...

Adding rows under a variable

Stata command for adding rows lets say 10 rows under a variable which has fixed observations like 40 for each unique id

please help. making bar graph more simple with "over" options

Hi, guys. I'm a newcomers with stata, and there is some trouble in making bar graph. My data has 46 observations, and it has numeric...

Please help cant work out how to t-test. Im new to stata

Hi guys I'm struggling to compare 2 different regions with a t-test. As seen from the screenshots I have multiple regions and have gen...

Pseudo Panel Data and Mediation Analysis

Dear Stata Experts I'm a PhD student, and I'd like to know how to use the codes to perform the Mediation analysis when using pseud...

Using cii proportions with loop

Hello, I am trying to compute confidence intervals for proportions (number of cases / total) on each observations of a simple database usi...

LSDV and collinearity

Hi everyone, I am having trouble implementing a simple least square dummy variable (LSDV) model. The model I am implementing is the follow...

Space between axis and line chart

Hi, I have dataset starting in Febuary 2020 but when I create a chart for some reason the x axis starts on the first of January, so there is...