BJ Data Tech Solution

Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.

  • Home
  • Data Management
  • Data Analysis
  • Data Collection Tools Tips
Plotting marginal effects of interactions (containing factor variables) with the grinter command

Plotting marginal effects of interactions (containing factor variables) with the grinter command

Wednesday, July 31, 2019 Data Cleaning Data management Data Processing
Hello, I am stuck at plotting the marginal effect of the factor variable i.Left_right_placement regarding the following regression: xi: ...
Hansen issue

Hansen issue

10:13 PM Data Cleaning Data management Data Processing
why i am not getting Hansen statistics? the command is as follows xtabond2 fg_ta l.fg_ta size age ia debt_ratio TobinQ fac roa cashratio i...
Capture change in one variable while different variable is constant

Capture change in one variable while different variable is constant

9:53 PM Data Cleaning Data management Data Processing
Dear Statalisters, I am working with a longitudinal dataset. I'm trying to create a variable to capture change between two periods in ...
calculating distance in Stata

calculating distance in Stata

5:13 PM Data Cleaning Data management Data Processing
Dear All, I would like to know how I can calculate distance in stata between two cities in a country say for the UK Manchester and Nottingh...
tabm and percentages

tabm and percentages

9:03 AM Data Cleaning Data management Data Processing
Hello, This is a question that has come up after my last couple posts on the Statalist and is now a question I have more generally because...
Panel Data - Which model to use? Fama macbeth or panel data another model

Panel Data - Which model to use? Fama macbeth or panel data another model

8:53 AM Data Cleaning Data management Data Processing
Hello, I am currently writing my thesis in Finance. I want to compare the difference in Turnover rate between Male Investors/ Female inve...
If qualifier for n variables equal to zero

If qualifier for n variables equal to zero

8:43 AM Data Cleaning Data management Data Processing
Dear Stata community, dear Nick I am looking for a command which allows me to create an if-statement which refers to about 40 variables. I...
How to plot of linear time trend normalized to zero and one at the beginning and end of the sample

How to plot of linear time trend normalized to zero and one at the beginning and end of the sample

8:13 AM Data Cleaning Data management Data Processing
Dear fellow stata users, After conducting a cross-sectional regression on the panel data, I collected the coefficients' of each years...
question on matching

question on matching

7:53 AM Data Cleaning Data management Data Processing
Hello, I have a "CEO" variable for firms on panel data and the CEO names are not inputted the same due to spelling errors. For e...
Marginal effects after bivariate probit and parameter homogeneity test.

Marginal effects after bivariate probit and parameter homogeneity test.

7:53 AM Data Cleaning Data management Data Processing
Hello people, I am replicating an empirical economic study in which the authors conduct a bivariate probit regression with marginal effect...
giving the same values to the same ID's variable

giving the same values to the same ID's variable

7:43 AM Data Cleaning Data management Data Processing
Hello, I'm manipulating panel data and have a question regarding some variables. I have firms as the unit of analysis and each of them...
Error message "VCE is not positive definite" while performing the multiple imputation

Error message "VCE is not positive definite" while performing the multiple imputation

7:34 AM Data Cleaning Data management Data Processing
Dear Stata users, I am performing the following MI code, HTML Code: mi impute chained (logit, augment)a4_0 a5_1_0 g4_a a4_12 a5_1_12 a...
Stata word in Latex

Stata word in Latex

6:53 AM Data Cleaning Data management Data Processing
Dear all, I was wondering if there is Latex package to add nice-looking Stata names into a document. In my paper, I mention Stata several ...
Analysis of survey rounds: OLS or logit?

Analysis of survey rounds: OLS or logit?

6:48 AM Data Cleaning Data management Data Processing
Hello community! I am conducing a research on UK public attitudes towards immigration. For my data I have combined 8 UK surveys conducted ...
Two fixed effects regressions using two different subsamples of same dataset.

Two fixed effects regressions using two different subsamples of same dataset.

6:18 AM Data Cleaning Data management Data Processing
Hi all, I have a question regarding comparing coefficients of two regressions (fe) which are subsamples of a larger dataset. Context: I ...
ppml_panel_sg and PPML have different predict valuea

ppml_panel_sg and PPML have different predict valuea

6:03 AM Data Cleaning Data management Data Processing
hello, I am using ppml_panel_sg to reg trade on some gravity variables and rta, finding that ppml_panel_sg cannot get the right predict val...
"omitted because of collinearity" issue

"omitted because of collinearity" issue

5:18 AM Data Cleaning Data management Data Processing
Dear community, I conduct an analysis of survey data, precisely logistic analysis. I have individual level indicators which are pretty muc...
using factor variables in command mtreatreg

using factor variables in command mtreatreg

3:53 AM Data Cleaning Data management Data Processing
Dear all, I want to use mtreatreg command and i have categorial variables. The command i use: mtreatreg Y X1 ib1.X2, mtreat(treatment = X1...
Birth cohorts- household level pseudo panel

Birth cohorts- household level pseudo panel

2:08 AM Data Cleaning Data management Data Processing
Hello everyone, I'm using 3 rounds of cross-sectional NSSO data which is at the household level and I would like to construct a pseudo...
GLLAMM or melogit?

GLLAMM or melogit?

1:58 AM Data Cleaning Data management Data Processing
Dear Statalist, I would like to ask you about two things for which I need your help: I am working with a multilevel model with three leve...
Why are there three Constant Terms in Time Series FMOLS Estimation Results?

Why are there three Constant Terms in Time Series FMOLS Estimation Results?

1:48 AM Data Cleaning Data management Data Processing
Why do ı have three constant term in results table. Can anyone help with that? qui cointreg y1 x1 x2 x3 x4, est(fmols) eqtrend(0) eqdet(s...
cmp models with zero-inflation

cmp models with zero-inflation

1:48 AM Data Cleaning Data management Data Processing
I have recently started using cmp models which I find to be very much useful in building multivariate models with different distributions an...
Graph by categories and groups

Graph by categories and groups

12:23 AM Data Cleaning Data management Data Processing
Trying to plot a graph (scatter plot with line ) using a variable (rip) which takes values differently by fyear, state and item. See a sampl...
Dynamic panel data, with small N and large T

Dynamic panel data, with small N and large T

Tuesday, July 30, 2019 Data Cleaning Data management Data Processing
I have a panel data with N=17 and T=46. The model has a dynamic specification as it includes a lagged dependent variable. It looks something...
Stata Matrix error

Stata Matrix error

10:48 PM Data Cleaning Data management Data Processing
Hi. I am doing a regression based decomposition analysis. This is my code Code: global X "Education respondents_current_age Educati...
Changing the date format

Changing the date format

10:48 PM Data Cleaning Data management Data Processing
Currently, I have the variable, calldate, which is in the format 09jul2019, 10jul2019, etc. Is there any way I could change it into the fo...
stata doesn't recognize missings in string variable

stata doesn't recognize missings in string variable

6:03 PM Data Cleaning Data management Data Processing
I want to delete observations that have missing data for a particular variable but stata does not recognize the empty cells as missing when ...
Update to -iscogen- available from SSC

Update to -iscogen- available from SSC

7:44 AM Data Cleaning Data management Data Processing
An update to the iscogen package is now available from SSC. Type Code: . ssc install iscogen, replace to install the update. New fea...
Update to -kmatch- available from SSC

Update to -kmatch- available from SSC

7:29 AM Data Cleaning Data management Data Processing
A maintenance update to kmatch is now available from SSC. Type Code: . ssc install kmatch, replace to install the update. kmatch requ...
Adding 'proportion' to esttab command.

Adding 'proportion' to esttab command.

7:10 AM Data Cleaning Data management Data Processing
Dear All, I am estimating a logistic fixed effects regression to estimate the effect of a policy change on a binary outcome variable. In m...
Equivalent of 'exposure' variable for xtlogit regression for diff-in-diff

Equivalent of 'exposure' variable for xtlogit regression for diff-in-diff

7:04 AM Data Cleaning Data management Data Processing
Dear All, I am running a logistic FE regression to estimate a the effect of a 'treatment' using a generalized difference-in-differ...
Import Excel Loop issues

Import Excel Loop issues

6:40 AM Data Cleaning Data management Data Processing
Hello everyone, I'm trying to write code to import certain worksheets from an excel workbook, but I can't quite get it to work prop...
Coupled forestplot

Coupled forestplot

6:40 AM Data Cleaning Data management Data Processing
Dear Stata user, I could create one with the midas command using the following code: midas tp fp fn tn , by(subgroup) texts(0.50) bfor(dss)...
Spatial Panel analysis for SYS-GMM

Spatial Panel analysis for SYS-GMM

6:04 AM Data Cleaning Data management Data Processing
Hello, I have a problem. I have my model SYS_GMM (level e diff) done by using xtabond2 of Arellano and Bond. If I want to do a Spatial Panel...
Tabulation only for freq>=5

Tabulation only for freq>=5

5:29 AM Data Cleaning Data management Data Processing
Hello, I am running this tabulate command to display some studentized residuals: tabulate cname if rstudent_1974>=1 & year>=197...
Difference in Difference Estimation

Difference in Difference Estimation

5:19 AM Data Cleaning Data management Data Processing
Dear All, My goal is to find out the impact of migration on several firm level performance measures, such as wage. Here is my data: Cod...
Putexcel command for logistic regression

Putexcel command for logistic regression

4:29 AM Data Cleaning Data management Data Processing
Hello there I'm trying to make a nice table for my logistic regression results using putexcel command but I couldn't find the scal...
interflex command failed

interflex command failed

3:29 AM Data Cleaning Data management Data Processing
Hello everyone, I have a problem with the results of the interflex command. I had tried to look if there was common support in my data wh...
Converting Excel

Converting Excel

3:29 AM Data Cleaning Data management Data Processing
I need to import 3 excel files with different columns/rows into Stata. Excel #1 looks like this: Code: Date StockCode SharesRepurchas...
update available of abm_grid: A Mata class for managing a square grid for agent based models

update available of abm_grid: A Mata class for managing a square grid for agent based models

3:09 AM Data Cleaning Data management Data Processing
An update of the abm_grid class is now available on GitHub: https://github.com/maartenteaches/abm_grid . The abm_grid class is intended t...
F test values are missing, I tried to understand it from the previous post but could not get it.

F test values are missing, I tried to understand it from the previous post but could not get it.

2:49 AM Data Cleaning Data management Data Processing
I am very new stata, please pardon me if i sound stupid. I rana regression with xtreg fixed effect with robust stantdard error. I am not get...
Difference in Difference Parallel Trends test

Difference in Difference Parallel Trends test

2:09 AM Data Cleaning Data management Data Processing
Dear Statalisters, I am running a Difference in Difference analysis. In order to test whether treatment and control units have common tren...
Pre post analysis with ANOVA

Pre post analysis with ANOVA

1:39 AM Data Cleaning Data management Data Processing
Good morning, I was asked to perform a pre-post analysis with ANOVA in order to see the effect of the treatment on the treated. I thought a...
Using cmp command for simultaneous equation model with an ordered endogenous variable

Using cmp command for simultaneous equation model with an ordered endogenous variable

12:29 AM Data Cleaning Data management Data Processing
Hello everyone, I’m running a simultaneous equation model with 2 equations as following : Y1 = f(Y2, X1) ; probit Y2 = f(X1, X2) ; opro...
asclogit or clogit with treatment and control?

asclogit or clogit with treatment and control?

Monday, July 29, 2019 Data Cleaning Data management Data Processing
Dear all, I have conducted a labelled choice experiment with labels=engine type (gasoline, EV, HEV), and two attributes: availability of v...
Data Envelopment Analysis to generate TFP with macro level panel data

Data Envelopment Analysis to generate TFP with macro level panel data

11:39 PM Data Cleaning Data management Data Processing
Hi, I'm relatively new to stata and struggling with the dea (data envelopment analysis) command. My questions are 1. how to specify inp...
why i am not getting Hansen statistics?

why i am not getting Hansen statistics?

9:25 PM Data Cleaning Data management Data Processing
. xtabond2 fg_ta l.fg_ta size age ia_w debt_ratio_w TobinQ fac roa cashratio i.sector_1, gmm(fg_ta) iv(l.(size age ia_w debt_ratio_w Tobin ...
Two variables combined fixed effect with clustered standard errors of another variable

Two variables combined fixed effect with clustered standard errors of another variable

9:25 PM Data Cleaning Data management Data Processing
Hi Stata community, I have an unbalanced panel data set for the years 1992-2018 across different years from various industries classified ...
How to test for multiple instruments in in etregress or eregress

How to test for multiple instruments in in etregress or eregress

8:24 PM Data Cleaning Data management Data Processing
Dear all: I am using Stata 15 to run a linear regression with endogenous treatment aiming to do instrumental variable analysis with a dummy...
snapshot with descriptive names instead of numbers

snapshot with descriptive names instead of numbers

6:24 PM Data Cleaning Data management Data Processing
I just upgraded to Stata 16 today and I was experimenting with the new frames feature . This allows a person to make changes to their data a...
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Latest Articles

Categories

  • CouchDb Skills
  • Data Analysis
  • Data Cleaning
  • Data management
  • Data Processing
  • Research Methodology

Popular Articles

  • How to drop random years from panel data?
    I have a panel data set, consisting of 125 countries, 36 years. I want to run an IV regression multible times and randomly drop 5 (of the 36...
  • Saving pointer matrixes using -mata matsave-
    I am relatively new to the use of pointers in Mata and have thusfar been impressed with their utility. Specific to this query, I have been...
  • instrumenting a binary endogenous regressor
    Hello, I am trying to run a model with a binary endogenous regressor. I am still learning econometrics so I am sorry if this may be a trivi...
  • "tsegen" by group
    Hi, I would like to calculate the moving average of _b_LogSize _b_LogBM _b_MOM12 _b_cons by months of the year over the last 10 years. For...
  • Fixed Effects for a Panel at a Coarser Level
    Hello, I want to include some fixed effects in my model that I believe are difficult to include so any advice on how exactly this can be d...
  • RDD rdrobust problem
    Dear all, I am researching the effect of grade retention on exam results (which can vary from 0 to 20) and I am using a RDD to research th...
  • Growth model - No convergence
    I would like to develop a latent growth model (LGM) with Stata. The point is to illustrate estimated effects of predictors by using Stata...
  • Nvidia Organizational Structure: functional and hybrid
    Nvidia is 7th largest company in the world with a market cap of USD 1 trillion. Due to the size and scope of its operations, it is difficult...
  • Getting values from second to last loop of a -while- loop
    Hi fellow Statalisters, I am using a -while- loop for a particular application, where I need to retrieve a particular value from the secon...
  • Using weights with xtheckman | xtheckman's fixed effects equivalent
    Hi, I am using six waves of the PSID to estimate several determinants (particularly wealth) of the wage equation and the selection equatio...

Recomended Articles

Powered by Blogger.

About Me

Mtenga Baltazar
View my complete profile

Blog Archive

  • ►  2024 (6)
    • ►  February (6)
  • ►  2023 (877)
    • ►  November (1)
    • ►  October (9)
    • ►  September (14)
    • ►  July (9)
    • ►  June (15)
    • ►  May (133)
    • ►  April (174)
    • ►  March (176)
    • ►  February (157)
    • ►  January (189)
  • ►  2022 (2201)
    • ►  December (181)
    • ►  November (180)
    • ►  October (198)
    • ►  September (182)
    • ►  August (182)
    • ►  July (194)
    • ►  June (174)
    • ►  May (167)
    • ►  April (181)
    • ►  March (186)
    • ►  February (170)
    • ►  January (206)
  • ►  2021 (7379)
    • ►  December (327)
    • ►  November (645)
    • ►  October (646)
    • ►  September (639)
    • ►  August (557)
    • ►  July (649)
    • ►  June (656)
    • ►  May (697)
    • ►  April (683)
    • ►  March (697)
    • ►  February (518)
    • ►  January (665)
  • ►  2020 (7956)
    • ►  December (653)
    • ►  November (659)
    • ►  October (598)
    • ►  September (654)
    • ►  August (660)
    • ►  July (682)
    • ►  June (683)
    • ►  May (708)
    • ►  April (692)
    • ►  March (698)
    • ►  February (638)
    • ►  January (631)
  • ▼  2019 (9458)
    • ►  December (601)
    • ►  November (643)
    • ►  October (650)
    • ►  September (637)
    • ►  August (645)
    • ▼  July (681)
      • Plotting marginal effects of interactions (contain...
      • Hansen issue
      • Capture change in one variable while different var...
      • calculating distance in Stata
      • tabm and percentages
      • Panel Data - Which model to use? Fama macbeth or p...
      • If qualifier for n variables equal to zero
      • How to plot of linear time trend normalized to zer...
      • question on matching
      • Marginal effects after bivariate probit and parame...
      • giving the same values to the same ID's variable
      • Error message "VCE is not positive definite" while...
      • Stata word in Latex
      • Analysis of survey rounds: OLS or logit?
      • Two fixed effects regressions using two different ...
      • ppml_panel_sg and PPML have different predict valuea
      • "omitted because of collinearity" issue
      • using factor variables in command mtreatreg
      • Birth cohorts- household level pseudo panel
      • GLLAMM or melogit?
      • Why are there three Constant Terms in Time Series ...
      • cmp models with zero-inflation
      • Graph by categories and groups
      • Dynamic panel data, with small N and large T
      • Stata Matrix error
      • Changing the date format
      • stata doesn't recognize missings in string variable
      • Update to -iscogen- available from SSC
      • Update to -kmatch- available from SSC
      • Adding 'proportion' to esttab command.
      • Equivalent of 'exposure' variable for xtlogit regr...
      • Import Excel Loop issues
      • Coupled forestplot
      • Spatial Panel analysis for SYS-GMM
      • Tabulation only for freq>=5
      • Difference in Difference Estimation
      • Putexcel command for logistic regression
      • interflex command failed
      • Converting Excel
      • update available of abm_grid: A Mata class for man...
      • F test values are missing, I tried to understand i...
      • Difference in Difference Parallel Trends test
      • Pre post analysis with ANOVA
      • Using cmp command for simultaneous equation model ...
      • asclogit or clogit with treatment and control?
      • Data Envelopment Analysis to generate TFP with mac...
      • why i am not getting Hansen statistics?
      • Two variables combined fixed effect with clustered...
      • How to test for multiple instruments in in etregre...
      • snapshot with descriptive names instead of numbers
      • Combine multiple columns into one
      • Adoupdate not working in new installation
      • How to execute a Matlab script from Stata
      • Combine cases, but keep values from each.
      • Minutes off in datetime formatting
      • Creating a binary varible from a date variable
      • Reverse coefficients after regression on ihs trans...
      • Save the residuals from a regression with industry...
      • Metan/forest plot - multiple pooled analysis withi...
      • jm suite for joint analysis of longitudinal and su...
      • Garch(1,1) model does not converge:*flat log likel...
      • Full example of using SEM estimates as regression ...
      • Tobit model with binary endogenous regressors
      • test
      • Constraints in a nonlinear regression with interac...
      • Problems with lower bound for a proportion below 0...
      • Logit regression
      • regressions with Fixed Effect and CCEMG/CCEP give ...
      • Network Analysis-nwcommands
      • Test for two mean and standard deviation with unkn...
      • auto-filter variable name in dialog box
      • Error-correction model with GMM first difference
      • HC2 HC3 standard errors with clusters
      • Stratified Random Sampling
      • population attributable fraction using clogit
      • Creating 1, 3, 6 months cumulative returns and vol...
      • Forming portfolios and tracking their performance
      • Matching data with different time intervals
      • Region dummies in fixed effects panel analysis
      • 6-month Cumulative Return
      • Foreach regression loop - Stata 16
      • Forced variables dropped when using lasso
      • Translation, string date recognized as the week date
      • Model test for OLS conditions and if statement
      • Variable changes_Telling stata to consider only 2 ...
      • Generate data subject to pre specified distribution
      • Hybrid or Hausman-Taylor model with year-fixed eff...
      • weights application on chi square test
      • Outcome / negative -0.000?
      • Defining variables based on characters included an...
      • label for loop?
      • Point in poly dataset mapping
      • crosstabs
      • Odd results in fixed effects panel regression with...
      • If condition with xtreg appropriate?
      • ranked quartiles each year
      • Question about probability weights and number of o...
      • Rank Variable for Income, then further for region
      • Regress individual and collective indicators
      • Return Calculation for Panel Data
    • ►  June (654)
    • ►  May (1034)
    • ►  April (1079)
    • ►  March (1122)
    • ►  February (876)
    • ►  January (836)
  • ►  2018 (931)
    • ►  December (692)
    • ►  November (239)

© BJ Data Tech Solution | Theme by Rifki.id | Premium Blogger Templates | PBT | Powered by Blogger |-| About | Privacy Policy | Sitemap | Contact | Disclaimer