Rename variables to remove part of the text

Dear Statalists, I have the following variables and would like to rename them to remove untitled### from the name. Please help me do this....

Betareg

Hi all, I have a propotion dependent variable that’s greater than zero and less then one. The mean is 0.1240891 and SD 0.1363 and its posi...

ivreg, ivprobit and biprobit which one to use? (any theoretical reasoning?)

As I do not have any econometric background I find it difficult to understand which one to use when outcomes differ a lot. My dependent (fem...

Question spmap

Hi, I have a question about spmap. I'm just a beginner with STATA and I want to know how to use spmap for dummy variables. In my exam...

renaming using loop

Code: * Example generated by -dataex-. To install: ssc install dataex clear input str43 Q2_8a1 double(Q2_8b1 Q2_8c1 Q2_8d1 Q2_8e1) str43 ...

creating a variable that takes a value of the difference of the last non-missing value and the first non-missing value in panel data

i have panel time series. I want to create a variable that is the difference between the last non-missing value and the first non-missing v...

Binscatter2 - faster, enhanced binned scatterplots in Stata

Hi all, I wanted to make note of a program that I've had available on GitHub for a while now to generate binned scatterplots in Stata,...

How does one put formatted date labels into excel with Putexcel?*

Hi there, Here's my code: local vars "date" foreach pre in `vars'{ putexcel set "tabout/cleaningtest_`pre...

Extracting a specific part of a string if the string contains an exact syntax

OK, so I'm not explaining this very well but here is what I want to do. I have data as shown below. The incentive has a maximum of ...

Proportional odd assumption for ordered logit regression in panel data

Respected sir, I am using xtologit command for ordered logit regression for panel data. My dependent variable has three categories. I want t...

How to solve autocorrelation and hetero ?

I using xtserial and xttest3 What should I do to deal with autocorrelation and hetero ? My data have 9 countries and 10-40 quarters ( T ...

a new variable based on two existing variables

Hi, I'm using SHARE dataset where there is a dummy variable for people having played chess/cards in the previous year (ac035d10) and a...

Simple loop question

Dear Listers, I would like to ask you a very simple question regarding loop. I want to make a variable for each of countries listed in m...

How to recode data with multiple groups

Hi Everyone, I am fairly new to stata and I am looking at cancer data. I have histology groupings for lung cancer. The groups all over the...

dummy for panel data

Hi, how to create dummy variable for panel data? I want to create a dummy for 130 districts for 3 years; 2010, 2012 and 2014. If the distri...

Issues with Hausman-Wu test

Hi everyone, I am having issues with running a Hausman-Wu test. The output is as follows: " hausman fe re Note: the rank of the d...

Local macro list and tuples

I am in need of two different tuples lists, so I would like to store one set as a local and call the other in a different loop. Below is t...

Help on modelling- endogeneity-panel data

Hello, I am running a model to find the effect of corurption on GDP in across Italian regions using panel data. I have found endogeneity b...

Joining datasets when a variable is in a different format

Hi all, I currently have a data set that looks like this where each quarter is represented by a seperate variable and contains values of t...

Report estimates from Heckman AND margins command

Dear all, I am using Stata 14 and have some questions regarding the commands -Heckman-, -margins- and -outreg2-. I am trying to produce t...

Help with reshape

Hello everyone, I have got the following matrix. * Example generated by -dataex-. To install: ssc install dataex clear input int(isin ...

reshape in Stata

Dear All, I have some issues about reshape. Here is the original matrix I have. Code: * Example generated by -dataex-. To install: ssc i...

Question about Goodness of fit result

Hi, I am running a SEM model on Stata. I've 5 IVs, 1 mediator, and DV. with the sample size of 400. And I obtained this result, do you ...

VISUA Dialog programming GUI

I have seen the presentation on the below link, they have used a VISUA GUI for creating Stata Dialog boxes and survey plugin for data entry....

Converting string to date/time variables fails somehow

Hello Statalist community, I am struggeling with converting a string containing date and time information inti SIF/HRF. It seems that the se...

Problem with importing excel on new MacBook

Hi, I recently started working on a new MacBook from my old MacBook (i.e. I transferred all files, and am now using the new MacBook, Stata...

Problem with graph combine

Hello, I am trying to combine some graphs. I generate the graphs and save them into a folder. When I try to combine them Stata returns erro...

Time Series Regression

Hello, I am looking at logreturns of two different stock market indices in two countries and seeing if the weather (Cloud, temp, humidity,...

Garch model regression

Hello, I am looking at logreturns of two different stock market indices in two countries and seeing if the weather (Cloud, temp, humidity,...

How to destring date variable formatted as year and week number

Dear Statalist, I was just wondering if there is an easy way to destring a date variable formatted as "year and week number". f...

IVREG LIML yields zero cefficients and p-value=1.

I am using Stata to run "IVREG LIML" which is an IV with Limited Maximum Likelihood estimator. However, some of the coefficients a...

Page break in PDF output

I need to put page breaks in PDF strategically to keep certain lines of text together on the same page. Is there any way to measure the ...

importing multiple excel files using a loop

Hi statalists, I have the following code but I always get the error message local dpto AMAZONAS ANCASH APURIMAC foreach x in local dpto {...

How to get the quintile points in survey data?

I am using a survey data now and trying very hard to figure out the quintile points (20%, 40%, 60%, 80%) of a continuous variable. I know t...

Is it possible to test coefficient estimates across two samples using GMM model?

Dear All, I run the same GMM model in two different samples (firms which have high imported input vs low imported input). I would like to ...

Analysis for two continuous variables (not normally distributed)

Dear Statlist, I have two continuous variables, the dependent variable is not normally distributed while the independent variable is norma...

Average Partial Effects (APE) after Dynamic Probit Model ala (Wooldridge, 2005)

I am trying to calculate the average partial effects of the state dependence and some other covariates after running a dynamic probit model....

Bysort

Hello, I have reproduced a simple replica of a bigger problem. I have data which looks as attached. I need, the value against HS 3201 as...

Struggling with Collinearity in Panel Data

Hi, I am struggling with how to set up my regression robustness check. I am currently running a regression of recycling rates on income, p...

Problems with Nesting in Panel Regression "panels are not nested within clusters"

Hi, I am not sure how to overcome this error message I am receiving "panels are not nested within clusters". The code I am tryin...

problema with local extended_fcn local list : dir . files "*"

Hello everyone. this is my first post in Statalist, so please forgive any mistake on it. I'm trying to capture the filenames of seve...

Replace missing observations in VAR1 with observations from VAR2 f

Dear forum, I am trying to replace the missing observation(s) in ExportMarkets with the value in MirrorExportMarkets. May I ask what the c...

Exporting underlying data behind stata generated graphs

Hi, i was able to export the underlying data behind a graph i created using a dataset (below) but when i do, i only get the mediam values a...

How to compare prognostic models with a survivaldecision curve analysis for survival outcomes?

Hello, i am currently using the dca (stdca) command in stata 14.0 I research a dataset of patients with a prognostic marker and would like...

Subpop MLM: Xtmixed

Hi all, I am running a multi-level modeling using complex survey data, which used a stratified, clustered, and unequally sampling design. ...

Sample selection in the control function approach

I am trying to understand what sample it is correct to use when estimating the models using the control function (CF) approach. Below, I exp...

Can't open miest.ster

Dear Statalist, I am trying do run a Cox regression on an imputed dataset using restricted cubic splines. I used the following code (the d...

lower what does mean?

hi friends. please help me to understand this code. what does mean lower? gen cityname2=lower(cityofprop)+", "+ lower(stateofprop...

Adding missing values in a varlist

Hi, In my data set answers below zero each show a different type of missing value (e.g. not answered or not asked etc. from -1 to -10) and...

Endogenous binary regressor in multinomial logit model

Hello forum members, i do have a multinomial logit model where one binary explanatory variable is endogenous (EEV). I am aware of solution...

Help with event study on the impact of Hurricane Harvey on the US stock market using SP500 company data

Dear Reader, I would like some help with a study I am doing at University. I have downloaded data regarding stock prices for companies loc...

Bootstrap after two stage probit

Dear all, I was using ivprobit but it seems there is a problem with the margins command when I want to get average marginal effects. It giv...

Hypothesis Testing on coefficients

Hi I am interested in testing the hypothesis highlighted in the picture. Ho: gamma>=beta and Ha: gamma<beta Is there a way in stat...

Identifying units of analysis in STATA

Hi, I'm starting a master thesis and am very new to STATA with very little experience. I am looking at innovation in various technologie...

log using

hi friends. i am run this code but faced with error.although it is run without error yesterday, i am confused please help me code: log us...

Plotting categorical variables

Hi all, can any of you tel me how I can get ht below graph? My rep variable is life satisfaction and the independent include - marital s...