gen dummy with missing data

Dear All, Suppose that I run the code Code: sysuse auto, clear gen d = (rep78 > 2) & !missing(rep78) i.e., d-=1, if rep78 ...

Tabulate two way by summarizing the sum

Hi Everyone, I have the following data on year (first dimension of panel) , market (second dimension of panel) and product code/type (thir...

Assigning colors to stacked bar plot with ordinal y-variable.

Dear Forum, I would like to plot a stacked bar graph of an "outcome" over hiv status (positive vs. negative) and stratified by s...

egen problem

Hi list, I want to generate a variable that equals the mean of the values of the first two nonmissing variables in a three-variable list (...

"Encode" a String with another String?

Hello: I am trying to create a long code list where var1 is a string and what it should represent is shown in var2, also a string. I then ...

Diff in diff: Fix data for one-to-one matching propensity score

I have a data set of companies with the date they were acquired by a business group and a control group in which the companies have been in ...

New to stata, Impossible problem for a summary table?

Hello all- I'm so glad I found this forum! I've just started working with stata for a biostats class. I've been given a problem ...

Maximum number of iterations exceeded

Hello, I hope you guys are doing well. I am estimating a model using panel ardl techniques, namely the dynamic fixed effect regressor. An...

Reshape Wide Issue

Hi, I have been trying to reshape my data from long to wide format using reshape wide. The data looks like this: OrganisationName AssetCla...

Calculating F-statistic after constrained regression

I have run this unconstrained regression *Model: lcost=ß_1+ß_2loutput+ ß_3plabor+ ß_4lcapital+ß_5lpfuel and would like to set the restric...

How to convert SIC codes into Fama French 12

Hello, I am a uni student and I'm terrible with computers. For a project that is due in a week, we are supposed to convert industry SIC ...

putdocx basic summary statistics

I am running Stata 17 SE. I would like to send the output of basic summary statistics commands, namely Code: summarize Code: tabulat...

Reshape dataset including variables names as an additional variable

Hello Statalist community, I don't have yet much experience using Stata and hope you can help me with a problem I am encountering. I...

xtunitroot error 'too many variables specified'

Good afternoon. The dataset looks like this: Code: * Example generated by -dataex-. For more info, type help dataex clear input long p...

Rename Variables using a loop

Good morning My problem is the following. I would like to rename my variables using a loop. My initial situation is this: I have a set o...

Losing a value after dropping duplicates

Hi everyone I need a general code to fill the remaining cells at "cvcie0" for the same "gvkey" and for the same "...

How to select optimal GMM model

Greetings, I am estimating several specifications for the macroeconomic determinants of non-performing loans using system GMM with xtabond...

Poisson regression

Hi everyone! this platform has been a great help for me. I would like to ask questions on Poison regression Background- i want to estimat...

Renaming date variables

Hello gang I'm trying to fix such that my date variable, specifically the one showing month, looks a little "cleaner". Initi...

Help - estout export to csv - a whole row is concentrated in one cell

Hi friends, I am trying to export a table to excel using estout. Instead of each value being put in a cell (="..."), for some of...

Collapse and generate average values

Dear, I want to collapse the years into periods of, say, two years each. For example, if I have a panel from 1990 to 1995, I want period I...

Robust Standard Errors how to get value for Wald Chi^2?

Hello everyone! I am running panel data regressions and am using the 'robust' command as I think my model has heteroskedasticity (...

egen, group

Dear All, Suppose that I have this data set (the original question is here ), Code: * Example generated by -dataex-. For more info, type h...

How to create an aggregate observational unit by adding values by country and year.

Hello, I have the following dataset for a number of countries. I would like to generate an aggregate entry (call it africa under variable ...

Finding Market Shares

Hi all, I have a data in the following format. I need to calculate the market share where market share would be simply percentage of sales...

group string var with random names

Hi, I have list of investor name which are not same like "investor group" var. I want to create a variable like investor group f...

ttesti equivalent of oneway ANOVA

Hi all, I need to compare means of a parameter of 8 groups (independent). I do have SD but I do not have individual data. I was wonderin...

repeated-measure vs. nested anova problems

I think I want to use Repeated-Measure Anova command, "anova, repeated ()" or "wsanova" commands based on the instructio...

Help with Recoding with Multiple Loops

Hello, I have a series of variables that looks like job[i]_sched[y]. [i] varies from 1 to 6. [y] varies from 1997 to 2017, but the last thre...

qq Plots

Hello everbody, I have estimated parameter alpha for each participant with six different methods. I wanted to plot each alpha of one metho...

svy:logit has more observations than simple logit command

I am working with survey data and use the svy command before running my logit regression as follows: svy: logit Y X1 X2. Running this comman...

addplot error after marginsplot

I ran a model ( dependent variable = gender) and 3 independent variables – year, position_department_n, and interaction of year and positio...

svy: mean and sorting estimated means

Greetings, Statalisters. I'm hoping this is something someone is willing and able to explain to me, since I've failed at figuring ...

Graph with Y axis as string

Hi everyone, I have data like below: 25 different methods that generate 25 different estiamtion on OR and its 95%CI. I want to generate a ...

Changing the value of many observations

Hello So, i'm working on a pretty big dataset for a Norwegian insurance company, and I wanted to change one variable in regards to its...

Get the standard error from --exlogistic-- command?

Hi all, I'm running the exlogistic command for meta-analysis, with id as study id: Code: exlogistic r id group, binomial(n) group(...

multilevel multinomial modelling using the gllamm command in stata

Good day everyone, I am using the gllamm command in stata 15.0 for multilevel (2-leveled) multinomial logistic regression. The outcome/depe...

Manually producing probabilites after logit

Dear All, I estimate a logit model and then I need to calculate Prob[Y=1|X], where X is my set of regressors. Obviously, I can use: Cod...

how many observations per year in panel data

Hi there, I have a panel dataset. How can I see how many observations there are per year? I see in the data viewer that some years have lo...

Eliminate a part of a string

Hello there, I would like to eliminate a part of a string starting from a position recorded in another variable for 2000 characters backwar...

How do you de-trend an event study plot?

I have an event study graph that I plot using coefficients from my dependent variable regressed on the leads and lags of treatment. There ap...

Setting the outcome variable in Cox regression.

Hi, I am trying to estimate the hazard ratios of the age of first drinking, the goal is to measure the risks of underage drinking (<18 ...

labsize in points generating strange result

Per the request of my publisher, I am going through a set of graphs and specifying text in point sizes. This has worked fine except in one c...

Where is the dta file for math scores of pupils in the third and fifth years from different schools in Inner London (Mortimore et al. 1988)

I apologize for asking this question because I assume I am missing something obvious. Many Stata examples use data from Mortimore et al. 198...

Error in dictionary file

I have a dataset in .txt, which I have to translate with a dictionary file. I have written the dictionary file according to instructions fro...

Elasticity analysis

Hi all, I am in urgent need to find the solution of a problem. It would be great if you guys could help background of the problem: I ha...

Assigning random number while using pre-defined observation specific probabilities (Result of an LCA) - using rdiscrete

Hello Statalist, As a result of an LCA I have three variables containing the probability of each observation to belong to a specific group...

Sum variables taking into account missing data

Hello, I have the following dataset: Code: * Example generated by -dataex-. To install: ssc install dataex clear input long gid int(co...

Error: <istmt>: 3499 ASREGFMB() not found

Good morning, I try to run the asreg command and I receive this error. I checked that the installation is correct that I have everything up...

Cmxtmixlogit discrete choice experiment with choice card blocks

Dear all, I am encountering a convergence problem with the 'cmxtmixlogit' command, using STATA 16.1 for windows. I performed a d...

zero-inflated and right-censored count data

Dear all statalists, Thank you for clicking on my post. What is the proper way to deal with zero-inflated and right-censored count data? ...

Number of splitvoters from two variables

I need to know the number of split voters in Denmark - those who did not vote for the same party at the general and the local election. An...

Panel data estimatioin

Hello. Need help with panel data estimation. I am working on panel data with T=96 and N=260. I used Hausman test and it gives FE an appropr...

converting dates (year and month)

Dear All, Is there a more concise way to go from date to newdate below? Thanks. Code: * Example generated by -dataex-. For more info, type...

alternative to keep if for a large list of firm id s

Hi all, I have a list of firm ids that contains 17,000 firm ids. I have a big dataset which contains over 5 million observations of an eve...

Why are Frames Useful

Perhaps this is a question for another forum, but I had a more general question about dataframes. I know the data frame feature was added ...

Reshaping Long Data Issue

I am trying to collapse this data but I have continuously gotten errors regarding the i and j not being unique. Here is a snippit of the dat...

Using svy command with graph command

Dear all, I am trying to use graph in Stata 16 to plot bars of the means of categorical variables (5-point scale) while using the svy co...