How to get the value of the first occurence on the first row

I have a data in this format below. I want to generate another column (X) that gave me the value of the first occurrence of column A. For ex...

Invalid lval

Hi, I am new to mata, and I'm replicating an old code that uses it. Unfortunately, I'm getting the errors `invalid lval r(3000)` a...

ivreghdfe: how to first-stage regression predicted values

hello, i'm using ivreghdfe, and i'm interested in obtained predicted values of the endogenous variable from the first-stage regressi...

multiple imputation error after MI Estimate logistic regression

Hello: Working on MI Everything works up to the MI estimate. See Error below Have been to the Stata manual and viewed the videos and beli...

Create for each time period the median of the 350 biggest values

Hello everyone, I am currently sitting on an issue regarding taking the median of the 350 highest values per period. Basically I have the ...

Create dummy variable to show change in certain timeframe of paneldata

Hi, I am working with paneldata and want to create a dummy variable that shows me if there is a change in the variable -occ-(occupation) i...

Graph with bold ylabels

Hi all, I am trying to get bold ylabels in a time series graph. I had success only in xlabel , example: Code: use "http://www.pr...

Dropping Observations of Variable according to frequency of occurence

Hi, I am working with the following paneldata and want to drop all observations of which I have less than six observations per Household I...

Parallel trend test for DID model

Dear friends, why the test results using ttable and pstest are not consistent. Code: pstest $xlist Y , t(treated) The results is ...

Dropping duplicate observations conditioned on another variable

Hi, I am using Stata 16.1, and have the following (general) issue. I want to drop duplicate observations of one variable (educ) from my da...

Numerical format in regression tables using esttab/estout

Dear Statalist, I am using esttab (wrapper for estout) from SSC in Stata 16.1. I am trying to export regression tables in which there ar...

Static Model with xtabond2

Dear Users, I have the following equation for panel data xtreg zer esg cap turn tdrdta prbv betal i.year, fe vce(cluster id) However, ...

Updating input output models using RAS method

Happy new year! Is there any tool that enables to update IO tables in STATA?

Find unobserved values

Hey guys, I am currently trying to figure out how to find unobserved values. I have different sic codes (labeled "sic), accordingly v...

choropleth map stretched out

Hi everyone, I'm using Stata 16 to make a chloropleth map of Connecticut. Reading the posts on here, I tried using geo2xy to correct th...

How to solve auto-correlation using unbalanced panel with gaps

Hi all, I am dealing with unbalanced panel data with gaps, it is a survey to manufacturer companies between 1990 to 2012. I am using xtreg,...

Finding minimum value out of 5 different variables for each row

I would like to create a new variable that equals the minimum value out of 5 different variables for each row. Example: For each "ID&...

How would I create this graph?

I am very rusty with STATA and need some help with creating this graph shown in the image. What would be the command in order to create a be...

Deleted

Deleted

Predicting probability of a multivalued endogenous treatment

I am trying to figure out how to predict probability of participating in different treatments (or multivalued treatment). Since the entreat ...

Dealing with id problems in panel data

Hello, I am using a person-firm-level panel data for analysis of wage differentials. But I found that in my dataset has some duplicated ide...

spmap

Dear All, I am using stata14 and trying to create maps of Bangladesh using the package spmap. I want two maps on the same scale. But when I...

Quantile Regression

Code: reg price treatment i.state i.year income rural [fw=round(weight)] , cluster(state) Hi I ran the above regression but now I wish...

regression coefplot with 3 variables

hello I want to make a regression coefplot for 3 variables, the independent variable being a standardised AIDS figure (number of known peop...

【imputation】how to fix r(459) in mi impute chained

Hello! I recently encountered a problem in using MI module in Stata. I want to impute variable wage by "mi impute chained" comman...

apc model

Hi, I want to estimate the following model: log_income = B*age with year and cohort fixed effects. I'm trying to use the command apc bu...

Estimating Intergenerational Correlation (IGC) with nlcom

Dear Statalisters, I am trying to estimate the Intergenerational Correlation (IGC) in education using nlcom but cannot figure out how to ...

spmap options

Hello, I used -spmap- to map US employment and this is the code I used: Code: spmap cbp_emp_sum using uscoord if NAME!="Alaska&qu...

New version of xcontract )AGAIN) on SSC

Thanks once again to Kit Baum, a new version of the xcontract package (superseding yesterday's version) is now available for download f...

Overlapping values on y axis in Stata graph

Array Hi, is there a way to avoid overlapping of numbers on the y axis

Outreg2 to Excel R(198) error diagnosis

I am trying to run the below code in STATA 16.1. STATA is fully updated, and I've uninstalled and re-installed the outreg2 command, re-s...

Median, Tercile and Quartile

Hi, I want to create dummy variables based on the median. Sometiems I do that based on quartile and tercile. I do the following 1. This wi...

Use the lastvar local to read v1 v2 v3 variables from insheet with numeric names

I am reading in GIS data provided by a soil scientist on my research team that is exported to csv files with numeric names (years only). I h...

Generate weighted median variable by other variables

Hello, I have a dataset which lists the year, state, age group, income, and survey weight of individuals surveyed. Agegroup takes on 0 if ...

Postestimation test for cross-sectional time series FGLS regression

Hi I'm conducting a study on the determinants of bank profitability in my country. I have data from 16 of the total 18 banks (N=16) sp...

Different y-axis range on xtline plots

I'm trying to construct some xtline plots using 10 different ids. The range of values of y for id #s 1-9 is 0-100, but for id #10 the ra...

heteroskedasticity in logistic regression model

Hi, I have cross sectional data and am using logistic regression. My question is how do I check my data for heteroskedasticity and in case...

change the color of bars -BOXPLOT

Hi to everybody, I have done for the first time "Box plot by group with data point" By default, Stata gives me graphs with the ...

Equivalent for noisily option in fuzzy package?

Hello Statalist, does anyone know how to get Stata to print all calculations occuring due to commands from the 'fuzzy' package by ...

Mixed effects model on eyes observations

Hi statalist team! I am glad that I participate here! I would like to ask for some help on a "begginer's" problem that I am fa...

Converting annual data to semiannual

Hi everyone, i have to convert a set of annual observations about debt and deficit gdp ratios into semiannual, can someone hepl me? It's...

interaction effect in instrument variable probit model

Dear All, my query is related to the interaction effect in the instrument variable probit model. When I running the ivprobit model with my m...

How to group connected dates?

I have a panel containing daily data which are not all continuous. Within an ID, if those dates are continuous or the gap between two dates ...

datetime of march 31, 2012

Dear All, I have this data set Code: * Example generated by -dataex-. To install: ssc install dataex clear input long(patient_id appo_date...

Modifying dataset for relative time model

Array Array Array Array P.S. To express notation correctly, I uploaded the screenshot of my post. Sample dataset is attached.

Simulating the Dickey Fuller distribution in Stata

Dear all, Hope you are all well. Can I ask if there is a way of simulating the Dickey Fuller distribution in Stata? Best

stuck with nested loops

I am trying to select 10 controls per case (using risk-set sampling) matched by general practice. I used a loop for that as shown below, but...

Coarsened Exact Matching in unbalanced panel data

I am running Coarsened Exact Matching (CEM) on a highly unbalanced panel data (with 26 periods: 13 pre-shock and 13 post-shock), for a diff-...

Oaxaca command - Yun Decomposition

Hi there, I am trying to do Yun's decomposition for a Probit regression using the Oaxaca command (by Ben Jann). I'm having some tr...

Problem with egen rownonmiss, strok

Hello, I am trying to create a variable that will count how many nonmissing responses across several string variables exist per observatio...

Panel data and count dependent variable

Hi all, I have a panel data set of 18 years and 50 regions. My dependent variable is a count one, with over-dispersion. Hausman test indica...

New version of xcontract on SSC

Thanks as always to Kit Baum, a new version of the xcontract package is now available for download from SSC. In Stata, use the ssc command...

Problems with merge

Hi there, I was trying to merge two datasets (code:joinby), however it seems that stata cannot identify my key variable. The master datas...

fuzzy fsQCA bestfit displaying few cases

Hello Statalist, I am conducting a fuzzy-set QCA using the 'fuzzy' package written by Longest & Vaisey (2008) . I am looking a...

How to use tabstat's "format" option with estpost? Getting Error

Hi, I have a time variable in Stata internal form . I am trying to calculate it's summary statistics by group and then exporting it t...

Panel 2sls with multiple interations of endogeneous variables

I´m using Stata 14 with Windows 10 OS. I have 2 endogenous and 8 exogenous variables. I need to run regressions with double and triple int...