generate a dummy varaible based on whetehr the other dummy has the same or more ==1 than ==0 over the sample period

Hello I have a panel data with firm and year variables. I also have a dummy variable, litigation, which equals 1 if there are 1 or more li...

Random sampling according to group in Stata

Hi everyone, I have a question about how to randomly sample data in Stata according to specific groups. Below is my data structure: I wa...

Asreg

When I run the following code webuse grunfeld, clear bys company: asreg invest mvalue kstock, fmb newey(2) I get the following results ...

Loop function

Hello, I want to generate following: gen capm1 = rmrf if decile == 1 and this 10x times, basically until gen capm10 = rmrf if decile ==...

Logit odds ratio

I am using xtlogit and have a simple model that performs as we might wish. But the odds ratio for one x variable is 186.8 which seems imposs...

Parameter estimates scaled by SD

Hello Forum, Does anybody has an idea how to approach to get parameter estimates scaled by the standard deviation of an underlying variabl...

grouping dimensions with borders

I want horizontal lines separating my the levels of my first dimension. I can almost obtain this using by adding the option "spacer...

Tabulation based on multiple categorical variables

I am using Stata 17 and I’d like to produce a frequency table ( tabulate one way ) based on multiple variables that have been manually enc...

Quarter Averages to Yearly Averages

Hello, Code: * Example generated by -dataex-. For more info, type help dataex clear input float(fundnr month year q_mf_expratio) 1 7 20...

From monthly to yearly in %

Hello! Code: * Example generated by -dataex-. For more info, type help dataex clear input float(fundnr month year mf_m_cf) 1 7 2011 ...

Time series dummy variable

Hi all, I am trying to make a time-series line plot for employment as a dummy variable (called "lfs", where 1="employed...

Ordinal independent variable treated as continuous & marginal effects in ordinal logistic regression

Hello, I am an economics student doing an undergraduate empirical dissertation using data from the European Working Conditions Survey, whe...

complex tag - I think

Hello, below is a case where a person has 2 rows of data and and 2 different values for the variable lx_item_id_rc on the same date (dos_rc)...

No Observation Error with correlation

Hi everyone, I'm very new to Stata and I am very confused my this error. I have created two variables to describe flights from differen...

Lag length in panel data

Dear Statalisters, I have an unbalanced panel and was looking for a way to determine optimal lag length in panels. ​​​ I run Fisher-type...

Missing data

I am looking to analyze missing data so I tried with command mdesc and summ but it came back with no missing data. When I tried codebook it ...

Importing multiple excel worksheets using a loop

Hello everyone, I have a single excel file that has multiple worksheets, the worksheets are named Country 1, Country 2, Country 3 etc. I w...

Error message when conducting Heckman correlation test

Dear all, I am trying to use the Heckman correlation test to investigate the possibility of a selection bias in my data. I have panel data...

Seeking advice on how to accurately calculate marginal effects after multivariate probit regression

Dear statalist users, Hope you all are doing well. I used Stata/MP 14.0 to run a multivariate probit model which has three binary dependen...

Variable labels lost due to reshape

Hello, I have a dataset (first example below) that I reshape from wide to long. However I lost of the label information. How can I keep the...

Pearson's Chi-Squared Test - Requesting help with tab2

I am currently working on an extension for research that requires me to measure whether the allocation of patents to examiners are random. I...

Merging multiple .tex files: How to sort the individual files?

I am outputting a lot of tex tables as raw files and then merge them into one ordered tex document using an automated procedure. The code be...

scatterplot

I would like to do several scatterplots were I plot the correlation btw mortality and covid-cases and were I would like to identify the trea...

Missing Time-Series Data

Hi Statalist, I have a time series dataset of ozone data for multiple different counties. It has quite a bit of missing data, sometimes se...

LSDVC method

After regressions with LSDVC method stata indicates bootsraps error. I want to know what is differnce between Bootstraps and error standard?...

Ytitle with euro sign does not display horizontally

Despite putting angle(0) the title will not be displayed horizontally. Since this only happens for the title but not the label, I presume it...

Generating random variables based on some predefined correlations

Dear Stata Members I would like to ask a few questions and clear some doubts regarding regressions but for that, I need to create some rand...

Export Word putdocx

Hi I have not had Stata for too long and am trying to create a Word export from Stata. Unfortunately, Stata rounds down or up my data whe...

What should the command be?

I would like to ask about the exact command. Assume yt= (infla t, unrate t, hwages t）is(3×1)-vector, in order to estimate the order of the ...

How can I recode the variable in this long format data set with Stata?

I want to create a new variable "signal" in this long format data set. The rule is set below, if all status values equal 1 within...

Wooldridge Introductory Econometrics 6th Edition CH13 C16 Qvi and Qvii.

Hi, I am currently solving the question from Wooldridge, the question is as follow: Array The link for the data is: https://s2.smu.edu/t...

Create a Dummy indicating country pair has appeared previously in different variable

Code: * Example generated by -dataex-. For more info, type help dataex clear input float(Year country_pair2 BIT_pair) 1993 4447 1 1999 25...

Taking strings out of file names

I scraped together some xls files using the almighty Python. Before I can/want to work with these files I must rename them, because this cod...

Amazon McKinsey 7S Model

Amazon McKinsey 7S model illustrates the ways in which seven key elements of businesses can be united to increase effectiveness. According t...

Imputing missing state-years using average of surrounding years

Hello, I have a state-year panel dataset, which is mostly balanced except for one missing year in Wisconsin (1998) and two missing years i...

How can I use pweight by hand?

Dear statalists: I want to use a mirco sampling data in R,but the package used in R is systemfit which doesn't support sampling weight(...

All Dates on Data Editor Coming Up as .

Hello! Currently new to operating STATA. My Data Editor does not show any dates despite me having dates put in on my REDCap. All dates app...

Estimating the modified Jones model by industry and year using panel data

Hi all. I'm studying the relationship between restatements and firms' earnings management behaviour. I'm using DA to capture suc...

Combined new variable: code MV from other variables

I would like to create a variable in which I code 1 if a certain threshold in several other indicators is met. 0 only if the threshold is no...

Singleton dummy variable (possible problem)

Dear all, I am running a couple of regressions with country and year fixed effects. But, in some regressions, when I include dummies for c...

Calculando o coeficiente de Gini

Boa tarde pessoal, estou tentando calcular o índice de gini para alguns setores da economia, identificados de 1 a 5. Busquei em alguns fórun...

export spatial weight matrix

Hi, I'm exploiting district-level unbalanced panel data. I used the following command to generate a weight matrix w HTML Code: spw...

Event Study Graph: Do I need an indicator variable for each pre and post treatment period (except t-1)?

Code: * Example generated by -dataex-. For more info, type help dataex clear input float(id monthly independent sales TreatZero lead2 lea...

How to Count the Number of the Students Having Grade Retention in a Dataset in Stata Code?

As the title suggested, I would like to count the number of the students who had grade retention in K-12 system. For example, I want to know...

Reshape wide to long - dataset

Hello, I need to organize my data and convert it from wide to long. Since I have to many variables I use the command "set maxvar 3276...

Long data? Help. New to Stata

Hi. I am new to Stata, and coming back to data analysis after 20 years since my undergraduate. I am sure that this is a simple fix, but ther...

Making a figure including confidence intervals for multiple groups

Dear Stata-users, As I was working on my thesis, I was wondering about the following. I have made two figures with confidence intervals fo...