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
Graph of event study for multiple regressions using eventdd package

Graph of event study for multiple regressions using eventdd package

Monday, February 28, 2022 Data Cleaning Data management Data Processing
Using the following command and using the data, you can use an event study graph for only one set of regressions, but I want to create the s...
Correlation between variables

Correlation between variables

7:23 PM Data Cleaning Data management Data Processing
Hello Statalists, Please, could anyone help with the correct command? I have two datasets measuring the weight of a product using two diff...
Finding sum per row based on conditions

Finding sum per row based on conditions

7:23 PM Data Cleaning Data management Data Processing
Members, I have a dataset with multiple columns (var1, var2, var3, etc.) with missing observations. Per row, I want to find the sum of the...
extract letters from words

extract letters from words

4:23 PM Data Cleaning Data management Data Processing
Dear All, Suppose that I have this data set (with variable "Journal_e": Code: * Example generated by -dataex-. For more info, ty...
Heteroskedasticity - Breusch–Pagan test

Heteroskedasticity - Breusch–Pagan test

3:23 PM Data Cleaning Data management Data Processing
Dear Stata community! I am running the three Breusch–Pagan tests versions most common in Stata (estat hettest estat hettest, iid estat he...
using collect to place frequency distributions from two variables next to each other

using collect to place frequency distributions from two variables next to each other

3:23 PM Data Cleaning Data management Data Processing
Dear Stata Forum, I would like to use the collect command to make a table that has two frequency distributions (from two different variabl...
Working with dates

Working with dates

3:23 PM Data Cleaning Data management Data Processing
Hello, I am attempting to turn a string value "2020-2021" into a date value. Nothing I am doing is actually working, its only ret...
Stock variable problem

Stock variable problem

3:23 AM Data Cleaning Data management Data Processing
Dear Statalist, I am trying to address the perpetual method in order to build a stock variable. Basically, first it generates a initial stoc...
Panel data OLS time and ID restrictions.

Panel data OLS time and ID restrictions.

12:23 AM Data Cleaning Data management Data Processing
Hello I want to make an OLS regression in Stata my regression will be Code: regress regress interestrate lag_interestrate i...
Error (3200) in meglm, when using X##X, but no error with X and X_squared

Error (3200) in meglm, when using X##X, but no error with X and X_squared

12:23 AM Data Cleaning Data management Data Processing
Dear Statalist members, I am using Stata 17 MP (duly updated). The models and the data I am fitting negative binomial (NB2) 3-levels g...
How to get price spells ?

How to get price spells ?

Sunday, February 27, 2022 Data Cleaning Data management Data Processing
I have Monthly prices data of many goods for 10 years. I need to get the price spells i.e. the duration for which the prices remain unchange...
A squared term is negative and significant but the graph is not.

A squared term is negative and significant but the graph is not.

11:23 PM Data Cleaning Data management Data Processing
A squared term is negative and statistically significant, suggesting an inverted-U relationship as hypothesized, but the graph for the predi...
Help with interpreting regression results

Help with interpreting regression results

9:23 PM Data Cleaning Data management Data Processing
I run this code in Stata 17 Code: reg sbpd ib6.group i.black_or_not ib6.group#i.black_or_not i.sex age stratum urpot, cformat(%9.2f) vce(c...
Case control matching with age, gender and BMI

Case control matching with age, gender and BMI

5:23 PM Data Cleaning Data management Data Processing
Hi I am trying to match data by gender, age range +/- 5 years and BMI +/- 3. With the code below it matches but it is including BMI values ...
Cannot install estout package

Cannot install estout package

2:23 PM Data Cleaning Data management Data Processing
Hello everyone, I have been experiencing some issues while trying to install the estout package on my computer using Stata 17. The code I us...
Dealing with Highly Collinear Independent Variables

Dealing with Highly Collinear Independent Variables

Saturday, February 26, 2022 Data Cleaning Data management Data Processing
Dear Stata Members I have a panel data where my independent variables are highly COLLINEAR(Index1 to Index4). In that case, rather than dr...
Trim and fill using metatrim

Trim and fill using metatrim

9:23 PM Data Cleaning Data management Data Processing
I looked through other forum posts ( post1 , post2 , post3 , post4 ) and this question has been asked many times in the forum, but it remain...
Creating a new variable (that changes value in every 3 days....)

Creating a new variable (that changes value in every 3 days....)

7:23 PM Data Cleaning Data management Data Processing
I am working with survey dataset. It has 30 people (variable name = dlp, numeric) who start work in different date (variable name= date, dat...
encode with strange number?

encode with strange number?

7:23 PM Data Cleaning Data management Data Processing
Dear All, I have this data set in Stata format (dataex may not be appropriate for my purpose), encode.dta . I use Code: encode Journal_e, ...
Convert date variable to scale variable

Convert date variable to scale variable

7:23 PM Data Cleaning Data management Data Processing
Hi all I imported an excel dataset to Stata 15. Unfortunately a scale variable (Body Mass Index measured up to 2 decimal places) had a wron...
Stata histogram Help

Stata histogram Help

4:23 PM Data Cleaning Data management Data Processing
Hi, I'm attempting to find the 80th percentile of sales transaction totals in stata and graph it. I'd like the top of the first bar...
Mediation: Direct effect greater than the Total effect !

Mediation: Direct effect greater than the Total effect !

3:23 PM Data Cleaning Data management Data Processing
Dear all, i hope you are doing good in this period of Covid in my work i have studied the following relationships: impact of financial...
Interpret IRF scale

Interpret IRF scale

2:23 PM Data Cleaning Data management Data Processing
Dear all, I have got an annual database with a short term interest rate in percent, a long term interest rate in percent and consumption e...
How to create a binary variable that identify whether another variable has duplicates in the dataset using Stata?*

How to create a binary variable that identify whether another variable has duplicates in the dataset using Stata?*

Friday, February 25, 2022 Data Cleaning Data management Data Processing
The dataset is laid out in longitudinal format where the patient id (pid) is the first column, and the second column "PE"is if th...
How to create a binary variable that identify whether another variable has duplicates in the dataset using Stata?*

How to create a binary variable that identify whether another variable has duplicates in the dataset using Stata?*

5:23 PM Data Cleaning Data management Data Processing
Please help me to delete this post because it is duplicated as above. Thank you!
add a command and all generated variables and data lost.

add a command and all generated variables and data lost.

3:23 PM Data Cleaning Data management Data Processing
rename __merge __merge1 /* rename previous merge commands in order to merge tax+financial data with hotel groups data*/ variable __merge no...
Please Help with Code

Please Help with Code

2:23 PM Data Cleaning Data management Data Processing
Hi All, I am trying to make a variable that identifies whether a person's second to last work history entry was employment (as opposed t...
Invalid name in foreach loop

Invalid name in foreach loop

Thursday, February 24, 2022 Data Cleaning Data management Data Processing
Hi all, I'm trying to iterate over two variables, with the names "category" and "month_created". The code is below...
Merging two data sets based on ranges and assign a number

Merging two data sets based on ranges and assign a number

7:23 PM Data Cleaning Data management Data Processing
I would like to merge two data sets where the first dataset contains probabilities. The second data set contains a column indicating the num...
Negative statistic chi2 after hausman test

Negative statistic chi2 after hausman test

6:23 PM Data Cleaning Data management Data Processing
Hello everyone, I have panel data and my dependent variable is a dummy variable. N=801 (individuals) and T=8 (periods) I am running xtlogi...
Stata vs Mplus for LPA?

Stata vs Mplus for LPA?

5:23 PM Data Cleaning Data management Data Processing
Dear researchers, I am trying to conduct Latent Profile Analysis but wonder conducting it with Stata doesn't get me into any trouble. ...
How should I fix this error in my scatter plot?

How should I fix this error in my scatter plot?

4:23 PM Data Cleaning Data management Data Processing
Hello, I've been trying to make a more advanced scatter plot and have managed to figure out the bits and pieces of it. Essentially, I ...
Controlling for differences caused by occupation

Controlling for differences caused by occupation

3:23 PM Data Cleaning Data management Data Processing
Hello - I am new to the world of econometrics and am working on a small research paper. I am trying to identify the difference in hourly wag...
Using the character ehat_t in the y-axis

Using the character ehat_t in the y-axis

Wednesday, February 23, 2022 Data Cleaning Data management Data Processing
Dear all, I hope you are all keeping well! I want to use the character ehat_t in my y-axis So I tried to add to my code the following ...
geonear r(459) error message advice

geonear r(459) error message advice

7:23 PM Data Cleaning Data management Data Processing
Hi All, I am trying to calculate the distance of disaster occurrences from specific place names within a 50km radius. The code that I am...
Different lagged variables

Different lagged variables

7:23 PM Data Cleaning Data management Data Processing
Hello, I am trying to generate a variable based on the lagged values of other variables, where the time variable is actually the individual...
Plotting nonlinear predicted probabilities from multivariate model against a continous variable

Plotting nonlinear predicted probabilities from multivariate model against a continous variable

6:23 PM Data Cleaning Data management Data Processing
Apologies if this has already been answered, but I have been unable to find a clear answer/I am not exactly sure what I am looking for. I wo...
Help manipulating data groups

Help manipulating data groups

5:23 PM Data Cleaning Data management Data Processing
Hello, I am currently working with data about initial operations and subsequent readmissions which are recorded as separate observations. T...
technical inefficiency with determinants and marginal effects

technical inefficiency with determinants and marginal effects

4:23 PM Data Cleaning Data management Data Processing
I am doing research in tax efficiency. I would like to determine tax effort (persistent and transient including determinants) and marginal e...
Stata overrides the command for which level to omit in a regression

Stata overrides the command for which level to omit in a regression

4:23 PM Data Cleaning Data management Data Processing
Hi Statalist, I would like to seek help for a problem I encountered. I tried to estimate a regression where I regress outcome variable IHS...
Calculating 95% CI of difference in AUC

Calculating 95% CI of difference in AUC

Tuesday, February 22, 2022 Data Cleaning Data management Data Processing
Array After running 2 different logistic regressions with the predict command and then running roccomp- how do we calculate the 95% confide...
Accessing ado files (icalc) to save to a newer computer

Accessing ado files (icalc) to save to a newer computer

5:41 PM Data Cleaning Data management Data Processing
Hi, This is a basic question (for which I apologise), but it's tripping me up. I'm trying to access the "icalc" suite of...
Margins for panel

Margins for panel

3:23 PM Data Cleaning Data management Data Processing
Dear all, I am having a macro panel for a larger period of years (1945- 2020) and for large number of countries with the solid macro varia...
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)
      • Graph of event study for multiple regressions usin...
      • Correlation between variables
      • Finding sum per row based on conditions
      • extract letters from words
      • Heteroskedasticity - Breusch–Pagan test
      • using collect to place frequency distributions fro...
      • Working with dates
      • Stock variable problem
      • Panel data OLS time and ID restrictions.
      • Error (3200) in meglm, when using X##X, but no err...
      • How to get price spells ?
      • A squared term is negative and significant but the...
      • Help with interpreting regression results
      • Case control matching with age, gender and BMI
      • Cannot install estout package
      • Dealing with Highly Collinear Independent Variables
      • Trim and fill using metatrim
      • Creating a new variable (that changes value in eve...
      • encode with strange number?
      • Convert date variable to scale variable
      • Stata histogram Help
      • Mediation: Direct effect greater than the Total ef...
      • Interpret IRF scale
      • How to create a binary variable that identify whet...
      • How to create a binary variable that identify whet...
      • add a command and all generated variables and data...
      • Please Help with Code
      • Invalid name in foreach loop
      • Merging two data sets based on ranges and assign a...
      • Negative statistic chi2 after hausman test
      • Stata vs Mplus for LPA?
      • How should I fix this error in my scatter plot?
      • Controlling for differences caused by occupation
      • Using the character ehat_t in the y-axis
      • geonear r(459) error message advice
      • Different lagged variables
      • Plotting nonlinear predicted probabilities from mu...
      • Help manipulating data groups
      • technical inefficiency with determinants and margi...
      • Stata overrides the command for which level to omi...
      • Calculating 95% CI of difference in AUC
      • Accessing ado files (icalc) to save to a newer com...
      • Margins for panel
      • Combining two numerical variables.
      • Report the goodness of fit for the relogit model i...
      • Using return matrix from polychoric correlation
      • Long Panel: I use AB but It is better PVAR or pane...
      • Using racial/ethnic demographics as the independen...
      • Reshapes wide to long without wave identifier
      • Cross-level interactions vs. separated regressions...
      • Concentration Index (industries within one sector ...
      • splitting Chinese addresses?
      • In Stata 17.0 Kaplan-Meier graph with log scale in...
      • replacing variable value via a loop conditioning o...
      • counting
      • How to capture the results of lookfor_all to local...
      • FEM categorial variable output
      • Store result from calculation to a matrix?
      • How to save a matrix into stata data.
      • How to implement -xtdpdml- with interaction terms?
      • Twoway bar with 2 y-axes
      • XTHREG and Clustered Standard Error (with few Clus...
      • Moving many files into OneDrive
      • Trend analysis
      • Only Keeping Children if Their Parents are in the ...
      • Plotting moderating effects: 1. Margin plots empty...
      • Reshape long to wide
      • Desingplot without showing the missing values
      • Creating a bar chart with error when all variables...
      • Panel Random Effects/MLE, rho and R-squared
      • Five year periods
      • How to make the following code using esttab and es...
      • crossing error bars in a twoway figure
      • Why does Stata show different results when I use -...
      • IF condition within a loop depending on the iterat...
      • How to plot vertical densities for each variable?
      • how to reshape?
      • Add vertical reference lines in horizontal bars
      • insufficient observations r(2001) issue
      • select the first or the last group
      • Codes of unit root tests with multiple structural ...
      • Estimating marginal effects for interactions in th...
      • Need help with homework!!!
      • eventstudy2 longer event window
      • Instrumental variable analysis for binary dependen...
      • Event Study - estimation_window missing values gen...
      • Conditional statements to avoid looping error due ...
      • Geonear but with UTM?
      • match tables
      • pystata does not work in Mac M1
      • profit efficiency
      • Cross Section Data --> Panel
      • unifying the names of companies?
      • help w r(103) error for reshaping data
      • Can asdoc output be exported as HTML?
      • Type of Regression
      • Interpreting the coefficients of continuous variab...
      • xi: areg and areg
      • RECODE help
      • Multivariate Local Linear Polynomial Regression (l...
    • ►  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