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
Log transformation of the dependent variable in a first-differences model

Log transformation of the dependent variable in a first-differences model

Friday, December 31, 2021 Data Cleaning Data management Data Processing
Hello all, I am estimating a first differences model of the following form ΔY it = ß 0 + ß 1 ΔX it + ɛ it . In one of the regressions...
joint significance of the dummy variables

joint significance of the dummy variables

1:23 PM Data Cleaning Data management Data Processing
Hi, How do I test for the joint significance of the dummy variables using Stata commands? Denis
Bootstrap post-estimation Craggit model

Bootstrap post-estimation Craggit model

11:23 AM Data Cleaning Data management Data Processing
Hi there, I am needing to use Cragg's Double Hurdle Model, and using the Craggit command. However, I'm using Burke's 2009 treatm...
Difference between DiD and two-way fixed effects model

Difference between DiD and two-way fixed effects model

10:23 AM Data Cleaning Data management Data Processing
I am currently writing my master thesis, where I analyze the effect of hurricanes on the stock market. I have an unbalanced panel dataset wi...
Interpretation of constant in xtreg

Interpretation of constant in xtreg

9:23 AM Data Cleaning Data management Data Processing
Hello everyone! I am currently writing my master thesis, where I analyze the effect of hurricanes on the stock market. I have an unbalance...
DID estimation

DID estimation

4:23 AM Data Cleaning Data management Data Processing
hello everyone, how can I treat the problem if I see an error years not nested in countryid or countryid not a control.
Double Clustering in a Multi-country Data Set up

Double Clustering in a Multi-country Data Set up

1:23 AM Data Cleaning Data management Data Processing
Dear Stata Members First, a heartfelt advance New Year Wishes to All. I wish all a prosperous New Year I am dealing with a cross-country ...
Xtabond2 command system GMM.

Xtabond2 command system GMM.

1:23 AM Data Cleaning Data management Data Processing
Hello to everyone, I am searching in terms of the effect of the uncertainty on the saving and in one part of my robustness check I want to d...
ivreg2 warning covariance matrix of moment conditions not of full rank

ivreg2 warning covariance matrix of moment conditions not of full rank

Thursday, December 30, 2021 Data Cleaning Data management Data Processing
Dear Stata Users, I was trying to estimate an IV regression (2SLS) I have few dummies in my model, the dependent is a binary variable of ...
help on stacking matrices

help on stacking matrices

8:23 AM Data Cleaning Data management Data Processing
Hi, Stata gurus, this seems to be easy, once with right Mata commands. I have N matrices, same number of columns, but different number o...
2SLS with we use polynomial terms of birth cohort.

2SLS with we use polynomial terms of birth cohort.

7:23 AM Data Cleaning Data management Data Processing
Hello, I am trying to estimate a fuzzy RD. Fuzzy RD is equivalent to 2SLS (Hahn et al. 2001). So I am trying to run 2SLS. (I am not allowe...
Choice of regression model

Choice of regression model

6:23 AM Data Cleaning Data management Data Processing
My dependent variable is interval but bounded in the interval 5 to 80. All the values are known within the accuracy of the experiment and it...
Problem with bysort command as it is always showing not sorted!

Problem with bysort command as it is always showing not sorted!

5:23 AM Data Cleaning Data management Data Processing
Dear Stata Members I would like to calculate the industry sales growth (isg) and following is my sample data Code: clear input str9 fi...
propensity score matching

propensity score matching

4:23 AM Data Cleaning Data management Data Processing
I want to do a 1:2 propensity score matching. I am unable to find a source for this any help?
set data out of range as missing

set data out of range as missing

Wednesday, December 29, 2021 Data Cleaning Data management Data Processing
Dear statalist, I have a variable, index, its value should be between 0 to 1, but there are some values out of this range, so I want to se...
Stata forecast does not support mixed effects models

Stata forecast does not support mixed effects models

10:23 PM Data Cleaning Data management Data Processing
As part of reviewer's requests/recommendations, I am trying to compare forecast accuracy of the (almost) same model using fixed effects,...
Endogeneity and RESET Test with PPML

Endogeneity and RESET Test with PPML

7:23 PM Data Cleaning Data management Data Processing
Hello, I'm trying to estimate trade potential for the BRICS group of countries - as in, intra-BRICS trade potential - using a gravity ...
Charlson index for dataset that contains both ICD9 and ICD10 for different years

Charlson index for dataset that contains both ICD9 and ICD10 for different years

6:23 PM Data Cleaning Data management Data Processing
Hello, I am working on a hospital administrative dataset combined for multiple years between 2004-2018 the cases in the earlier years made...
attempt at simple xtline plot gives syntax error

attempt at simple xtline plot gives syntax error

7:23 AM Data Cleaning Data management Data Processing
Hi everybody, I am using Stata15 and want to show oil price development in the time-period I am looking at since its part of my independan...
Data cleaning - checking correct encoding of variables

Data cleaning - checking correct encoding of variables

5:23 AM Data Cleaning Data management Data Processing
Hello, I'm very new to Stata and am trying to complete some data cleaning. I have a dataset with 5 variables and around 200 million ob...
Hausman test: p=value of 1

Hausman test: p=value of 1

5:23 AM Data Cleaning Data management Data Processing
Hi, I am trying to carry out a Hausman test on panel data (using males and females) to clarify if I should use a fixed or random-effects mod...
Small observation in multinomial logistic regression

Small observation in multinomial logistic regression

5:23 AM Data Cleaning Data management Data Processing
Hello I am trying to know what region is more attractive for people. so I used region ( five categorical variables) as a dependant. people...
Weighted least squares

Weighted least squares

5:23 AM Data Cleaning Data management Data Processing
Hello! I have conducted an ordinary least squares model and to test it I performed a sensitivity analysis by doing weighted least squares ...
Generalized propensity score matching for multilevel treatment

Generalized propensity score matching for multilevel treatment

Tuesday, December 28, 2021 Data Cleaning Data management Data Processing
Hi, I am a first-time user of the generalized propensity score. I have 3 treatment levels that are qualitatively different. I used mlogit ...
Generate two new variables in Stata representing the change in net-pay and the change in well-being between june and october

Generate two new variables in Stata representing the change in net-pay and the change in well-being between june and october

10:23 AM Data Cleaning Data management Data Processing
Hi, I'm new to Stata how can I show the above statement in Stata? I would really appreciate any advice on how to solve this in Stata. ...
error: depvar may not be a factor variable

error: depvar may not be a factor variable

8:23 AM Data Cleaning Data management Data Processing
Hey everybody, I want to run a regression with binary variables but I am getting this error: depvar may not be a factor variable. I don...
Create variable using expansion factor

Create variable using expansion factor

6:23 AM Data Cleaning Data management Data Processing
Dear all, I would like to ask you a question. In a database I have identified a group of people, who should receive a transfer, but I have a...
Converting Date-Month-Year (string) to year

Converting Date-Month-Year (string) to year

5:23 AM Data Cleaning Data management Data Processing
Dear Stata Members I have an issue which I know is the most answered questions in this form, I tried using some past posts but to no avail....
Showing a different mean in tabstat

Showing a different mean in tabstat

5:23 AM Data Cleaning Data management Data Processing
I tabulated in my data type of error cases by the number of children. After using sum and N along with mean in tabstat, I realized I don...
Categorical Variables

Categorical Variables

4:23 AM Data Cleaning Data management Data Processing
Hi, I'm an ultra-beginner to Stata and everything related to it. Nevertheless, I have to fix this problem. I work on a large-scale as...
Ho, ho, ho! Wild bootstrap tests for everyone!

Ho, ho, ho! Wild bootstrap tests for everyone!

Monday, December 27, 2021 Data Cleaning Data management Data Processing
I've translated the guts of my boottest program from Mata to Julia, producing the Julia package WildBootTests.jl . And at the page just ...
How to calculate Sigma (standard deviation of weekly stock return)

How to calculate Sigma (standard deviation of weekly stock return)

10:23 AM Data Cleaning Data management Data Processing
Hello all Statalist members. I would like to calculate SIGMA ( denotes standard deviation of weekly stock returns in year T) i mean base o...
entropy balancing commands

entropy balancing commands

10:23 AM Data Cleaning Data management Data Processing
Dear all, I hope you are well. I am performing entropy balancing method for PSM. I have read the paper of Hainmueller and Xu (2013). I fo...
Generate a new variable based on the values of a second variable

Generate a new variable based on the values of a second variable

8:23 AM Data Cleaning Data management Data Processing
Hi, I'm trying to generate a continuous variable using a comparative dataset where I want the countries to be sorted based on the shar...
Time fixed effect and State fixed effect

Time fixed effect and State fixed effect

7:23 AM Data Cleaning Data management Data Processing
Dear all, I am pretty much new for STATA. I'm currently working on my master's thesis. I want to investigate the effect of Vehicle ...
DID two way fixed effects

DID two way fixed effects

7:23 AM Data Cleaning Data management Data Processing
Dear Statalist Members, PS: I have attached a small portion of my data. By using a repeated cross sectional data (Demographic and Health...
Expxport codebook descriptives to latex

Expxport codebook descriptives to latex

7:23 AM Data Cleaning Data management Data Processing
Hello, I have a very simple query that unfortunately I am unable to resolve. I am trying to export my descriptive statistics into a latex ...
Control variables in interaction function

Control variables in interaction function

6:23 AM Data Cleaning Data management Data Processing
Hello fellow stata users! I have a more theoretical question instead of how to use stata. I was wondering if it is okay to add control var...
Suspected bug in -confirm-

Suspected bug in -confirm-

5:23 AM Data Cleaning Data management Data Processing
The title is self-explanatory. Here is a reproducible example: Code: clear sysuse auto confirm variable , exact There is no error where...
cmp-random effects

cmp-random effects

4:23 AM Data Cleaning Data management Data Processing
Good day, I am trying to estimate the impact of health status expectations (Exp_h) on consumption expectations. I performed a conditional m...
How to set the X axis in the DASP package in stata

How to set the X axis in the DASP package in stata

3:23 AM Data Cleaning Data management Data Processing
I want to use the DASP plug-in in stata and use the Lorenz curve to analyze the fairness of inter-provincial health resources. The vertical ...
putdocx cell / row height

putdocx cell / row height

Sunday, December 26, 2021 Data Cleaning Data management Data Processing
Is there a way to control the row or cell height in a putdocx table?
Business calender: Get omitted dates using bodf()

Business calender: Get omitted dates using bodf()

5:23 AM Data Cleaning Data management Data Processing
I have a list of dates for specific company events of listed US companies. This variable (reguldate) may include weekends as well as holiday...
Optimal lags and Error-correction model

Optimal lags and Error-correction model

4:23 AM Data Cleaning Data management Data Processing
Good morning everyone; I want to perform a cointegration with the Error correction model. Everything works fine. My data with optimal la...
How to evaluate the following hypothesizes?

How to evaluate the following hypothesizes?

3:23 AM Data Cleaning Data management Data Processing
Hello all! I am currently working on a research project and I have a dataset of bankrupt and non-bankrupt European companies. First of al...
Problem with parallel: parallelize a loop

Problem with parallel: parallelize a loop

1:23 AM Data Cleaning Data management Data Processing
Hello to all, I am not very strong in STATA but I wrote a program. I wanted to parallelize a loop. But, while searching, I didn't find ...
Problem with parallel

Problem with parallel

12:23 AM Data Cleaning Data management Data Processing
Hello to all, I am not very strong in STATA but I wrote a program. I wanted to parallelize a loop. But, while searching, I didn't find ...
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)
      • Log transformation of the dependent variable in a ...
      • joint significance of the dummy variables
      • Bootstrap post-estimation Craggit model
      • Difference between DiD and two-way fixed effects m...
      • Interpretation of constant in xtreg
      • DID estimation
      • Double Clustering in a Multi-country Data Set up
      • Xtabond2 command system GMM.
      • ivreg2 warning covariance matrix of moment conditi...
      • help on stacking matrices
      • 2SLS with we use polynomial terms of birth cohort.
      • Choice of regression model
      • Problem with bysort command as it is always showin...
      • propensity score matching
      • set data out of range as missing
      • Stata forecast does not support mixed effects models
      • Endogeneity and RESET Test with PPML
      • Charlson index for dataset that contains both ICD9...
      • attempt at simple xtline plot gives syntax error
      • Data cleaning - checking correct encoding of varia...
      • Hausman test: p=value of 1
      • Small observation in multinomial logistic regression
      • Weighted least squares
      • Generalized propensity score matching for multilev...
      • Generate two new variables in Stata representing t...
      • error: depvar may not be a factor variable
      • Create variable using expansion factor
      • Converting Date-Month-Year (string) to year
      • Showing a different mean in tabstat
      • Categorical Variables
      • Ho, ho, ho! Wild bootstrap tests for everyone!
      • How to calculate Sigma (standard deviation of week...
      • entropy balancing commands
      • Generate a new variable based on the values of a s...
      • Time fixed effect and State fixed effect
      • DID two way fixed effects
      • Expxport codebook descriptives to latex
      • Control variables in interaction function
      • Suspected bug in -confirm-
      • cmp-random effects
      • How to set the X axis in the DASP package in stata
      • putdocx cell / row height
      • Business calender: Get omitted dates using bodf()
      • Optimal lags and Error-correction model
      • How to evaluate the following hypothesizes?
      • Problem with parallel: parallelize a loop
      • Problem with parallel
      • Collect recode problem
      • Wald or F-test
      • How can I use the marginal effects after fixed eff...
      • Creating N subpopulations by random sampling witho...
      • City Industry leader
      • how to replace the blanks in macro "global"
      • Graph and x-axis stata
      • Dividing a column by another
      • Negative predicted values after xtnbreg on nested ...
      • data structure transformation
      • Converting a code from Stata to R
      • Poisson regression formula
      • How to correct for attrition with IPW in a DID set...
      • Need help with graphs
      • problem with collect layout
      • Is not a two-way plot type
      • Foreach Loops for excel graph export
      • Log4j vulnerability (CVE-2021-44228 and subsequent...
      • Create 2 new variables from existing variables: on...
      • coefplot subgraphs by coefficients: how to loop su...
      • Why I got this error "independent variables are co...
      • Possible justifications for treating an ordinal sc...
      • Cox Regress with the restricted cubic spline, graph
      • How to include nominal variables in Structural Equ...
      • Unable to merge data: obtaining return code r(601)
      • How to send frame results to Excel
      • Replacing missing values with criterion
      • R2-values are very, very low.
      • New package robit on SSC
      • Finding Median for weighteds survey data
      • Consecutive observations by mofd
      • Cloud computing Stata/BE
      • Fixed Effects High Prob F and low Rsq
      • Strate graph
      • How do you combine categorical and numerical varia...
      • ttest over multiple subsamples
      • PISATOOLS package - How can I conduct a linear reg...
      • How can I find maximal value of one variable betwe...
      • Minimum number of observations required in panel d...
      • Cumulative rolling sum over fixed time period in u...
      • Event study using "never treated" units - DID mult...
      • Stochastic Frontier Approach (SFA): Why the sfpane...
      • Sample from joint distribution
      • Format the number of decimals in Table command in ...
      • How to generate mean by group
      • how do I get an overall p value for independent fa...
      • testing difference between coefficients in differe...
      • Consolidating two line graphs and editing X and Y ...
      • Need advice on recoding categorical variables into...
      • Monthly Unemployment Rate Calculation for Two Grou...
      • Stata 17- Percentages of the total sum
      • Creating missing value mechanisms
      • Creating missing value mechanisms
    • ►  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