Is it correct to interpret the sign of statistically non-signifcant coefficient?

Dear Members This question turns to be somewhat foolish or trivial for many in this forum, but I think a clear cut answer if it all possib...

Bar graph of proportion over the years

I have two questions to clarify. First question is how to show the proportion using graph bar, if the only commands available are mean med...

skewed-Normal GARCH Estimation Using ml command.

Dear Statalist, I'm trying to generate conditional skewness and kurtosis by using Gram-Charlier Expansion Series. Essentially, I'm...

Split a string variable into character and numeric parts

Hi, I have a string variable (profile) in my dataset which includes prefixes of H, W, B and the suffix numbers ranging from 1 to 1000 (H1, ...

Change reference category of dependent variable

Hi, I am running the following code mlogit cq25 i.group [pweight = cq25pp], rrr The dependent variable has three levels. It all works ...

How to identify oldest children with highest education?

Dear all, I have a household data and I want to generate a variable indicating year of birth of a child with the highest educational level...

Identifying partial name overlap in string variables

Hi. I have two datasets with the variable “Product”, the name of different pharma drugs. I am trying to merge the two datasets by name. Howe...

Graphing a multilevel model with interaction effect

Hi all! I'm looking for suggestions on how to graph a multilevel model I'm working on. I'm working with some covariates whic...

Using the new table collect row percentages for multiple factor variables

Hi all, I recently attended the webinar on customizable tables in Stata 17. One of the sample tables used in the webinar, as shown below i...

average log size in panel data

Hello, I have a random effects model with clustered errors and I would like to add the log size to the model. When I generate the log and ...

Dropping string observations starting with a number

Hi. I have the following data and want to delete all observations where the Product starts with a number. The Product variable is a string v...

I got different result from xtreg and eventdd

Hello, I have unbalanced panel data, the DV is shortage, and the Independent variable civica_status that takes 0 before the event and 1 aft...

Using omega squared after regression

Dear Forum, Can I use omega squared after regression to determine effect size if my independent variables of interest are quantitative? Th...

Regression insignificant after adding industry fixed effects

Hello, I am new to this forum and i am currently writing a MSc thesis for finance. I am researching the effect of CEO overconfidence on t...

How to convert date variable to year group?

I am given a list of date variables in dd/mm/yy and I would like to sort the variables out in the form of grouping them together by the spec...

Need help with constraint dropped when testing for equality coefficients and joint significance of two variables

Hi all, Currently, I'm doing a multiple regression, with the totalcases as the dependent variable, while other 6 variables ( border, ...

Reshaping and keeping labels

Hello! As context, I'm estimating several regressions with around 900 parameters. I need to save around 400 of them (the ones that are ...

Help needed Pearsons R table for Categorical Independent variables

Hi All, I am trying to create a Pearson's correlation table in Stata. The experiment looks at Independent variable (respondents being...

Line graph (mean) with panel data

Hey Stata community, I tried to plot something using a panel data set and the " line " command (sales over time from 20 differe...

Non-parametric correlation test between dichotomous variable and continuous one

Dear Statalist. I have a small sample of countries. I have two variables, X which is a continuous variable, and Y which is a dichotomous o...

How to create a variable from values of other members of a group?

Dear all, I am analysing an unbalanced panel dataset that is similar to the following example: Code: * Example generated by -dataex-. ...

predicted probability meaning

Hi All, I appologies for asking this very basic question. Part of my PhD research, I have calculated the predicted probabilities by callin...

Kakwani index Standard errors

Hi, I want to know how to obtain Kakwani index Standard errors, where Kakwani index is the concentration of health care payments minus the...

Reshaping from wide to long and keeping the label

Hello everyone, I want to reshape my dataset from wide to long format and keep the label information as a new variable. This is what my ...

ITSA command - stationarity

Hello all, I am using the -itsa- command for a time series regression with covariates. My time series are a mixture of I(0) and I(1), i.e....

Time invariant variables in hybrid model

Dear all, I am studying on the determinants of labour productivity and I am using the hybrid model. First of all, I chose growth rate of...

Renaming every 3 variable

Hi, I am trying to rename every three variable in my dataset such that the first three variable X1 X2 X3 read HH-W-X1 HH-B-X2 HH-H-X3. Also...

Creating an IF or Conditional command

Hi All, It is my first time in this forum and I'm hoping you will be able to assist me. My study is on Adolescence Obesity and I hav...

Lee bounds with multiple treatment group

Hi, I'm working with a dataset with high attrition rate and am considering using Lee bounds to estimate the treatment effect. Below is...

Merge Panel Data with multiple same year dataset

Hi All, I am trying to merge two datasets. One is a firm ID -year (panel master data). The other dataset (hereafter ECHO dataset) is from ...

Interpretation of a linear (percentage) - log regression model

To provide context, I am running a fixed effects regression model, assessing the relationship between the percent an organization spends on ...

Problem with Survey data analysis, non-response, selection bias, use of paradata

Hi Statalisters, Greetings from Inddi I am analysing a survey data and I am relatively new to this commonly used study design. I am seekin...

Cross section Panel data for exam - elections across 23 countries

Hi all. I appear to be in deep, so hoping anyone can help. Im doing an exam in quantative methods. For this exam I want to study the effec...

Assigning Values of Variable for All Panels

Hi all, I have tried finding a post already discussing this issue but have not found any; apologies in advance if one exists Here is my ...

Putexcel with row and column name labels

I am trying to export tables from stata to word using putexcel, where the row and column variables have value labels. However, after using t...

"No observations" problem

Hello, I have a problem when generating new variables out of existing one. I have a variable "pclass" having 1310 observations w...

analyzes of companies accounts

I am trying to make an analysis of all danish companies accounting for some years. Do any one have made and publish a accounting analysis fo...

Defining varlists for temporary variables

I'm stumped on how to create a varlist vt that contains the temporary variables Code: `_ty1' `_ty2' `_ty3' that are defi...

ivreghdfe runs a long time after convergence

Hello everyone. I am performing an IV-Regression with multiple fixed effects. My dataset contains about 20 million observations, with a si...

Power calculation Cox regression one cohort multiple vars

Hi there! I am doing a cohort study (1 group) with cancer patients for which I made a Cox model with 6 significant predictor variables (a ...

Variable gets omitted

Dear Forum, I have the following command: Code: reg birthrate ibn.incomegroup, noconstant Now I want to add an interaction to the reg...

identifying the predictors of Cataract progressions

Dear Researchers, I have asked this question before, but it seems that I didn’t get the answer so far, and this is because the way that I ...

Drop embedded observations

Hello, I have a household panel dataset with some observations being fully captured by other observations. Households can split off over ti...

Clarification on merge command

I am trying to merge two dataset- one dta file consist of 8576 unique observation and another dta file consist of 1187 unique id and 1220 ob...

How to analyze data for repeated measures?

Hi everyone Could you please share your recommendations, regarding the questions at the end of this post? Research objectives: 1. What i...