Is ROC curve for 3x3 table possible?

Dear All, I have a confusing doubt in my mind. ROC curve for 3x3 or 2X3 table is possible? If so, 1. Can any one please give some example...

inquire foreach list

I find that Code: foreach x in Gold Platinum_upgrade Platinum_upgrade_merit { in fact, there is no Gold variable in the dataset. Instea...

How to split?

Dear All, I have this data set, Code: * Example generated by -dataex-. To install: ssc install dataex clear input str61 y "4.4%"...

inquire about capture command

I see a data code that starts: Code: clear * capture cd "~/Dropbox/Projects/The Demand for Status/Final_data_QJE" set more off...

Gravity Model: reverse causality LEAD variable

Hi, I am trying to test for potential reverse causality between RTAs using a gravity model. RTA = 1 if exporter and importer have a RTA ...

Interpreting coefficients of a three-level mixed model

Dear Stata-listers, I have a three-level mixed model and I am struggling on the specific interpretation of the coefficients. I have obser...

Text analysis - find frequency of several keywords within several strings + stop words removal + sentiment analysis

Hello! I am a new user of Stata and I have a problem with a task I have to solve. As a part of my thesis, I have to do a text analysis. Aft...

Splitting a string variable in to two parts

Hello... I have a string variable that has 3-5 words. I want to split it into two parts. Here's the example Code: clear all inpu...

How to reshape

I have a problem with reshaping, I don't know how to do this. Can someone help please? I have this: obs_no vname place v_ Var2 250 ...

predict after xtreg, fe

Hello, I have a fixed effects panel regression: xtreg exp cost i.year, fe My regression coefficient is 0.5. A one unit increase in cost ...

Exporting a cross table using three string variables to a CSV file

Dear Statalisters, How do I export a result table using three string variables ("region", "cat", "field") in ...

Stata MP in Microsoft Terminal Server Environment

Hello, would anyone be able to offer any white paper or solutions articles on deploying Stata MP in a Microsoft Terminal Server environment....

Coefplot how to change bar colors?

My question is how can I change the bar colors when using HTML Code: coefplot I tried this: HTML Code: bar(1,bcolor(navy)) bar(2, ...

Mediation Analysis in Difference-in-Differences (DiD)

Hello, I am trying to test mediation using difference-in-differences. My outcome variable is company total sales and my treatment variabl...

Create beeswarm and beanplot

Hi all, I would like to create a beeswarm plot and a beanplot. My dataset contains a numeric variable - I compare this variable over subgr...

Mata implementation of a fast (k) nearest neighbours lookup algorithm

Hello everyone I have implemented a kd-tree search algorithm in Mata, that can find the k nearest neighbours of a p-dimensional point amon...

Creating a sum variable of the prior 12 months

Dear Users, For a current project I need to create a new variable (call it X), which exist of the sum of the previous 12 months. I need to...

Manipulating forest plot

Hello, So I am working on my first meta-analysis in which I am assessing the incidence of traumatic brain injury in LMIC, so to pool the r...

SAMPLE SIZE CALCULATION FOR PANEL DATA/ USE OF Stata PSS

Good morning all I need assistance to calculate the minimum sample size for a piece of hospital-based research work. I have read through th...

How to filter out string observations with common characters?

Hi Statalisters, I am new to Stata and when I work on my data. I want to filter out string observations with common characters. For exampl...

Destring with many decimal issue

Hi I am fairly new to Stata, and have searched a lot on my issue but have not yet found a solution.. My issue is with destring of my var...

SEM model group analysis not concave

Hello there ! I am trying to use Stata and check my SEM model for measurement in-variance among two different groups. The issue that i am ...

Dummy variable for neonatal Mortality, Infant mortality and Child mortality

Hi, I am working on the Demographic health survey (DHS) data. I have to compute the neonatal Mortality (death during the first 28 days of li...

-margins- after -xtlogit,fe-

Dear Statalist This is a question about interpreting the results from a panel data fixed-effects logistic regression. The outcome variable...

Loop over multiple arrays via foreach

Hello together! trying now since a few hours to fix my problem - I am not able to come up with an adequate solution. I need your help / ad...

ICD 10 to ICD-9 mapping using GEMs

Hi stata users, anybody has any experience in using GEMs files to map backwards from icd10 to ICD10 codes in stata. I have downloaded follo...

Logit Regression Model / Plotting Interactions

Hi everyone, I am working at my final paper and need some guidance. I want to look at the party identification with a specific party_x i...

Looping over correlation function

I am trying to produce a dataset that includes the autocorrelations of a variable (ret) across groups (portfolio). I am able to report the f...

Coefplot: reduce spacing on y-axis

Hello everybody, I have a question about how to reduce the spacing between labels on the y-axis when using Benn Jann's coefplot comman...

Getting an error from putexcel set ..., open

I have this simple line of code to setup my excel worksheet but I get the following error when I try to run it: putexcel_set_new(): 3010 at...

coefplot chang bar color?

My question is how can I change the bar colors when I`m using HTML Code: coefplot I added this HTML Code: bar(1,bcolor(navy)) bar(2, bc...

How to generate predicted wage (gap) with margins command and plot a profile with marginsplot

Dear Stata user, I would like to have predicted mean immigrant-native wage gaps on the vertical axis and years since migration (ysm) on th...

Interpreting Xtabond2 Coefficients & Coefficient Inflation?

Hi, This is a follow-up question for this topic, but because the question is different, I thought may be it can be more useful in the futu...

How to look at regression between score bands

Hi, I have a binary variable and a score variable. I want to look at the binary variable in different bands of the score variable (specifica...

bayesgraphs diagnostics in Item Response Model

Please, how do we use bayesgraphs diagnostics command in Item Response Model? Thanks for your anticipated assistance. olayiwola Adetutu K...

coefplot graph, symmetry between dots

Dear Statalisters, I am using the coefplot command to create one graph with coefficients from 40 different regressions However, the positi...

Help with counts

Hello, I am working on a prescribing data set containing details of about 100,000 people. The lay out is similar to the table below: ID...

How drop some elements from a macro list of files

Hi Statalist I have a question. I have the following datasets: 2008_a8.txt, 2010_a4.txt, 2012_a7.txt, 2014_a5.txt, 2015_a2.txt and 2016_a...

Textbox position in bar graphs

I am trying to change the position of subtitles in bar graphs. I've created a MWE from Stata's dataset: Code: use http://www.s...

How check if value in one variable is equal to any value in other variables

I am trying to gen a variable or variables that say VAR1 has elements in commons with other 2 variables (VAR2 and VAR3), VAR2 has element in...

How to rescale A variable by range

Hello statalist members, i want to rescale my contious variables(x,y) by range(maximum-minimum) because of my other variables which are dic...

Textbox position in bar graphs

I am trying to change the position of subtitles in bar graphs. I've created a MWE from Stata's dataset: Code: use http://www.sta...

Counting the number of ID type for each country in the data

Hi, My Panel data has 260 Panel IDs(firms) over a number of time period and another variable names as ID_Type (which is either 1 or 2 for ...

extract year

Dear All, How can I extract year (Stata format) from the following variable? Code: * Example generated by -dataex-. To install: ssc instal...

clustering and concentration Stata code

Hi everyone, I am in the process of writing one of my dissertation chapters. Using US Census and ACS, I want to measure Middle Eastern an...

Foreach Loop to Rename Variable

Dear all, I was trying to use foreach loop to rename variables, I wanted to names of the variables to be like Capacity1, Capacity2, Capaci...

Local and global macro are not capturing variables' names but the values in the first row

Dear all, I have a problem when using the local and global macro. When I set up a local macro based on variable names, then display it, ...

Nested Variables in glm

I am trying to use nested variables in glm because I have a non-normal dependent variable potentially explained by nested categorical and co...

How to calculate ten-year moving average of variable x by the dummy variable europe in a dataset as the following? Many thanks!

Code: * Example generated by -dataex-. To install: ssc install dataex clear input float id_number int year float europe double x 1 1302 ...

Studentized / Standardized Residuals

Is it possible to obtain predicted studentized (jackknifed) or standardized residuals with robust/clustered estimation or weighted data? I u...

TABSTAT: How to group my summary statistics?

Hello together. I need help and search for a simple way to "group" my summary statistics. My current Stata code is as follows:...

Troubleshooting - Temp file does not find a variable

Good evening everyone. I have the following code Code: use "Dataset.dta", replace drop if 5*365>dis_end tempfile A0 save `...

npregress kernel regression using panel data

Hello, I am exploring npregress kernel command for a panel data (Country year). I was reading a working paper titled: Panel Data Specificati...

Best practice when using 'format' while maintaining precision of double

I added set type double at the beginning of my code to implement the double-precision for all newly created variables. This works fine. H...

Coefs. not Signif. but Improving Moment Conditions | xtdpdgmm

Hi, I'm currently modeling the public-private wage gap in Brazil. The work revolves around estimating Mincer earning equations for all...

Working on Nested Loop

My data is stored in a panel data format. I want to estimate the ARDL model that accommodates one structural break. The break dates are iden...

Combining observations into one

I´m working on a data which has registered repeated observations because there are some observations (individuals) that belong to more than ...

Calculating Standard Deviation with Rangestat

Hey all, I have the following problem. I would like to calculate rolling standard deviation of the past returns of the 36 months in a pane...

grc1leg; how to control legend text and marker size

Dear listers I would like to use the grc1leg to produce a figure, housing multiple plots but with only one legend. the grc1leg (SCC) packag...

Legend for graphs with marker symbol invisible

Hello, I am graphing a twoway dot, with two variables. I can´t seem to find a way to add a legend (it will display with no color) to the...

Quadratic assignment procedure: syntax for estimation command

I am running a qap command (from SSC), using one half (upper triangle) of a square matrix with the structure N*N*T. N= 2,832 and T=10, hence...

Merge if

Hello, Hi, I want to use merge, but the problem is that my using data set is an already appended data set, so it has a few duplicates in m...

Panel Data, one year dummy variable omitted because of collinearity

Hi everybody, I'm using panel data to examine the effect of CEO age on tone and readability of annual reports for 5 years. I have used...

Getting p-values for variables

I am doing a logistic regression using three predictor variables: country, age group, and gender. Is it possible to get the p-value for each...

Multiple lineal regression / Dummy variable, interactions and confounding variables

Hi. I apologize if this is no a question I should post here. I am trying to analyze the interaction and confusion between variables in orde...

country/regional fixed effects

Hi I have a question regarding country fixed effects. I am quite new to this subject, so apologies for the silly question! I have a model ...

How to export this table to excel from stata

sysuse auto tab foreign,sum(price) This code generates a table that I need to export to Excel. Can anyone help? Please, its urgent

Data Categorization txt file

Dear All I have daily share price data in a txt file. The issue is to split the variables into different columns. Variables are Date Sym...

Odds ratio and Con

Hi all, I have a three-part question from a logistic regression. In the case of this study, I have three categorical predictors: gender (M/...