Interaction variable (using dummy and date variables)

Hello everyone, I am trying to create an interaction variable by multiplying a dummy variable (0,1) with a date variable. I am thinking th...

regress help requested

I have a dataset in which all the dependent variables are for the years 2020 & 2021. I have 4 dependent variables, which are used in 4 d...

Subgroup analysis using Metan command

Dear group, Stata novice here trying to create meta-analysis forest plots using Stata. I am really struggling to figure out how to do sub...

Confidence intervals for percent change

Dear all, This question might sound stupid but I can't find the way to calculate 95%CI for percent change between frequencies (but not...

A loop problem

Dear all: I have a problem when dealing with my data, for one variable. There is only "1","2", and "0", I wa...

Estimated parameters more than the observations

Hello everyone, I am writing my Bachelor's thesis. I am doing a time series analysis and using a VECM model. I have noticed that the ...

Unbalanced covariates when the treatment variable has 3 levels

Hello, I have performed covariate balancing test and after seeing the result I am confused. Could you please suggest me how to correct the u...

Looping with paired values but not for every variable

Hi, let's say I want to create a series of dummy variables as follows: Code: order work_deg_sector*,sequential egen dummy1_1970 = an...

"[" invalid command name error while running simple linear regression in STATA

Hi, I am trying to run the linear regression command (reg dep independent variables) in STATA but apparently, it gives an error when I exe...

bar graph

Dear All, Suppose that I have this data set: Code: * Example generated by -dataex-. For more info, type help dataex clear input str63 Jour...

type mismatch error in declaring a function of a class

Dear Statalist, I have one question regarding the mata programming. I couldn't figure out why mata reports an error " type mismat...

traj plugin

Dear all I would like to run group based trajectory modelling in STATA. Please advise how I can download this plugin and install in a VDI....

Modeling a skewed categorical (ordinal) variable

Hi Statalist, The response scale of my dependent variable is structured as "Not at all" "To a small extent" "To a...

Generate data set using cross tabulation cell frequency

Dear all, Is it possible to generate data set include two variable using cross tabulation cell frequency exposed unexposed Total c...

realise a(n)=a(n-1)*b(n) in stata

Dear all: Sorry for bothering you. I have a problem when I use stata, could you give me some adive? So, I am using time series data, tr an...

How to extract selected features from LASSO in stata

Hi, I have somewhat of a basic question. I am running the lasso linear command and wanted to use that to extract the selected variables an...

Help Extracting Year from Date

Hello everyone, I'm brand new to learning STATA, so I apologize if I am omitting any pertinent information. I have looked through previo...

Logical operation using generate

I have a database with three variables: 27 states, 10 years and a GDP for each year. I want to generate a variable with the resulting logica...

Logic operations with generate

I have a database with three variables: 27 states, 10 years and a GDP for each year. I want to generate a variable with the resulting logica...

Quade's test (non-parametric ANCOVA)

Hello Stata users I wondered if you could inform me whether STATA performs the nonparametric ANCOVA test (i.e., Quade's test). I checke...

Identifying the first & last non-missing AdjClose (i.e. observation) by year for each group

I have 1200 companies that are identified by CIQ_IDs. I also have an id variable within each CIQ_ID, which are numbered 1 through approximat...

How to collate multiple, individual regression outputs

Looking for some help on the following: I want to tabulate the univariate association of 8 variables (v1-v8) with an outcome (outcome). F...

How to Mark the Demoted Students Out in Long Format Data in Stata?

Hello, Folks, I have a small dataset like this, clear input byte (id year gr kg5 k68 k912) 1 1 0 0 0 0 1 2 1 0 0 0 1 3 2 0 0 0 1 4 3 ...

Misleading median?

Hi everyone! I'm doing research on how real estate values impact corporate savings. I have computed all the variables however I notice...

First difference of a squared term

Dear all, I am working with a panel dataset and am trying to run a non-linear (quadratic) regression using the first difference operator (...

Store significant variables in Logistic Regression

Hi, I am running a logistic regression with about 30 variables, most of which are categorical variables, and I would like to run a command...

need to count experiences of employee with respect to year

Hi experts I want to count the experiences of employees (i.e., personalID), with respect to years such as if they worked in 2001 with compa...

estout: what is the stats label for LR chi2 in logistic regression

I run a logistic regression and would like to print out LR Chi2 statistics using Code: estout Code: eststo: quietly logit y x1 x2 Cod...

intercation term same value as main variable

Dear all, Since I think it is more appropriate to ask this question in a different topic, I created a new topic. I was wondering what it ...

Bootstrap local projections impulse responses/historical decompositions

Dear Statalisters, I am trying to bootstrap the impulse response function that I obtain from a local projection. The tricky bit is that th...

Multinomial Logit and estout

I am using estout (SSC) on Stata 16.1 to tabulate the results of a multinomial logit regression. I would like to label each column with the ...

Loading user table to ICIO for GVC analyses

Hi, I am using the long-run WIOD table for GVC analysis using the STATA command icio. One needs to load the IO table using the icio_load ...

Calling in SQL through ODBC--String variables & choosing data

Hello Statalist , I am using Stata 17 on Windows. I am new to the ODBC process and I am trying to call in a large dataset from SQL. The da...

Does anyone know a clever way to add R2 to "graph twoway lfit"?

I am using the below code to fit a linear regression line, Private_Hospital is a binary variable graph twoway lfit Private_Hospital_1 Diff...

Return how many variables were overwritten (because they had the same name) in a merge?

If I merge two datasets and two variables in the datasets had the same name, how can I get Stata to tell me how many variables (and which) w...

Ordering Multiples variables

I am having a dataset in wide format for almost 80 years for 100 countries for about 200 variables. Variables bring the 3-letter ISO country...

Help with selecting type of ANOVA

Hello statalisters, I am trying to perform an analysis on a dataset that contains information on patient values (r2-r4) from 4 different t...

Calculation of Blau Index / Simpson Index

Hello everyone! I am trying to analyze the degree of national and gender diversity of TMTs of german companies over a period of 10 years. ...

expand data

Dear Stata users, I have a panel database of countries observed on a yearly basis from 2004 to 2018, I want to expand the observations to ...

treatment turns on and off

Hello everyone, I hope you are very well, I have some monthly panel data at the state level, in this database I have a type of treatment t...

How to convert my FE-IV model (with intuitions borrowed from the RDD literature) into STATA language - Is IVREGHDFE the one?

Hello dear stata friends! I am having some confusion regarding the implementation of my I ndividual-Fixed Effects IV Design in Stata. This...