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 event study by month

Plotting event study by month

Saturday, April 30, 2022 Data Cleaning Data management Data Processing
Array Hi, I am trying to run and plot an event study, but my regression is not reporting any statistics other than the coefficients and ...
Getting Predicted Values for Regressions

Getting Predicted Values for Regressions

6:24 PM Data Cleaning Data management Data Processing
Hi all, I have a dataset of about 800 observations with 19 variables. One of the variables is a dependent while the others are independent...
no observations to perfom with the code

no observations to perfom with the code

5:24 PM Data Cleaning Data management Data Processing
Code: asdoc cor gini_k decile incdegini eta agesquared ncomp married self_employed smallcity disaving debt_growthrate eyeah , label nonu...
Identify a segment of a string

Identify a segment of a string

4:23 PM Data Cleaning Data management Data Processing
Hi, I want to assign a binary code to each column, 1 if it contains information from the first row and 0 otherwise. Code: * Example ge...
to get away from command ab is unrecognized

to get away from command ab is unrecognized

4:23 PM Data Cleaning Data management Data Processing
Hi my question is simple, i get command ab is unrecognized how can I get away from this
Including a ratio coefficient of other coefficients in the regression

Including a ratio coefficient of other coefficients in the regression

4:23 PM Data Cleaning Data management Data Processing
Dear All, I have been trying to run analysis using the paper of Acemoglu et al. (2008) about the association between democracy and income. ...
mata analysis - Can someone please help me with this mata analysis

mata analysis - Can someone please help me with this mata analysis

Friday, April 29, 2022 Data Cleaning Data management Data Processing
*Data is about: The effect of Maternal Lipid Levels on Pregnant Women Without Complication in Developing Risk of Large for Gestational Age ...
Log Transformation

Log Transformation

3:24 PM Data Cleaning Data management Data Processing
Hello, Should you ever log transform ordinal data? Or can you only log transform continuous variables? Best, Tess
Understand group differences with Likert item dependent and independent variable

Understand group differences with Likert item dependent and independent variable

2:23 PM Data Cleaning Data management Data Processing
Hi, I'd like to understand what may drive differences in my dependent variable between two sub-populations (wealthy and poor for examp...
Reference Country (for industries)

Reference Country (for industries)

2:23 PM Data Cleaning Data management Data Processing
Dear all, Thank you so much for all your help! In the data below, I want to compare the value added per worker for a set of three industr...
Panel data error due to several companies inside country

Panel data error due to several companies inside country

2:23 PM Data Cleaning Data management Data Processing
I am currently writing my master thesis and need to check how percentages of females on the management board of firms in the US and Germany ...
Summing observations that fall below a score

Summing observations that fall below a score

2:23 PM Data Cleaning Data management Data Processing
I am hitting a wall trying to create a variable that is a conditional sum where it looks at the score for a certain observation and sums all...
generate mean value of a locality excluding the focal firm and firms in the same industry as the focal firm

generate mean value of a locality excluding the focal firm and firms in the same industry as the focal firm

2:23 PM Data Cleaning Data management Data Processing
Dear Statalist, I am trying to generate the mean value of a locality, excluding the focal firm and firms in the same industry as the focal...
Messy string data: how to do crosstabulations and descriptives

Messy string data: how to do crosstabulations and descriptives

Thursday, April 28, 2022 Data Cleaning Data management Data Processing
Dear STATA community, Please help! I have messy data containing over thirty variations of different words (e.g., leadership) in four colu...
Labeling interaction terms in coefplot

Labeling interaction terms in coefplot

6:24 PM Data Cleaning Data management Data Processing
Hi, I am trying to create a coefficient plot using just an interaction term that interacts a dummy variable and a year, but the labels are...
Statistical inference

Statistical inference

5:24 PM Data Cleaning Data management Data Processing
The country is Japan, the period is 1972-2020, and the data is annual information. The current account over GDP ratio(cay_t), the net forei...
Generating new variables using macros and loops

Generating new variables using macros and loops

4:26 PM Data Cleaning Data management Data Processing
Hello, I am trying to generate new variables with the use of macros and having issues with the syntax. Would anyone be able to help me with ...
How to generate the Strong Parallel Trend Assumption presented in Callaway, Goodman-Bacon & Sant'Anna 2021

How to generate the Strong Parallel Trend Assumption presented in Callaway, Goodman-Bacon & Sant'Anna 2021

3:29 PM Data Cleaning Data management Data Processing
I'm running a DID model with multiple timer periods and continuous treatment. I currently run the traditional Parallel Trends Assumption...
Help with clock() function

Help with clock() function

2:24 AM Data Cleaning Data management Data Processing
Dear all, I had a time variable in string format. I use clock() function to change it to Stata readable format. Here is the problem: Reg...
merging data with different time frequencies

merging data with different time frequencies

Wednesday, April 27, 2022 Data Cleaning Data management Data Processing
Hello, I have looked for guidance from other posts but could not solve this: I have two datasets- 'Dataset A has annual observations (f...
Stata not showing results/command/log window?

Stata not showing results/command/log window?

6:25 PM Data Cleaning Data management Data Processing
Hi Everyone, I'm running into a weird issue with Stata - the main results/command/log window is ~invisible? Stata is open and is runni...
Twoway subtitle options using -by-

Twoway subtitle options using -by-

6:25 PM Data Cleaning Data management Data Processing
How to adjust text options for subtitles in a simple twoway plot using -by- ? Code: sysuse auto, clear tw scatter mpg disp, by(foreign, ...
Is there a way to format variable?

Is there a way to format variable?

5:24 PM Data Cleaning Data management Data Processing
Hello friends, I am currently using data that has one variable that shows the value of the date, for example, a variable named effective_d...
Difficulty in accessing my results tables via LaTex

Difficulty in accessing my results tables via LaTex

4:23 PM Data Cleaning Data management Data Processing
Hello, I am practicing how to create customised LaTex regression results tables in STATA. However, when I try compiling the LaTex results ...
Unbalanced Panel Data Model

Unbalanced Panel Data Model

3:23 PM Data Cleaning Data management Data Processing
Hello Everybody, Working on our MBA thesis regarding, the determinants of carbon emissions and have created panel data consisting of 14 E...
Difference-in-differences with time varying differentiation.

Difference-in-differences with time varying differentiation.

Tuesday, April 26, 2022 Data Cleaning Data management Data Processing
I have a data panel with information on natural disasters occurred in different municipalities and at different points in time. A municipali...
sts var, trend

sts var, trend

3:23 PM Data Cleaning Data management Data Processing
Dear All, What is the minimal group size for level sufficient to use "sts test var, trend"? Specifically, having many levels in va...
A need for post-estimation tool returning sample units (Countries)

A need for post-estimation tool returning sample units (Countries)

3:23 PM Data Cleaning Data management Data Processing
Dear friends, I have my estimations and models for time-series cross-sectional data. I have 172 countries in my sample. After running regr...
Diff in Diff (xtdidreg) with Multiple Treatment Times: Granger Test and Parallel Trends

Diff in Diff (xtdidreg) with Multiple Treatment Times: Granger Test and Parallel Trends

3:23 PM Data Cleaning Data management Data Processing
HI Everyone, I am using the new -xtdidreg- in Stata 17 to estimate the effects on GDP/capita by a policy treatment. Using these models is ...
loop variables with * wildcard

loop variables with * wildcard

3:23 PM Data Cleaning Data management Data Processing
I have a list of variables that I want to loop through: yr2008_q110atte yr2009_q112atte yr2010_q112atte yr2011_q110atte yr2012_q110att...
Using Repeated Imputation Inference

Using Repeated Imputation Inference

3:23 PM Data Cleaning Data management Data Processing
Does anyone know how to use the rii command in order to whittle down the number of observations in a dataset? I merged a main file, summary ...
Panel data regression with fixed effects

Panel data regression with fixed effects

2:23 PM Data Cleaning Data management Data Processing
Hi Statalist, Recently I am using the state-level mental health data and trying to find its association with state-level literacy. However...
Website that converts SAS command codes into STATA?

Website that converts SAS command codes into STATA?

Monday, April 25, 2022 Data Cleaning Data management Data Processing
Hi Does anyone know of a website or platform that can automatically generate STATA codes from SAS codes? For e.g. , below is a SAS code but...
Canonical Correlation Analysis

Canonical Correlation Analysis

5:23 PM Data Cleaning Data management Data Processing
Hello, I would like to make a canonical correlation analysis with: y1 y2 y3 y4 y5 as dependent variables x1 x2 x3 x4 x5 x6 x7 x8 x9 x1...
Forest plot

Forest plot

4:23 PM Data Cleaning Data management Data Processing
Hello , I was wondering if you could anyone could help me with coding to reproduce the following graph please? Array Here is a photo of ...
Clustered standard errors for a single variable in panel data

Clustered standard errors for a single variable in panel data

3:23 PM Data Cleaning Data management Data Processing
Dear Stata users, I am working with panel data for funds and look for a solution to calculate standard errors (SEs) of a single variable (...
m:m merging - clarification

m:m merging - clarification

Sunday, April 24, 2022 Data Cleaning Data management Data Processing
Hi there, I have 2 datasets; one shows the data of patients who were diagnosed with cancers and the other one shows the details of medicat...
Subgroup Analysis and Sample Selection Bias

Subgroup Analysis and Sample Selection Bias

9:24 PM Data Cleaning Data management Data Processing
I employ a DiD model and want to compare the effect of independent variable (post##treatment) on a dependent variable (i.e. vote). I want to...
How to drop repeated years in a panel dataset

How to drop repeated years in a panel dataset

8:23 PM Data Cleaning Data management Data Processing
Hi everyone, I have a panel dataset with countries and years from 1999 to 2019. However, for each country there are some repeated years. F...
Baseline table package showing p-value and statistics-value

Baseline table package showing p-value and statistics-value

8:23 PM Data Cleaning Data management Data Processing
There has been some useful table1 package, such as table1 and table1_mc. However, they can not show the statistics value (Chi-square, t-val...
Dummy dependent: ANOVA v logit

Dummy dependent: ANOVA v logit

7:24 PM Data Cleaning Data management Data Processing
This is a statistics question rather than a Stata question, but would appreciate any advice. After running an between-subject experiment, ...
Create dataset - longitudinal

Create dataset - longitudinal

5:24 PM Data Cleaning Data management Data Processing
Hello, I have a dataset (example below) where I use the command "append" to add the datasets: i_indresp, ce_indresp_w and cg_ind...
Creating a Graph That Shows Treatment Status by Group Over Years of A Panel

Creating a Graph That Shows Treatment Status by Group Over Years of A Panel

4:24 PM Data Cleaning Data management Data Processing
Hi all, I'm stuck with a graph I'm trying to figure out. I am in one of those difference-in-differences with staggered rollout sit...
Estimate whether coefficient of different models are JOINTLY equal to zero

Estimate whether coefficient of different models are JOINTLY equal to zero

2:24 PM Data Cleaning Data management Data Processing
Dear network, I have 10 independent variables (x1, x2, x3, x4, x5, x6, x7, x8, x9, and x10) and five dependent variables (y1, y2, y3, y4, ...
DiD Regression with panel data measuring two factors before and after treatment

DiD Regression with panel data measuring two factors before and after treatment

Saturday, April 23, 2022 Data Cleaning Data management Data Processing
Hi all! I'd appreciate some help on trying to run a regression through Stata. I am relatively new to Stata so please bear with me. I a...
Panel Data Regression: reg vs xtreg

Panel Data Regression: reg vs xtreg

6:23 PM Data Cleaning Data management Data Processing
Hello Everyone, I have a panel data that I am trying to make a regression for and I am confused which regression command I should use, ...
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)
      • Plotting event study by month
      • Getting Predicted Values for Regressions
      • no observations to perfom with the code
      • Identify a segment of a string
      • to get away from command ab is unrecognized
      • Including a ratio coefficient of other coefficient...
      • mata analysis - Can someone please help me with th...
      • Log Transformation
      • Understand group differences with Likert item depe...
      • Reference Country (for industries)
      • Panel data error due to several companies inside c...
      • Summing observations that fall below a score
      • generate mean value of a locality excluding the fo...
      • Messy string data: how to do crosstabulations and ...
      • Labeling interaction terms in coefplot
      • Statistical inference
      • Generating new variables using macros and loops
      • How to generate the Strong Parallel Trend Assumpti...
      • Help with clock() function
      • merging data with different time frequencies
      • Stata not showing results/command/log window?
      • Twoway subtitle options using -by-
      • Is there a way to format variable?
      • Difficulty in accessing my results tables via LaTex
      • Unbalanced Panel Data Model
      • Difference-in-differences with time varying differ...
      • sts var, trend
      • A need for post-estimation tool returning sample u...
      • Diff in Diff (xtdidreg) with Multiple Treatment Ti...
      • loop variables with * wildcard
      • Using Repeated Imputation Inference
      • Panel data regression with fixed effects
      • Website that converts SAS command codes into STATA?
      • Canonical Correlation Analysis
      • Forest plot
      • Clustered standard errors for a single variable in...
      • m:m merging - clarification
      • Subgroup Analysis and Sample Selection Bias
      • How to drop repeated years in a panel dataset
      • Baseline table package showing p-value and statist...
      • Dummy dependent: ANOVA v logit
      • Create dataset - longitudinal
      • Creating a Graph That Shows Treatment Status by Gr...
      • Estimate whether coefficient of different models a...
      • DiD Regression with panel data measuring two facto...
      • Panel Data Regression: reg vs xtreg
      • Problems with controls and fixed effects in DID
      • SEM - insignificant direct path vs. significant in...
      • Two part model with instrumental variable
      • Stratified Wilcoxon Mann Whitney Generalised Odds ...
      • Practicum due soon/autocorrelation unbalanced pane...
      • Creating categorical variables for hypertension
      • Extreme Bounds Analysis
      • Modulo, Mathematics, and Stata Notation
      • Justification of Label in Legend
      • Summing a variable based on the values of other ca...
      • Query on Effect modification, lincom, and interact...
      • Question about stmixed: "Independent variables are...
      • Clustered DiD with staggered events
      • Interpretation Psmatch2 command
      • help on counting with multiple criterias
      • Bar plot comparing multiple variables among two gr...
      • Autocorrelation and Heteroskedasticity in panel da...
      • Exporting Descriptive Statistics using proportion ...
      • Transition Matrix
      • Backtesting
      • Summing the values of a variable WITHOUT taking in...
      • Need guidance with covariate-adjusted discrete-tim...
      • Calculate conditional holding period return
      • ATUS WB 2013 file syntax error
      • How to reshape this data to panel data?
      • Incorrect Stata Error Message for xtdidregress
      • Posthoc testing after ANOVA
      • Interaction term and main effects
      • Alternative to fixed-effects Binomial Model for lo...
      • Ask for Help with Computation of Running Sum of a ...
      • Panel model - Heteroskedasticity and Graphical rep...
      • How to compute the sum of the first occurence with...
      • F test and Chi2 test
      • counting based on groups
      • Rangestat to compute market betas
      • Need help calculating an "isomorphism index"
      • Changing probability cutoff in binary logistic reg...
      • plotting distribution of variable with concentrati...
      • Combining results from different collections and e...
      • Removing third bracket from*a column which is numeric
      • What multivariate analyses could be performed with...
      • Pooled probit,random effect probit and fixed effects
      • Check for confounder in logistic regression
      • Restrictions years code
      • Error: running sem re using xsmle
      • How can I get P-value for elasticity after QUAIDS?
      • How to fix the fracmented result table
      • fixed effects survey data two stages with differen...
      • Creation of quintile variable in a stata
      • Collapse 2 different ways yields different means
      • Drop top row with variable names/labels when outpu...
      • Interaction terms and testing for significance in ...
      • Warning when Running CSDID and Many Estimates Not ...
      • xtsur Stata
    • ►  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)
    • ►  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