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
Help Fixing Bar Graph of GDP and Dummy Variables

Help Fixing Bar Graph of GDP and Dummy Variables

Saturday, November 30, 2019 Data Cleaning Data management Data Processing
Dear all, I am using Stata 16, on mac. I used the following command in Stata: reg lnGDP lnagedpop lnpopulation WestCoast EastCoast, robust...
Trouble Generating Variable dependant on period

Trouble Generating Variable dependant on period

7:56 PM Data Cleaning Data management Data Processing
Array Above is a picture of a subset of my data. hs10 refers to a specific product being sold and m_val is a value the product takes on. W...
Stata returning missing when converting string date

Stata returning missing when converting string date

7:36 PM Data Cleaning Data management Data Processing
Dear all, I have dates in two formats in a single variable one is 20-Apr-19 the other is 21-APRIL-2019. Stata is returning missing when con...
Different I-square results for meta summarize and meta forestplot using random empirical Bayes method

Different I-square results for meta summarize and meta forestplot using random empirical Bayes method

6:16 PM Data Cleaning Data management Data Processing
Hi The meta forestplot using random(ebayes) appears to produce a different value for the I2 result compared to the output for meta summari...
"Data have changed" dialog box

"Data have changed" dialog box

6:06 PM Data Cleaning Data management Data Processing
I searched the forum for this, but I didn't find anything. Sorry if it's a repeat question. In my workflow, I work from original d...
meta forestplot error in stata 16

meta forestplot error in stata 16

5:57 PM Data Cleaning Data management Data Processing
Hello I am running several meta forestplots for subgroups which worked fine in the version of stata 16 on 14 Nov. meta forestplot _id ou...
Searching within strings

Searching within strings

5:07 PM Data Cleaning Data management Data Processing
I have strL a variable (pgttype) that contains several results such as: "Aneuploidy CRMI 13, 15, 16, 17, 18, 21, 22, X, Y" ...
Method for continuous predictor and dichotomous dependent variable

Method for continuous predictor and dichotomous dependent variable

3:37 PM Data Cleaning Data management Data Processing
Hi everyone, I am working on a research project asking: Do lower rates of school satisfaction and school engagement influence students’ su...
simulation study

simulation study

3:17 PM Data Cleaning Data management Data Processing
so i have to write a short programe for a simulation study, so far i have written program define mysim drop _all set obs 19 gen b =inli...
Set Seed Random Sample

Set Seed Random Sample

3:17 PM Data Cleaning Data management Data Processing
I would like to obtain a nationally representative sample from a (non representative) survey data set thereby using every individual from th...
Multiline model name for long variable names using esttab

Multiline model name for long variable names using esttab

10:22 AM Data Cleaning Data management Data Processing
Hi users, I am using esttab to generate tables in Latex. I have long model name that I want to appear in two lines because if I keep them ...
Clustered Errors and fixed effect on the same level

Clustered Errors and fixed effect on the same level

9:57 AM Data Cleaning Data management Data Processing
Hello Statalist-Forum, I was wondering if you could help me with a problem: I have a continous outcome variable (a health score) and info...
Division into two groups

Division into two groups

9:27 AM Data Cleaning Data management Data Processing
Dear statalists, I am running an analysis with an unbalanced dataset for 10 years. I would like to see whether the results differ for two ...
one year survival - data management

one year survival - data management

7:57 AM Data Cleaning Data management Data Processing
good day all I have a list of children with 2 variables "date of birth" and "date of death". Both are recorded as nume...
Comparing two waves with RE-Logit

Comparing two waves with RE-Logit

6:22 AM Data Cleaning Data management Data Processing
I am currently using Panel data from the SOEP to analyze and compare political interest in 2013 and 2017. My final Dataset contains around 1...
xtreg, fe robust: xtoverid error(2b) operator invalid when correcting Hausman test (V_b-V_B is not positive definite) due to year dummies

xtreg, fe robust: xtoverid error(2b) operator invalid when correcting Hausman test (V_b-V_B is not positive definite) due to year dummies

6:02 AM Data Cleaning Data management Data Processing
Dear Statalisters, I am analyzing a panel dataset with year dummies over a period of 2000-2018 and apparently like many other Stata begin...
Medeff command: invalid mediate (error r(198))

Medeff command: invalid mediate (error r(198))

2:02 AM Data Cleaning Data management Data Processing
Dear Statalists, Could you please tell me the reason why when I type the following command: medeff (regress edb51 acled gdpgrowth1 gdppe...
Doubt on Heckprob model results

Doubt on Heckprob model results

1:02 AM Data Cleaning Data management Data Processing
Hello everybody, I'm running a Heckman selection model based on a heckprob. I have some categorical variables such as grup_ha grupo_ed...
Help creating graph for multiple linear regression

Help creating graph for multiple linear regression

Friday, November 29, 2019 Data Cleaning Data management Data Processing
Dear all, I am using Stata 16, on mac. I am estimating the regression: reg GDP agedpop population WestCoast EastCoast, robust. agedpop(=p...
Exporting residuals vs prediction data

Exporting residuals vs prediction data

10:02 PM Data Cleaning Data management Data Processing
Hi, So, I need to make a residuals versus predictor plot. However, the graphics aren't working in STATA. Yes, I've tried just abou...
how to delete specific observations

how to delete specific observations

9:42 PM Data Cleaning Data management Data Processing
Hello everyone I need to delete the firms that does not have data for three years consecutively. please teach me how to do it for example...
Wagstaff concentration Index for binary outcome

Wagstaff concentration Index for binary outcome

9:12 PM Data Cleaning Data management Data Processing
Hi, I have read in existing literature that if we are dealing with a binary outcome (i.e th individual went for prenatal care/did not go f...
How to generate a new variable based on existing variables

How to generate a new variable based on existing variables

8:07 PM Data Cleaning Data management Data Processing
Dear Stata experts, I have a dataset like below. "tiea"=1 means in a given year the company has a connection to the Senator ...
IKEA Corporate Social Responsibility (IKEA CSR): a brief overview

IKEA Corporate Social Responsibility (IKEA CSR): a brief overview

7:44 PM Research Methodology
IKEA Corporate Social Responsibility (CSR) efforts are led by Chief Sustainability Officer, Pia Heidenmark Cook. The home improvement and fu...
ARDL lag coefficients

ARDL lag coefficients

6:17 PM Data Cleaning Data management Data Processing
Hi everyone or anyone who knows this better than me, I am trying to fit the following short-run equation using ARDL, following in a higly ...
Interpreting a non-linear relationship with predicted values and margins plot

Interpreting a non-linear relationship with predicted values and margins plot

2:27 PM Data Cleaning Data management Data Processing
I am trying to interpret a non-linear relationship in a fixed effects model. Attached is my Stata output. As you can see from the output, ...
jackknife loop with wrong number of observations

jackknife loop with wrong number of observations

10:02 AM Data Cleaning Data management Data Processing
forvalues i = 1/139 { reg fawtd fdistockgdp if seqnum != `i', robust outreg2 using table, append excel } I'm running the abov...
Calculation of standard errors after predictive margins: how are they computed?

Calculation of standard errors after predictive margins: how are they computed?

9:12 AM Data Cleaning Data management Data Processing
Hello, I'm struggling how standard errors after -margins- are calculated, e.g. after -logit-. I am able to reproduce the productive ma...
Error terms for Time Series Regression with a Panel Variable

Error terms for Time Series Regression with a Panel Variable

7:37 AM Data Cleaning Data management Data Processing
Dear all, For my master thesis, I would like as a first step to run a Fama-French three factor regression, and compute idiosyncratic volat...
How to change display of scientific notation of summary statistics to nummeric?

How to change display of scientific notation of summary statistics to nummeric?

7:22 AM Data Cleaning Data management Data Processing
Stata 15.1 I am attempting to create a descriptive statistics table for my thesis. However, I found that variables with large numbers are ...
How to regress categorical variables without base

How to regress categorical variables without base

7:02 AM Data Cleaning Data management Data Processing
Hello, Currently I am investigating the impact of industry categorization (categorical variable) on premium's paid (continuous variabl...
Command problem with counting sample firms smaller than the firm for each country in each year (panel data)

Command problem with counting sample firms smaller than the firm for each country in each year (panel data)

5:32 AM Data Cleaning Data management Data Processing
Hi, guys, I would like to measure the percentage of sample firms smaller than the firm for each country in each year. But I don't know...
Mean of a group minus the observation's value in Panel data

Mean of a group minus the observation's value in Panel data

4:47 AM Data Cleaning Data management Data Processing
Hi, I have a data structure like this: IO-IOarea-Year-index 1----4-------1997-0 2----4-------1998-2.2267373 3----5-------1998-0 4---...
Logging results in forvalues-loop: command lines are not shown in output-logfile

Logging results in forvalues-loop: command lines are not shown in output-logfile

4:47 AM Data Cleaning Data management Data Processing
Hello, I want to save some output results using the -log- command. This works fine if I use -log- as in the example below: the command lin...
Reshaping Data

Reshaping Data

4:37 AM Data Cleaning Data management Data Processing
Dear members I am facing an issue with some data which is available with me in MS-Excel in the following format: SALES SALES SAL...
method for omitted variable bias cross sectional analysis

method for omitted variable bias cross sectional analysis

3:57 AM Data Cleaning Data management Data Processing
Dear all, I have a cross sectional analysis to analyse the effect of head circumference (continuous variable) on cognititve skills (continu...
Panel regression model with N>T and serial autocorrelated error.

Panel regression model with N>T and serial autocorrelated error.

3:02 AM Data Cleaning Data management Data Processing
Dear all, I've been trying to estimate a panel regression model on a dataset with N>T, where N is the number of cross-sectional uni...
Comparing non nested models with xtmelogit

Comparing non nested models with xtmelogit

2:22 AM Data Cleaning Data management Data Processing
Dear all, I am using xtmelogit to run a multilevel logistic regression with PISA data. My data is hierarchical (individuals nested into sc...
LOOP ERROR no observations defined

LOOP ERROR no observations defined

1:47 AM Data Cleaning Data management Data Processing
Dear Stata Users I have been running a loop for each out of 5 years. Code: clear all cd "\\registry\2017" save appended_2017...
Calculate volatility of daily returns by use of GARCH

Calculate volatility of daily returns by use of GARCH

1:47 AM Data Cleaning Data management Data Processing
Hi, We try to calculate the forecasted implied volatility of daily returns by use of the GARCH (1,1) model. So far we don't get any va...
Replace observations with another group in Panel data

Replace observations with another group in Panel data

1:37 AM Data Cleaning Data management Data Processing
Hi, I have panel data and I want to replace observations of one group with the same variable's observations for another group. I have 3...
Interpreting significance - HLM using REML and Kenward-Roger-corr.

Interpreting significance - HLM using REML and Kenward-Roger-corr.

12:57 AM Data Cleaning Data management Data Processing
Dear Statalisters, I struggle with interpreting my results from multilevel linear regressions, using restricted maximum likelihood and Ken...
Using loops to create local from other locals

Using loops to create local from other locals

12:52 AM Data Cleaning Data management Data Processing
I tell Stata that: Code: local 1 "a b c" local 2 "d e f" local 3 "g h i" and I want it to create the foll...
creating loop

creating loop

12:52 AM Data Cleaning Data management Data Processing
Hi, I am new in stata, so I am doing long commands for a simple variable generating. I want to shorten the below commands. As you see only ...
Problem in reporting Arellano-Bond test for auto-correlation after xtabond2

Problem in reporting Arellano-Bond test for auto-correlation after xtabond2

Thursday, November 28, 2019 Data Cleaning Data management Data Processing
Hello dear Stata Users, I am estimating a dynamical panel (370 firms; T=10) where my dependent var is leverage and my independents are the ...
why categorical variables regression only shows one group result?

why categorical variables regression only shows one group result?

8:07 PM Data Cleaning Data management Data Processing
Hey, I am running a regression with categorical variables. But I am quite confused why it only shows the second group result? Code: gen...
bootstrap test for a multilevel mediation analysis

bootstrap test for a multilevel mediation analysis

7:12 PM Data Cleaning Data management Data Processing
Dear all, I'm trying to perform a 2-2-1 multilevel analysis, and my DV is binary. I used the command "melogit" by step to ac...
How get variable list for a condition

How get variable list for a condition

4:22 PM Data Cleaning Data management Data Processing
I wonder if its possible get a variable list for a condition, example: Code: clear all sysuse auto ds, has(type string) unab allvars: _...
average using past group information

average using past group information

10:17 AM Data Cleaning Data management Data Processing
Hi all, I have company-level information as follows. For each company id in a country, I have the current location (current_loc) and new l...
Analysis of Stock market data in Stata - First Time

Analysis of Stock market data in Stata - First Time

9:37 AM Data Cleaning Data management Data Processing
Dear All, I have daily stock market data of 174 firms from 2000 to 2019 (about 4400 prices per stock). I also have the market indexes for ...
Expand data

Expand data

8:47 AM Data Cleaning Data management Data Processing
Dear Statalist Members, I am looking for help with expanding my dataset below to include a categorical variable that takes the values 1 to...
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)
      • Help Fixing Bar Graph of GDP and Dummy Variables
      • Trouble Generating Variable dependant on period
      • Stata returning missing when converting string date
      • Different I-square results for meta summarize and ...
      • "Data have changed" dialog box
      • meta forestplot error in stata 16
      • Searching within strings
      • Method for continuous predictor and dichotomous de...
      • simulation study
      • Set Seed Random Sample
      • Multiline model name for long variable names using...
      • Clustered Errors and fixed effect on the same level
      • Division into two groups
      • one year survival - data management
      • Comparing two waves with RE-Logit
      • xtreg, fe robust: xtoverid error(2b) operator inva...
      • Medeff command: invalid mediate (error r(198))
      • Doubt on Heckprob model results
      • Help creating graph for multiple linear regression
      • Exporting residuals vs prediction data
      • how to delete specific observations
      • Wagstaff concentration Index for binary outcome
      • How to generate a new variable based on existing v...
      • IKEA Corporate Social Responsibility (IKEA CSR): a...
      • ARDL lag coefficients
      • Interpreting a non-linear relationship with predic...
      • jackknife loop with wrong number of observations
      • Calculation of standard errors after predictive ma...
      • Error terms for Time Series Regression with a Pane...
      • How to change display of scientific notation of su...
      • How to regress categorical variables without base
      • Command problem with counting sample firms smaller...
      • Mean of a group minus the observation's value in P...
      • Logging results in forvalues-loop: command lines a...
      • Reshaping Data
      • method for omitted variable bias cross sectional a...
      • Panel regression model with N>T and serial autocor...
      • Comparing non nested models with xtmelogit
      • LOOP ERROR no observations defined
      • Calculate volatility of daily returns by use of GARCH
      • Replace observations with another group in Panel data
      • Interpreting significance - HLM using REML and Ken...
      • Using loops to create local from other locals
      • creating loop
      • Problem in reporting Arellano-Bond test for auto-c...
      • why categorical variables regression only shows on...
      • bootstrap test for a multilevel mediation analysis
      • How get variable list for a condition
      • average using past group information
      • Analysis of Stock market data in Stata - First Time
      • Expand data
      • Python: Importing pandas (and other packages) into...
      • residual diagnostics using mixed
      • Why no vIf in binary logistic Regression
      • "Reshape" problems: non-constant number of variabl...
      • Hypothesis testing
      • Event study - Dropping observations within a leads...
      • Instrumental variable (IV) regression with categor...
      • Interpretation: coefficient for linear is negative...
      • margin effects for continuous variables
      • Creating a list of lists
      • Problems when adding macro variables and time dumm...
      • Fixed effects and instrumental variables
      • Tempfile and error due to "spaces" at the end of a...
      • In need of help with Survey data analysis, survey ...
      • Incorrect margins/pred. probabilities after ivprob...
      • Edit graph with code
      • Weights calculation with metaprop
      • Using matrix as lookup table
      • IKEA Ecosystem: a brief overview
      • Generate sequencial dicotomic variable
      • GLLAMM error not converge
      • Interpreting quadratic terms in a multiple linear ...
      • Graphing three-way interaction
      • Selection by zone and rank
      • Xtreg output: standard error
      • Identifying Total Amount for Closest Contributing ...
      • SUR models
      • Losing observations after predict
      • Count observations in periods
      • Events and rates with svy command
      • Heteroscedasticity
      • Different y-axis scaling with the twoway by() option
      • Panel regression with fixed effects
      • Group Variables
      • Group variables for my thesis
      • Estimating Total Factor Productivity for panel dat...
      • missing value for string type and missing value fo...
      • Help in generating a variable based on certain con...
      • Forloops in panel data - am I indexing incorrectly...
      • Forloops in panel data - am I indexing incorrectly?
      • using "program" command and applying the "program"...
      • create analytical/inverse variance weights for a v...
      • Identifying 'nearest neighbours' without using tef...
      • Sobel test or bootstrapping for testing mediation
      • PPML Country Pair Fixed Effects
      • Rare event models with panel data
      • command for Wooldridge Test for Strict Exogeneity
      • Panel Ardl Model Syntax PMG and MG
      • A Stochastic Frontier analysis under self selection
    • ►  October (650)
    • ►  September (637)
    • ►  August (645)
    • ►  July (681)
    • ►  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