how to change capital letters in all variable names into small letters?

I have 1300 variables, and all the variables contain capital letters in their names. I want all of them to be small letters? How to do that?...

Gen match =_n1 replace match = _id if match ==. How can you have missing value ??

Richard Hofler can you help? As I believe you were the author of this code re post 5 on here https://www.statalist.org/forums/for...score-...

Panel Data Logged Differences Help!!

Hello thank you!! I'm doing a research project on whether or not individual CEO campaign contributions affects their 6 month average sto...

ivreg2-weak instrument robust inference

Dear All, I was a bit confused about the validity of estimates after ivreg2. If the Kleibergen-Paap rk LM statistic and Kleibergen-Paap rk...

Dropping observations after the first time the treatment turns off

Hello, I need some help finding a solution to the following problem: I want to drop all the observations that occur at and after the first...

EFA-Factor Analysis

Hello, I have survey data where five main factors and each factor has a set of questions. As we know a number of factors I applied EFA ove...

Intuition on why Fixed-effects models depend on there being variation within the unit of analysis.

I am new to econometrics and tried to find the answer on google, but couldn't find any. I've learned that Fixed-effects models depen...

how to calculate the moving average for a variable

Dear all I am trying to calculate the average bond maturity over the preceding three months as an instrumental variable in my analysis. it...

Ask experts for help：how to set the prior of regression coefficients that follow dirichlet distribution in bayes model

Hello, statistics experts, I have a question that troubles me for long time. My purpose to estimate the joint effect of air pollution on t...

Doubt with daily dates and x-axis

Greetings, I am working with a database and I have two doubts: 1) is there any way that in the x-axis I can only show the year (leaving ...

multiply vectors; dot product

This is probably very easy, but I don't know how to do it. 1) If part1, part2, part3 in the example below are a vector, I need the dot...

Removing Compound Quotes in Local Macro

I am using levelsof to feed a list of ISO-3 country codes into wbopendata to query countries' GDP from the World Bank. wbopendata requir...

No observation error when creating new variables

Dear Stata users! I am having a problem and looking forward to your help. You can see one part of my data set as below. I am using nested ...

Marginal Effects after Firthlogit

Dear Statalists, I have used mfx command after estimating firthlogit model, and the predicted Y shows negative (-1.199). The results are g...

Panel Regression Help!!

Hi all!! Firstly, thank you for reading/helping! I'm attempting a project on looking at CEO personal campaign contributions before the...

How to estimate the trade creation and diversion effects with exporter-impoter-specific time trend?

Hello guys in Statalist! I have some problems with estimation on trade creation and diversion effects. I am using the command ppml_panel_s...

Panel Data Help! Creating a Change Variabel

Hello! This is my first post and very much in need of help with a project I've been working on for some time. I have a panel dataset for...

Replace values of string variables based on a fraction of my dataset

Hello. I'm using a mapping table linking a question ( varname ) to its short label ( label ) in a survey. Whenever the question refers t...

meglm

Hello All, I have two datasets, one with a binary outcome and the second with a count outcome. I have difficulty importing the two datase...

Descriptive statistics with imputed data base

Hi Statalisters, I am doing my Master's thesis with an imputed database. A doubt has arisen for me when trying to generate descriptive ...

Invalid Syntax r198

Hi everyone, I'm having issues with a couple of my recoding commands and wonder if you could help. I need to recode categorical vari...

Comparing Slopes

Hi there, In a trend analysis, I am looking at whether hours worked changed across 15 years. Then I am seeing whether hours worked differs...

Stratified cluster sampling

Hello everyone I have census data for 115 400 companies in a city. There are 24 municipalities in the city grouped into 4 districts. I i...

How to add an extra year to an existing dataset

Dear members I have a dataset spanning from 2005-2019 and I would like to add 2004 to the year variable by company_id to append the 2004 co...

Estadd local not working

Hello, I'm using Stata17MP on Windows 11. I'm trying to use estadd local but it's not working. In particular, I do not get an...

How to calculate Point Estimates in a regression

Dear All; Need your kind help. I have a file tea_data.csv (attached for reference). I generated the variable teaDum, which takes value 1 i...

help with Synthetic control

hello everyone. Ive compiled data on a large amount of countries to perform synthetic control. yesterday i was running synthetic control o...

Working with Stata dates

Hello, I would like to create a variable, called "outcome", measured as a dummy indicator equal to one if Plan B was implemented...

Help creating a bar graph over multiple variables

Greetings, When creating a graph bar and dividing it over a variable, I cant figure out a way to add in the same graph a bar for the whole ...

Trouble working with %tc dates

Hello, I have a variable "EndDate" whose format is double yet displays as if it was %tc. I need to identify the maximum date by ...

Loop

Hello fellow Stata users, I have a question regarding the forvalues loop, this is the first time I want to use it. I have a variable calle...

Meta proportion

Hi to everybody... after running the "metaprop" command if it is possible to write instead of "ES" "Proportion...

Regression of a few selected observations

I have a set of data but would only require to use of a few observations from the entire dataset. I was wondering if there is an easier way ...

Urgent: Multilevel moderated mediation

I need to estimate a multilevel moderated mediation model, but I can't find the right code for it. I was hoping someone can help me with...

Concordance, sensitivity, specificity

Hello, I have a very small data set with two diagnostic test data. One is an old test and gold standard and we want to test how good the n...

How can I Correctly Build the Fixed Effects Multinominal Logistic Regression Model with Panel Data?

Hello, I ran into difficulties when building fixed effects Multinominal Logistic Regression Model with Panel Data using Stata. The dataset...

) required

Hello, I am writing a code to plot a difference in differences, I have the following: twoway (scatter price_index Year if Treatment == 1, ...

WeWork Porter’s Five Forces Analysis

Porter’s Five Forces analytical framework developed by Michael Porter (1979)[1] represents five individual forces that shape an overall exte...

how to Import many excel files with multiple sheets and appending each sheet into one dta file for each file with the same excel file name

Hello everyone, I just joined Statalist. So this is my first post. I would like to give you a brief idea about what I want to do and the...

WeWork marketing communication mix

WeWork marketing communication mix comprises communication channels to communicate the marketing message to the target customer segment. The...

WeWork Marketing Mix (WeWork 7Ps of Marketing)

WeWork marketing mix (WeWork 7Ps of marketing) comprises elements of the marketing mix that consists of product, place, price, promotion, pr...

Is there any way to stop pyStata while running?

We know that both python and Stata have the stop-process capability, but it seems impossible to do that through pystata. For example, suppos...

Find matched firms

Hello everyone, Hope everything is going well. I have a question about how to identify the matched firm. The sample data is the followin...

Backward Compatibility .mlib-s Complied in v17

Hi All, Yesterday a user made an issue on the -domin- (SSC) package's GitHub page noting that they are getting an error that a Mata f...

Recoding

Hello, I have the variable gender which was originally coded as 1 = male and 2 = female. I went in and changed the code with the following...

Problem with storing regression estimates while using "scfcombo" package for Survey of Consumer Finance data

All, I am trying to neatly store and organize regression results in Stata 16.0 version. However, I am using Survey of Consumer Finance dat...

What kind of interpolating should I use?

I have a daily dataset with global aggregate numbers of an index and a monthly index of countries specifically. As the changes in the daily ...

Cleaning challenge blanks in variables

Hello when reshaping data, from long to wide, we wanted to make each row per director, and all the companies their associated with as diff...