Taking the average of observations within a specific date range

Hi, I want to compute the average of a variable (teamsize) for observations within a specific time period. I have a date variable formatt...

Create a two-way line graph/bar chart

Hi all I want to create a line graph/bar chart which looks at the consumption of 3 main fertilizers- UREA, TSP and MOP over a 3 year perio...

interaction effects: Poisson or Double-limit Tobit

Hi All, I am working with the DHS data across five countries and looking at relationship between women's empowerment and children'...

Estimation output for Svy: meologit and melogit commands

Hi all, I am using Stata 14.1 and i am getting an odd but of output. I am estimating a series of mixed effect ordered logit and binary l...

How to filter dates within an interval from a set of observation

Hello, i have a dataset of around 900,000 observations from about 130,000 ids. The variables i am working with are mostly dates. i wanted ...

how to get x-standardized coefficient in logistic regression, i.e., reproduce results from "listcoef" command

I was trying to get the standardized coefficient from ologit model. "listcoef" can produce the table nicely, but I want to reprodu...

reshape - wide connections

I have variables in wide that belong together i groups (eg. var1a and var2a). I would like to reshape into long while assigning the value i...

Cox regression assumption

I am doing a research to examine the association between sleep and all-cause mortality. The average follow-up time is only 5 years for both ...

SEM, error coefficients output.

Hi, How can I receive the outputs for the "path coefficient" of error terms to each items of a latent variable? The output only s...

New Stata 16 versions of dolog, dotex and dologx on SSC

Thanks as always to Kit Baum, new versions of the dolog , dotex and dolog x packages are now available for download from SSC. In Stata,use t...

Gravity model of migration: ppml vs. ppmlhdfe

Dear all, I'm working on a gravity model of migration for my thesis. My data contains 28 EU countries as destination countries, 130 no...

Probit Marginal Effect

Hello Everyone, I am working on a Probit regression for my research, I want to report the marginal effect but I can't seem to figure ou...

Recoding in panel data

How to recode values by groups in panel data by using Stata commands? For example, the score for id1 at wave 1 is 3, and I seek to let the s...

Propensity Score matching: how to define the dependent variable

Hello everyone, we are trying to use propensity score matching (PSM) to find the suitable control group. Our data set is at the exporter (Ch...

Create fiscal years from years and months

Dear Statalist, I would like to create a fiscal year variable that take values like 2005-06, 2006-07 and so on till 2018-19, from the var...

Values of multiple columns in one column using a loop

Hi everyone, I'd like to place all values of multiple columns in one column. I tried stack using a loop: Code: foreach id of loca...

Variable Labels

Hello dear forum members, I am new here and am currently learning Stata. I am a beginner and have only one question. Maybe there is already...

Problems creating Herfindahl-Hirschman Index

Hello everyone, I want to create the Herfindahl-Hirschman Index for my data. I have quartlery data for different banks. I want to have the...

Taking the average of observations within a specific date range

Hi, I want to compute the average of a variable (teamsize) for observations within a specific time period. I have a date variable formatte...

Code of Patell Z-statistic

Goodmorning everyone, I'd like to derive a Z-statistic by means of the Patell test ( https://www.eventstudytools.com/sign...e-tests#Pa...

renaming variables using values they hold

Hey everyone, Is there a simple command (or few lines of code) to rename variables based on a specific string value they hold? In more d...

How to display the P value of the mediation with khb command?

Hi all, Recently I read a paper published in JAMA Pediatrics(doi:10.1001/jamapediatrics.2019.1212), the authors provide the P value of the...

Sample size estimation for comparison of three proportions: Control, Treatment1 and Treatment2

Dear StataList, How can I calculate the sample size requirements for proportions in 3 (three) groups, namely: Control, Treatment1, and Trea...

Random Effect Autocorrelation Test

Dear Good People, I am currently shifting to using Random Effect for my data and I would like to know if there is a spesific command to ex...

Average calculation issues

Hi there, I would like to calculate the average account receivable using netaccountsreceivable and lag_net_account_receivable. However, ...

Expression builder dialog

Is there any way to make the expression builder dialog larger? The lists are too small to be usable and require constant scrolling both vert...

Python means no more calling RDBMSs to get the UTC offset

Updated my -tslog.ado-. See log file attached.

Panel Data with same values/data for independent variables across multiple countries

I am analyzing the impact of US monetary policy variables on capital flows to emerging markets and intend to use panel data analysis. I have...

Roommates' max expenditure with parents' educations

Dear All, I was asked this question here . The data set is Code: * Example generated by -dataex-. To install: ssc install dataex clear in...

Combining local macros in Stata

I am trying to create a loop that copies specific files (which have a specific identifier at the end of the filename) from a list of folders...

Blog entry on quickly setting up Python with Stata 16

Here is my first blog entry on how to quickly set up Python with Stata 16 https://fintechprofessor.com/2019/06...with-stata-16/

Can Stata 16 frames be appended?

Fellow Statalsters (especially StataCorp) Many thanks to StataCorp for Stata 16. The frames are a specially welcome addition, and I have b...

Mixed-effects logistic regression for panel data

Hello, I am using mixed-effects logistic regression for panel data in STATA 15, and I was wondering if my commands are correct. My DV is a...

Ereturn Scalar on MI Estimate?

Hi All, I currently am trying to perform a bootstrap on mi estimate: logistic. However, when I run my code, I get the following error: B...

2x2 AB/BA crossover trial analysis resources/advice

Hi all. I would like to conduct the analysis of a trial comparing two drugs (A and B) on reducing pain associated with a procedure. Subj...

Summarizing special character of string variable*

Is there any command by which I can summarize special characters (e.g. *,-.) of string variable?

Observations in descriptive and multivariate analyses

Hi, I am just writing to ask something about the observations in descriptive and multivariate analyses in my paper. Do I Need to make them i...

PCA vs MCA for index with survey weights

Dear All, I am trying to calculate a wealth index using Principal Component Analysis. The quintiles derived from it are to be used as prox...

Constrained systems of sfcross regressions!

Hi everyone, I'm trying to do something which I'm not sure is possible with Stata. Basically, I'm trying to replicate a pape...

mixed models xtreg xtmixed

Hi All, I have a question about xtreg and xtmixed. If I enter the following command I get this result. xtset interven2 xtreg difftot...

Different markers with rcapsym

Hi, I would like to have 2 different markers for the starting points and the end points. So for example, the 07 starting score should be a...

Regarding the question of the spmatrix import comand

i do a spmatrix import, while it Array i modify my matrix from the command of spmatrix export, so i am sure my matrix is correct because ...

How to drop duplicate ID observation series with different variable values

Hi all, I hava an panel dataset for firms and stock returns between 2005 and 2015. However, for some observations (sorted by FirmID and Da...

appending a string and time variables

Two of the variables in my dataset needs to be appended into a new variable. The first of represents a data in this format (string variable)...

Error Code r 601

Hello, I am trying to import an excel file into STATA but I receive the error code r 601. I am using the correct syntax and path location....

Problems with -collapse- command

Hi all, I have a problem when I use the -collapse- command. In the following code every time I use the command -collapse- it does not matt...

power analysis after ttest

I'm trying to import the means and stds from a two sample ttest into power twosample, but the power command seems to accept only typed-i...

xtqreg and reghdfe

Hello, My question can be summarized as... why does xtqreg and reghdfe produce similar results when my data set has large outliers on both...

How to control for something within a Diff in Diff Graph

Hello everybody, I am currently trying to create the usual Diff in Diff Graph e.g: Array My setting: I have panel data of about 4 mil...