Contract year reshape

Dear Statalists, Hope all is well. I am dealing with the contract data with specific contract start and end years as shown below: ...

Removing duplicates

Hi, I have a dataset which i want to be uniques with the variables gvkey, fyear and loc. But there are duplicates. Incase of duplicates, ...

dynamic looped regressions

Dear Stata colleagues: I am using LASSO for inference. I want to independently assess the causality of 40 policy variables on a rate. Some...

How to use xtcointtest with runby? OR How to do cointegration tests for each individuals separately for panel data?

Dear all: I'm trying to use xtcointtest to do cointegration tests for each individuals separately in panel data and store the results, ...

Renaming Matrix Rows With Spaces

Suppose I wish to rename the rows of a matrix. Code: clear * cls matrix A = (2,1\3,2) cls loc rn foreach i in "City God Temple...

Extracting All Strings After a Word within a Variable Name

I have a dataset representing a treated unit (GDP), a series of estimated counterfactuals, (cf) and pointwise treatment effects (diff_). Let...

Assigning value from one variable to another if condition is met

I have a data manipulation question: I have a dataset with the variables "id_1", "year", and "id_2." I would ...

Is it possible that log mis-calculates it or create weird ".b" when the workload is too heavy?

I use Stata 17 (24 cores). I am sorry that I cannot provide the reproducible example because this problem is really a problem of Stata gen...

Is it possible that log mis-calculates it or create weird ".b" when the workload is too heavy?

I use Stata 17 (24 cores). I am sorry that I cannot provide the reproducible example because this problem is really a problem of Stata gen...

Determining level of significance between two median and between two catergorial variables, pre and post treatment

Dear Stata community, I was wondering if anybody could help me with the following question. I am trying to figure out how to determine two...

Create graphs

Dear all, I have a dataset that contains the following string variables: "country" and "countrydestination". The first...

having issues plotting stock returns in panel data

Dear statalist, i am trying to plot the stock return data for a panel data of some companies, however, each time i plot this, but each time ...

Average marginal effects of continuous variables by levels of a dichotomous variable

Hi, I run this four-way interaction model in Stata 14: xtreg Y c.X1##c.X2##c.X3##X4 Controls i.country i.year,r Then, I want to get th...

general time trend

Hi, we have a problem incorporating a general time trend in our panel data with year fixed and country fixed effects. The defendant variable...

Meta-analysis help: how to convert hazard ratio to risk ratio

I am working on a meta-analysis using Stata. All the primary studies report risk ratio except one study that reported hazard ratio. Is there...

Downloading data from Public API from json format to csv file or txt file so that I can read data in stata on macOS

I have to download the following data from Business Dynamics Statistics ( which is public data provided by census bureau ) from the followin...

kappaetc / Krippendorff's alpha with missing values and across multiple variables

My research team coded/classified a large set of documents. I took a random subset of 1000 from the coded docs to code and check the reliabi...

Contrast tables

Hi all, New Statalist user here with a simple question (I'm a long time Stata user who is trying to learn to use tables). I am trying ...

Panel data: Creating a bilateral dataset with countries and years (replicating the dataset for each panel)

Hi everyone, I have a panel dataset of exchange rate with 200 countries and 16 years, please find below an example: country_origin yea...

Estimating risk difference for binary outcome in cluster RCT

I am analysing data from a cluster RCT looking at the effect of an intervention (int) in health centres (centre) to reduce inappropriate ant...

Balance an unbalanced dataset

Hi all, I have a strongly unbalanced dataset of countries observed by year. I would like to balance it by retaining as many observations ...

Weekly means

Hello Everyone!! I need to obtain weekly means for some measurements. I need a weekly mean by subject and week for each of them. I'm no...

Replace missing values with values from other observations

Hello, I´m stucked with my data cleaning. Below, a excerpt of my dataset is shown. I only have included data from one gvkey code, but in t...

Using matching with DID for repeated cross sectional data

I am new to STATA and working on repeated cross-sectional data for Difference-in-Difference analysis. I have treatment and control groups be...

Add on consecutively by group

Hi all, I have the first observation for each id for experience, and I would like to replace the value of experience +1 for the next year...

Example of GMM moment-evaluator program with many equations

Hi, Statalist, Does anybody know a simple example of how to implement the moment-evaluator program version of GMM with more than one equat...

testing the validy of the instrument in xtivreg

Hi, I am using xtivreg , where xtivreg y (x=z) The issue is that how can i tell that the instrument z is a valid instrument? I don'...

how to know whether a placebo test is passed

Hello! I'm conducting a placebo test on a staggered DID, I randomly assign treatment firms and policy year to my sample firms, repeat ...

Something wrong with -colorpalette-

Dear Stata users, I have installed the -colorpalette- wrote by Ben Jann , and I remenber that it run successfully before. I run it today b...

Avergaing values of variables to reduce survey observations

Hi, I am looking for a solution to average the survey respones. Below S007 is suvey respondent ID, loc is country name and fyear is the y...

Stata for loop error

Hi, I am trying to run the below loop in stata. But i get an error. Can someone help me. I am a beginner in using Stata. The variables...

Interpreting significant interaction effect while main effect is insignificant

Hi! I am investigating the effect of balanced ambidexterity and combined ambidexterity on firm performance, with moderating variables envi...

Dealing with missing data after using business date for daily stock return

Dear distinguished Prof, I have daily data on stock price of 15 companies, I want to calculate daily stock price for each companies in line...

Year and Industry dummies with GEE

Hello everyone, I have an urgent problem. I am investigating the implications of CEO´s political ideology and Corporate Strategic Change u...

How to run a regression excluding certain countries ids

Dear all I am trying to run a regression excluding certain countries that don’t require disclosure. I have used this code: reg xy if coun...

How to run a regression excluding certain countries ids

Dear all I am trying to run a regression excluding certain countries that don’t require disclosure. I have used this code: reg xy if coun...

Manage dates with different digits

Dear Stata users, I'm using the Stata 17 MP and want to manipulate dates with different digits (see below). In the first row, for in...

Percentage problem regarding loss and networth

Hello all I am using a definition to create a dummy variable. If the accumulated loss of the year is more than 50% of the previous four ...

Merge Datasets with multiple observations for one year

Hello everybody, I am currently trying to merge two datasets. One Dataset (Platforms) contains the annual traffic of a company and the oth...

Command likes -fbar- that simultaneously show frequencies or percents of categorical variables

Dear Stata users, The bar plot is frequently used in daily practice. Suppose that I have several categorical variables in my dataset, and I...

Comparing two groups of variables with each others

Hi all, first of all, I would like to wish you happy holidays. I have a question about comparing two groups with each other. Just to outli...

Omitted variable (log) in a panel data with FE in Stata 16.1

Dear Statalisters, My analysis is about finding to what extent government expenditures determine income inequality in an unbalanced panel ...