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
Esttab Output File not generated properly

Esttab Output File not generated properly

Tuesday, April 30, 2019 Data Cleaning Data management Data Processing
I am writing the following code: local variables= "taxratesales taxrateVAT" estpost tabstat `variables', statistics(mean p5...
marginal effect of latent class logit model

marginal effect of latent class logit model

8:28 PM Data Cleaning Data management Data Processing
I am trying to obtain the marginal effect of the membership variable in latent class logit model Array (e.g. if the age is more elder, wha...
Propensity score matching

Propensity score matching

7:18 PM Data Cleaning Data management Data Processing
Hi all, I am currently trying to run PSM on STATA14 to compare effect of treatment 1 vs treatment 2 (control). I have a few questions befo...
Understanding Stata's default yscale() choice

Understanding Stata's default yscale() choice

7:08 PM Data Cleaning Data management Data Processing
Hi everyone, I am trying to find out how Stata chooses the exact default range of the y-axis. The article "Stata tip 23: Regaining co...
Error message on assigning different methods of obtaining start values for latent class analysis

Error message on assigning different methods of obtaining start values for latent class analysis

4:48 PM Data Cleaning Data management Data Processing
Hi all, I am running a 3-class latent class model on 17 categorical indicators and keep getting error messages. The total sample size is 2...
Adding controls, insignificant treatment var turns significant

Adding controls, insignificant treatment var turns significant

4:18 PM Data Cleaning Data management Data Processing
Dear friends, I am running a Fixed Effects regression to test the effect of a policy on firms' patent application. The outcome variabl...
CAPM OLS event study calculating CAR for multiple companies at the time

CAPM OLS event study calculating CAR for multiple companies at the time

2:35 PM Data Cleaning Data management Data Processing
Hello Stata friends, I am conducting a CAPM event study with 34 events and eight different companies. I would like to compare the differen...
Time Dummy Variables in stcox

Time Dummy Variables in stcox

2:35 PM Data Cleaning Data management Data Processing
Hi, I am analyzing the factors that affect the time-on-market when selling a house using -stcox-. Because my data set includes houses th...
Why is the mixed command slow? Can it be sped up?

Why is the mixed command slow? Can it be sped up?

2:28 PM Data Cleaning Data management Data Processing
I'm attempting to do a simulation comparing resutls from a random effects model with a random intercept to some other regression models,...
Population Variable Signifcance

Population Variable Signifcance

2:28 PM Data Cleaning Data management Data Processing
I am currently analysing a Log-Lin model, in which I am adding the independent variable LN Pop to test the significance within the regressio...
Regression on unbalanced panel

Regression on unbalanced panel

2:28 PM Data Cleaning Data management Data Processing
Hi, I'm currently working on impact of risk - taking behavior on firm growth, and here is my panel: (the number wasn't real) NA...
Pincipal Component Analysis Index

Pincipal Component Analysis Index

1:38 PM Data Cleaning Data management Data Processing
Hi everyone. I am working with data from 126 schools in rural Angola. I want to create a index for school infrastructure and use it in my ...
latent class analysis: Can Stata fit 2 latent variables (categorical) in one model

latent class analysis: Can Stata fit 2 latent variables (categorical) in one model

1:28 PM Data Cleaning Data management Data Processing
Hi Statalists, I am trying to do a latent class analysis with 2 latent variables (categorical) within the same dataset and within the sam ...
importing dataset with long variables names into stata through loop statements

importing dataset with long variables names into stata through loop statements

12:53 PM Data Cleaning Data management Data Processing
Dear Stata Users, I am trying to import dataset below into stata from csv Array but some variable names are too long and and are separate...
Interpreting main effects model with omitted interaction terms

Interpreting main effects model with omitted interaction terms

11:19 AM Data Cleaning Data management Data Processing
Suppose I have two regressors, task availability (Xa) and task participation (Xp), and a DV Y. One can only participate in a task if it is a...
graph hbox qs

graph hbox qs

11:04 AM Data Cleaning Data management Data Processing
Hey guys, i have a question about relabel function, so here is my command graph hbox age, over(morethan50k, relabel (1"lots of ...
Multinomial fractional response model in panel data

Multinomial fractional response model in panel data

10:28 AM Data Cleaning Data management Data Processing
Hello all! I am mainly working in the context of rural non-farm sector diversification. Thus, i want to model the diversification strategi...
Help Interpreting Results from regress function with unbalanced panel data

Help Interpreting Results from regress function with unbalanced panel data

9:33 AM Data Cleaning Data management Data Processing
Hello! First post here, will do my best to follow all FAQ rules. I am working on a project with a dataset that has 162,000 observations an...
Clustering across Individuals/Households AND Areas

Clustering across Individuals/Households AND Areas

9:28 AM Data Cleaning Data management Data Processing
Dear Statalisters, I am currently working on a dataset in China regarding Individual spending. I have panel data and run something like th...
Interaction term in survival analysis (streg)

Interaction term in survival analysis (streg)

9:28 AM Data Cleaning Data management Data Processing
Hello, I am posting my first question here to ask how to interpret the interaction term in survival analysis regression. I'm workin...
How to imputate missing values for one year in a pooled cross section dataset?

How to imputate missing values for one year in a pooled cross section dataset?

9:03 AM Data Cleaning Data management Data Processing
Hello everyone, I am new to Statalist and I will try to be brief and concise. I am working with the Ethiopian Medium and Large Manufacturi...
generate yearly date variable

generate yearly date variable

8:48 AM Data Cleaning Data management Data Processing
Hi, very simple question: I want to generate a yearly time variable from 1870 - 2017 in my stata spreadsheet. I could not find the code ...
for loop

for loop

8:04 AM Data Cleaning Data management Data Processing
Hi there, I have the following code in stata: *2018 *Form 4 generate Form4= 1 if Performance2018 ==1 & form== "4" repla...
Unsure if SCARs are correct (event study)

Unsure if SCARs are correct (event study)

7:43 AM Data Cleaning Data management Data Processing
Dear Statalist community, I'm working on an event study and I want to use standardized cumulative abnormal returns, however I'm un...
Calculating MHHI with triple summation

Calculating MHHI with triple summation

7:18 AM Data Cleaning Data management Data Processing
Hi everybody! I'm looking to create a Modified Herfindahl-Hirschmann Index (MHHI) in STATA from the attached formula. It creates a mark...
Generating a new variable but missing values have been included

Generating a new variable but missing values have been included

7:18 AM Data Cleaning Data management Data Processing
Hi, My code is: Code: generate var_66 = 1 if var_33 >=2 However it has put a 1 in the new variable where there are missing values...
Trying to create a new variable out of the response of the respondents in the survey ! Your help will be much appreciated

Trying to create a new variable out of the response of the respondents in the survey ! Your help will be much appreciated

6:58 AM Data Cleaning Data management Data Processing
Hello Intelligent People, The version of STATA i am using is 14.2 on a Windows 10 Here is a glimpse of what my data looks like metho...
Regression gives different results depending on the order of the independent variables

Regression gives different results depending on the order of the independent variables

6:48 AM Data Cleaning Data management Data Processing
I am running what is essentially a difference in differences regression on a large dataset with a lot of fixed effects. Bizarrely (maddening...
Create categorical variable*

Create categorical variable*

6:04 AM Data Cleaning Data management Data Processing
hi! new to stata/in a stats class... i have a dataset that has individual race dummy variables. Is there a way for me to merge all of the du...
tobit regression with collinearity

tobit regression with collinearity

5:53 AM Data Cleaning Data management Data Processing
Hi i am running a tobit regresison for data across 2 years 2007-2008: My variables include 10 log price categories for alcohol types on tra...
Logic for using matched sample versus unmatched sample

Logic for using matched sample versus unmatched sample

5:43 AM Data Cleaning Data management Data Processing
Hi all, I am stuck on a problem of when to use a matched versus unmatched sample. I have a list of companies and I am trying figure out th...
no observations error event study

no observations error event study

4:48 AM Data Cleaning Data management Data Processing
Dear Stata community, I'm trying to run a loop to generate the normal returns for my event study, however I run into the following err...
GMM estimation inside a do loop with foreach

GMM estimation inside a do loop with foreach

3:08 AM Data Cleaning Data management Data Processing
Dear Friends, I am trying to use GMM to estimate a model that is nonlinear in its parameters. The model has 3 parameters: rho, sigma1, a...
cross classified multilevel structure

cross classified multilevel structure

2:48 AM Data Cleaning Data management Data Processing
Dear Stata Forum, I am using mixed estimating a cross-classified multilevel model with three levels, where I have approximately 100 000 o...
Idiosyncratic Volatility - Rolling Window

Idiosyncratic Volatility - Rolling Window

1:58 AM Data Cleaning Data management Data Processing
Hello everyone! I am trying to compute idiosyncratic volatility on a rolling basis of 24 months with monthly data. I have created a month/...
Mean if respondents have answerd atleast out of 3 variables

Mean if respondents have answerd atleast out of 3 variables

1:48 AM Data Cleaning Data management Data Processing
Hi I would reaaly be grateful if anyone can help with providing a code for this. I have 3 sets of variables relating to the same thing. I ...
New to STATA | Linear regression on STATA

New to STATA | Linear regression on STATA

1:38 AM Data Cleaning Data management Data Processing
Hi, I am new to STATA and I am trying to do a linear regression analysis for a college project. I am getting the error message, "ma...
cross-correlations in long format

cross-correlations in long format

1:18 AM Data Cleaning Data management Data Processing
Hi guys, I am currently working on a dataset in long format and I need the average corss-correlation of all variables. I have tried to conve...
Converting XY coordinates into lat-long

Converting XY coordinates into lat-long

12:48 AM Data Cleaning Data management Data Processing
Hi, I have a data set that records the pick-up and drop-off locations of a particular item. The coordinates of these locations are in the ...
Independence assumption in Cross-Classified Multilevel Models?

Independence assumption in Cross-Classified Multilevel Models?

12:28 AM Data Cleaning Data management Data Processing
Dear everyone, In cross-classified (multilevel) models, the cross-classified variance components are generally assumed to be independent. ...
How to choose which duplicates to drop/keep?

How to choose which duplicates to drop/keep?

Monday, April 29, 2019 Data Cleaning Data management Data Processing
Hi there, I'm working on data from 2012-2018 concerning HIV-positive pregnant women in treatment and loss to follow-up. For those who ...
Replacing values of multiple variables at once

Replacing values of multiple variables at once

10:09 PM Data Cleaning Data management Data Processing
I have 9 variables (v1 - v9) with binary responses coded as yes = 1 no =2. I want to replace all he values of no to 0 for all variables at...
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)
    • ►  June (654)
    • ►  May (1034)
    • ▼  April (1079)
      • Esttab Output File not generated properly
      • marginal effect of latent class logit model
      • Propensity score matching
      • Understanding Stata's default yscale() choice
      • Error message on assigning different methods of ob...
      • Adding controls, insignificant treatment var turns...
      • CAPM OLS event study calculating CAR for multiple ...
      • Time Dummy Variables in stcox
      • Why is the mixed command slow? Can it be sped up?
      • Population Variable Signifcance
      • Regression on unbalanced panel
      • Pincipal Component Analysis Index
      • latent class analysis: Can Stata fit 2 latent vari...
      • importing dataset with long variables names into s...
      • Interpreting main effects model with omitted inter...
      • graph hbox qs
      • Multinomial fractional response model in panel data
      • Help Interpreting Results from regress function wi...
      • Clustering across Individuals/Households AND Areas
      • Interaction term in survival analysis (streg)
      • How to imputate missing values for one year in a p...
      • generate yearly date variable
      • for loop
      • Unsure if SCARs are correct (event study)
      • Calculating MHHI with triple summation
      • Generating a new variable but missing values have ...
      • Trying to create a new variable out of the respons...
      • Regression gives different results depending on th...
      • Create categorical variable*
      • tobit regression with collinearity
      • Logic for using matched sample versus unmatched sa...
      • no observations error event study
      • GMM estimation inside a do loop with foreach
      • cross classified multilevel structure
      • Idiosyncratic Volatility - Rolling Window
      • Mean if respondents have answerd atleast out of 3 ...
      • New to STATA | Linear regression on STATA
      • cross-correlations in long format
      • Converting XY coordinates into lat-long
      • Independence assumption in Cross-Classified Multil...
      • How to choose which duplicates to drop/keep?
      • Replacing values of multiple variables at once
      • user written program for sample size of diagnostic...
      • Panel data tobit and marginal effect
      • How do you determine if you should use a quadratic...
      • Problem Renaming Variables That Contain "."
      • Trying to create a Unique Identifier for a Survey ...
      • Plotting multiple bar graphs with CI
      • how to deal with '' xthenreg'' for dynamic thresho...
      • How to create individual panel data through mergin...
      • Event study versus difference-in-difference.
      • Export matrix to excel. How to asign rows on a loop
      • Using Loops with tabulation
      • REGALL: Stata module to run and compare regressions
      • Variables chosen for multiple imputation
      • Simple addplot syntax - how do I graph 2 sets of o...
      • Generating new variable based on ICD9 code range a...
      • icalc, intspec - "invalid 'focal' " error
      • Categorizing ICD-10 codes into major categories
      • OLS/Random Effects/Mundlak Interaction term
      • Extrac the numbers in variable labels
      • Is this a bug?
      • Interpreting "estat vce, corr" output -- post-esti...
      • Interpreting "estat vce, corr output" postetimatio...
      • java.lang.NoSuchMethodError + Stata 15.1
      • Specify number of iterations to fit an fmm model t...
      • Calculating Margins to Interpred Ordered Logit
      • xtscc for panel data with fixed effects
      • Panel data quality with REGHDFE
      • Diagnostic tests for correlated random effects model
      • Fixed effect xtreg - Panel data - P-value
      • Problem regarding imputation of missing value
      • non parametric regression discontinuity with inter...
      • Fractional polynomials and nonlinear least-squares...
      • Last observation of daily data for each month
      • Seemingly unrelated bivariate probit: backs up dur...
      • Interpreting "estat vce, corr output" posetimation...
      • Confidence interval for interquartile range
      • Confidence bounds for interquartile range
      • Panel Data Ordered Logit not able to calculate.
      • Interpret odds ratios log variable
      • Interpretation of coefficients in a log-level model
      • Clustering Panel Data / Ordered Logit
      • stochastic production function
      • specifying different Fixed Effects (fe) with "xtpo...
      • Probit: Can I restrict the number of iterations?
      • different yline/subtitle in a by() plot
      • ‘Or’ condition for time dummies
      • Synth control method not matching
      • loops
      • Multinomial probit (mprobit): Syntax for specifyin...
      • simple addplot syntax errors?
      • Reusing SEM estimates
      • Fill in missing information for only specific obse...
      • Create a control group matching categorical and co...
      • Running a regression and variables are omitted due...
      • Interpretation of the interaction terms of two cat...
      • How to Esttab SHOWING THE FIRST STAGE ONLY (Withou...
      • Trivial question: what does f. stand for?
      • Ordered Logit Regression
    • ►  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