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
Omitted Dummy Variable on -spxtregress-

Omitted Dummy Variable on -spxtregress-

Sunday, March 31, 2019 Data Cleaning Data management Data Processing
Hello, I think I have a problem identifying issue after running random-effect panel data regression using spxtregress. I ran spxtregress for...
Problem with Multiple Imputation

Problem with Multiple Imputation

9:57 PM Data Cleaning Data management Data Processing
Hi all, I am (seemingly) having some trouble with my imputation model. I am trying to impute values for missing data for variables related t...
Plot confidence interval for median

Plot confidence interval for median

9:57 PM Data Cleaning Data management Data Processing
I'd appreciate if anyone could help me with this one. I need to plot median and percentile confidence intervals (2.5 and 97.5) instead o...
Seasonally adjusted GDP

Seasonally adjusted GDP

8:42 PM Data Cleaning Data management Data Processing
I guess this is a simple question. How to get the seasonally adjusted GDP continuously compounded growth rate. Without seasonally adjust...
How to filter data using keywords

How to filter data using keywords

7:47 PM Data Cleaning Data management Data Processing
Hi everyone, I am a novice user of STATA. I have collected execucomp data on excel, where manager data is available according to their tit...
how to surpress the "graphs by group" when graphing histogram with by option

how to surpress the "graphs by group" when graphing histogram with by option

6:57 PM Data Cleaning Data management Data Processing
I do not want to display "graphs by group", Here is the code: Code: * Example generated by -dataex-. To install: ssc install d...
METAN command on log-transformed odds ratios

METAN command on log-transformed odds ratios

4:27 PM Data Cleaning Data management Data Processing
Dear Statalist Member, I have several Effect Sizes (ES) with accompanied 95% Confidence Intervals (ES_lci = lower confidence interval of e...
Stata file to learn from

Stata file to learn from

3:42 PM Data Cleaning Data management Data Processing
Hello all, I am trying to learn Stata, and I was wandering if you have a Stata file (containing a sample data) you prepared that you are wil...
Instrumental Variables

Instrumental Variables

3:42 PM Data Cleaning Data management Data Processing
Hello Experts, I am employing GMM approach on dynamic panel model. There are three endogenous variables, so how many instruments i need to ...
Moderating effects in VAR possible

Moderating effects in VAR possible

3:27 PM Data Cleaning Data management Data Processing
Dear all, I am analyzing panel data covering 52 firms over one year and thinking about employing a VAR-model including exogenous control v...
bootstraping clustered standard errors in system GMM help!

bootstraping clustered standard errors in system GMM help!

2:27 PM Data Cleaning Data management Data Processing
Hi guys, I am running a diff-in-diff fixed effects model with 16 countries between 2002 to 2017 testing whether Spanish labour reform (trea...
Foreach in mata

Foreach in mata

2:27 PM Data Cleaning Data management Data Processing
Dear All, just a quick question. Is it possible to use foreach within a mata function? Suppose I have something lke: Code: mata: fo...
reshape the dataset

reshape the dataset

2:27 PM Data Cleaning Data management Data Processing
Hello I have the dataset as below. It is just one long row variable. I want to reshape using reshape long bV, i(group) j(year). bV_1998_g...
RESET test for omitted variables

RESET test for omitted variables

2:07 PM Data Cleaning Data management Data Processing
Hello, I am trying to run diagnostics of my model and I would like to clarify the following uncertainty. I have panel data and I am using ...
Fill missing observations of a variable with zero

Fill missing observations of a variable with zero

1:47 PM Data Cleaning Data management Data Processing
Dear Stata Users, Please, help me to resolve the following issue. Below I have a dataset. I need to feel “short” with “zero” all missing ob...
Why logit regression and marginal effects can't generate the same z-statistics?

Why logit regression and marginal effects can't generate the same z-statistics?

1:17 PM Data Cleaning Data management Data Processing
Dear Stata experts, I've run logit regression and its marginal effect at follow. However, they should have the same z-statistics but I...
How to find best similar variables using overlaid graph or histograms or else?

How to find best similar variables using overlaid graph or histograms or else?

12:52 PM Data Cleaning Data management Data Processing
I have 51 variables containing 6,120 values of each variable. For example, resid1, resid2, ... resid51. These are predicted values having d...
Interaction between categorical and continous variable - MNL

Interaction between categorical and continous variable - MNL

12:27 PM Data Cleaning Data management Data Processing
Dear Stata users, I would like to generate interactions between categorical and continuous variable in MNL model. This is the code I am us...
SFA Trans log fuctional form

SFA Trans log fuctional form

12:12 PM Data Cleaning Data management Data Processing
Hello everyone. I am doing some technical efficiency analysis using cross-sectional data.Am looking for a syntax that can estimate the tran...
Missing values, but no gaps in the data

Missing values, but no gaps in the data

12:12 PM Data Cleaning Data management Data Processing
Dear All, I have the following data: Code: * Example generated by -dataex-. To install: ssc install dataex clear input byte _ID str52...
Export browse table to Excel

Export browse table to Excel

9:57 AM Data Cleaning Data management Data Processing
Hi there, is there a command that exports the whole data currently in memory to Excel? Practically, I'm looking for something that wil...
Rolling regression or loops - missing values

Rolling regression or loops - missing values

9:47 AM Data Cleaning Data management Data Processing
Dear All I have a peculiar issue I wish to share with you, in the hope of receiving some advice. I have the following panel dataset (unba...
stripplot specifications

stripplot specifications

9:17 AM Data Cleaning Data management Data Processing
Dear colleagues I have a variable named Total Compensation1 and another called Affiliationindex1 (from which I created a variable named Af...
graph pie with some of percentages

graph pie with some of percentages

8:37 AM Data Cleaning Data management Data Processing
How to display the fraction when percentage is above 20%, I know how to display all percentages Code: * Example generated by -dataex-. T...
Oaxaca decomposition for nonlinear regression (nldecompose)

Oaxaca decomposition for nonlinear regression (nldecompose)

8:37 AM Data Cleaning Data management Data Processing
Hello readers, I am trying to decompose (using Ben Jann’s nldecompose) differences in the probability of having more liberal gender views i...
Generate

Generate

8:12 AM Data Cleaning Data management Data Processing
I am using two data set, one contains data for children and another for woman. Now both data sets have key variables for Household id (HH) a...
regression result only except first variable

regression result only except first variable

8:02 AM Data Cleaning Data management Data Processing
Hello When I regress as below, why don't I get the result for the first variable and how can I fix this? It doesn't say even it i...
Year fixed effects

Year fixed effects

6:27 AM Data Cleaning Data management Data Processing
Hello everyone, I am running a panel data regression model in which I observe 4 time periods and 66 observations, using a fixed effects reg...
survey data help: dropping observations

survey data help: dropping observations

5:22 AM Data Cleaning Data management Data Processing
Hello, I am new to stata and would appreciate your help. I have ten crops under var2. I want to drop 8 of the crops and only analyse two o...
GMM: Multiple lagged moment conditions

GMM: Multiple lagged moment conditions

4:28 AM Data Cleaning Data management Data Processing
Hello everyone! I am a complete newbie to Stata and am thus really grateful for any help. I am currently trying to implement a highly non-l...
Controlling for averages of lags

Controlling for averages of lags

2:37 AM Data Cleaning Data management Data Processing
Dear Stata community, I'm using time series regression using data of 100 countries over 22 years to estimate the effect of financial o...
rangestat/runby

rangestat/runby

1:32 AM Data Cleaning Data management Data Processing
Dear All, I wonder if the following question can be solved by (ssc install) rangestat/runby? The data set is: Code: * Example generated b...
In the loop

In the loop

12:42 AM Data Cleaning Data management Data Processing
Loop doesn't work with $ which is a recall from global?? Thank you. foreach i of num 1/17 { global Pi2016_`i'=$Ng`i'/$NgT } ...
Execute R packages within Stata?

Execute R packages within Stata?

Saturday, March 30, 2019 Data Cleaning Data management Data Processing
Dear All, Suppose that (for personal preference) I'd like to execute some R commands/packages (say, PanelMatch) from https://github.com...
Covariate measurement error with binary outcomes

Covariate measurement error with binary outcomes

4:57 PM Data Cleaning Data management Data Processing
While it is possible to get parameter estimates corrected for measurement error using -sem- like: Code: use http://www.stata-press.com/...
Predicting values which incorporate fixed and random effects in linear mixed model

Predicting values which incorporate fixed and random effects in linear mixed model

3:57 PM Data Cleaning Data management Data Processing
Hi all, I am using Stata/SE 14.2 to analyse a randomized controlled trial. Respondents filled the Beck Depression Inventory (bdi) at times...
Help Generating a Feeling Thermometer

Help Generating a Feeling Thermometer

1:37 PM Data Cleaning Data management Data Processing
Hi all, I have some experience with STATA but I am by far not an expert. I have a set of eight variables (from a larger dataset that I did...
Is there any way to absorb time dummies in xtreg, fe?

Is there any way to absorb time dummies in xtreg, fe?

1:27 PM Data Cleaning Data management Data Processing
Hello I want to do code : xtreg depvar indepvar i.day, fe vce (r) with the panel data. (day is a time variable) But the data is too ...
Looping using forvalue in winsor2

Looping using forvalue in winsor2

11:32 AM Data Cleaning Data management Data Processing
I am using the following command in Stata 14.2 which has data stacked by industry-year wise. There are 357 industry year groups for the grou...
Full calculation of R^2 when using ivreghdfe and reghdfe

Full calculation of R^2 when using ivreghdfe and reghdfe

11:02 AM Data Cleaning Data management Data Processing
In ivreghdfe and reghdfe, although it's fast to just absorb fixed effects, if I add them into absorb(), they are not calculated into R^2...
Help with nonstationarity and Cointegration (Phillips-Perron and Pedroni)

Help with nonstationarity and Cointegration (Phillips-Perron and Pedroni)

11:02 AM Data Cleaning Data management Data Processing
Dear All, I am looking for some help as I am quite new to this. Any help or advice would be greatly appreciated. I thank you in advance fo...
Export to single Excel file with multiple sheets (based on variables)

Export to single Excel file with multiple sheets (based on variables)

10:32 AM Data Cleaning Data management Data Processing
Code: +---------------------------------------------------------------------------------------------------------+ | country year ...
How to use nonlinear least squares regression for a vector function?

How to use nonlinear least squares regression for a vector function?

8:47 AM Data Cleaning Data management Data Processing
I am trying to fit the function: Revenue i (time) = A0/(1+exp(-A1*(time-A2))) + B*Costs i I have 5,000 observations of Revenue and Costs ...
Indicator for more than one marital change

Indicator for more than one marital change

8:47 AM Data Cleaning Data management Data Processing
Dear Stata Users, I have a panel dataset and I would like to identify marital changes (var marital). Suppose that 1 represents single, 2 ...
Any way to recover results after a crash?

Any way to recover results after a crash?

8:32 AM Data Cleaning Data management Data Processing
Hi, This might sound silly as I had no idea about the -preserve- command until I started looking for a solution. So I was bootstrapping ...
making loop with the values within the variable

making loop with the values within the variable

7:27 AM Data Cleaning Data management Data Processing
Hello, I have one of the variables G1 which has values from 1 to 17. Then I want to make a loop as below,but it didn't work out. Any...
Splitting a data set into four data sets over all observations but keepin all variables for each splitted data set

Splitting a data set into four data sets over all observations but keepin all variables for each splitted data set

5:42 AM Data Cleaning Data management Data Processing
Hi All, I am using a data set which contains more than 50 variables and 0.36 observations. I need to split all the observations into four ...
Generating categorical dummy variable

Generating categorical dummy variable

5:32 AM Data Cleaning Data management Data Processing
Hi all, I need some help with this. I would like to generate a new binomial variable EDUCATION equal to 1 if HIGH SCHOOL (existing varia...
Clustering Standard Errors help

Clustering Standard Errors help

5:12 AM Data Cleaning Data management Data Processing
Hi, I want to check whether there is a need to cluster my results. I asked this question before with no response. I am doing a fixed effec...
Problem with opening the dataset

Problem with opening the dataset

4:57 AM Data Cleaning Data management Data Processing
Hi Stata community. I am trying to open a .dta dataset, which I have been working on for the last four months (and quite a few hours ago as ...
Group and label variables (perhaps using -rangejoin-)

Group and label variables (perhaps using -rangejoin-)

4:27 AM Data Cleaning Data management Data Processing
Hello, my following problem seems to me as being pretty complicated. However, I will try to explain it as goood and structured as possible...
Appropriateness of Fixed Effects when using a dummy that is only time variant for some panel units.

Appropriateness of Fixed Effects when using a dummy that is only time variant for some panel units.

4:03 AM Data Cleaning Data management Data Processing
I am looking to estimate the impact of the presence of a fiscal council on a country's real growth forecasting error. I have run the fol...
Sorted bar graphs by year for multiple variables

Sorted bar graphs by year for multiple variables

3:42 AM Data Cleaning Data management Data Processing
Code: * Example generated by -dataex-. To install: ssc install dataex clear input str32 country int year float(rank_NGDPRPC rank_NGDPDPC ...
Problem with specifying a range of year or listing years

Problem with specifying a range of year or listing years

3:02 AM Data Cleaning Data management Data Processing
Hello, I am quite new to Stata and am trying to analyse some time series data but am having some issues with getting Stata to understand w...
Average and Median values by group

Average and Median values by group

2:47 AM Data Cleaning Data management Data Processing
Dear All Will appreciate if you can help me on the following query. The following data shows firms (ID), year , reform year (SSRCOMPLETE...
Maki's Cointegration

Maki's Cointegration

Friday, March 29, 2019 Data Cleaning Data management Data Processing
I was wondering if anyone has written an ado file for Maki's cointegration: Maki, Daiki, (2012), Tests for cointegration allowing for a...
How can I select observations containing specific words?

How can I select observations containing specific words?

9:57 PM Data Cleaning Data management Data Processing
Dear all, I need to pick persons A & B whose position include exact "Independent" from the list as follow Directors Positi...
Two limit Tobit with robust and clustered standard errors

Two limit Tobit with robust and clustered standard errors

7:32 PM Data Cleaning Data management Data Processing
Hello, would someone have any help on how to run a two limit tobit model with robust and clustered standard errors. I want to cluster on reg...
Opposite sign for ivprobit marginal effect compared to ivprobit coefficient, ivreg, probit marginal effect

Opposite sign for ivprobit marginal effect compared to ivprobit coefficient, ivreg, probit marginal effect

7:17 PM Data Cleaning Data management Data Processing
Data and code download link (Just 91KB): https://drive.google.com/drive/folde...2M?usp=sharing In this data example I came up with, I get ...
Fixed effects regression drops a variable of interest

Fixed effects regression drops a variable of interest

6:17 PM Data Cleaning Data management Data Processing
Right now I have a standard OLS model with one year of data, and I'm interested in the coefficient for charter schools. My dependent var...
Calculating the length

Calculating the length

5:52 PM Data Cleaning Data management Data Processing
Dear All, I was asked this question. First, the data is Code: * Example generated by -dataex-. To install: ssc install dataex clear input...
Coefplot - option rename()

Coefplot - option rename()

2:57 PM Data Cleaning Data management Data Processing
Dear statalist members, in fact, I have got three questions concerning coefplot (Ben Jann, 2014) but the main question deals with rename()...
mi estimate not using all observations

mi estimate not using all observations

2:57 PM Data Cleaning Data management Data Processing
Hi all, I am trying out multiple imputation in STATA and I noticed something wondering if people can give feedback on. I had N=980, 770 of...
Lasso for binary outcome

Lasso for binary outcome

2:17 PM Data Cleaning Data management Data Processing
I am using lassopack , do I need to specify anything if my outcome is binary? Thanks!
Embedded quotes question

Embedded quotes question

1:37 PM Data Cleaning Data management Data Processing
Hello, I'm trying to auto-generate do-files by copy/pasting from datasets created by the do-file this question pertains to. I want t...
Creating a Regression Table from 2SLS Regressions

Creating a Regression Table from 2SLS Regressions

12:22 PM Data Cleaning Data management Data Processing
Hi everyone! I would like to create two regression tables from nine 2SLS regressions. I have run my regressions using the command "...
Why has Stata dropped observations from my fixed effects model?

Why has Stata dropped observations from my fixed effects model?

11:47 AM Data Cleaning Data management Data Processing
Hi, I have a dataset of 318 local authorities and am running a fixed effects regression. However when I run the regression Stata only per...
-tabout- -show(all)- and -mi- not working

-tabout- -show(all)- and -mi- not working

11:14 AM Data Cleaning Data management Data Processing
Hello all, First and foremost, thank you in advance to anybody that is able to help out. I tried searching Statalist and Google for a solu...
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Latest Articles

Categories

  • CouchDb Skills
  • Data Analysis
  • Data Cleaning
  • Data management
  • Data Processing
  • Research Methodology

Popular Articles

  • How to drop random years from panel data?
    I have a panel data set, consisting of 125 countries, 36 years. I want to run an IV regression multible times and randomly drop 5 (of the 36...
  • Saving pointer matrixes using -mata matsave-
    I am relatively new to the use of pointers in Mata and have thusfar been impressed with their utility. Specific to this query, I have been...
  • instrumenting a binary endogenous regressor
    Hello, I am trying to run a model with a binary endogenous regressor. I am still learning econometrics so I am sorry if this may be a trivi...
  • "tsegen" by group
    Hi, I would like to calculate the moving average of _b_LogSize _b_LogBM _b_MOM12 _b_cons by months of the year over the last 10 years. For...
  • Fixed Effects for a Panel at a Coarser Level
    Hello, I want to include some fixed effects in my model that I believe are difficult to include so any advice on how exactly this can be d...
  • RDD rdrobust problem
    Dear all, I am researching the effect of grade retention on exam results (which can vary from 0 to 20) and I am using a RDD to research th...
  • Growth model - No convergence
    I would like to develop a latent growth model (LGM) with Stata. The point is to illustrate estimated effects of predictors by using Stata...
  • Nvidia Organizational Structure: functional and hybrid
    Nvidia is 7th largest company in the world with a market cap of USD 1 trillion. Due to the size and scope of its operations, it is difficult...
  • Getting values from second to last loop of a -while- loop
    Hi fellow Statalisters, I am using a -while- loop for a particular application, where I need to retrieve a particular value from the secon...
  • Using weights with xtheckman | xtheckman's fixed effects equivalent
    Hi, I am using six waves of the PSID to estimate several determinants (particularly wealth) of the wage equation and the selection equatio...

Recomended Articles

Powered by Blogger.

About Me

Mtenga Baltazar
View my complete profile

Blog Archive

  • ►  2024 (6)
    • ►  February (6)
  • ►  2023 (877)
    • ►  November (1)
    • ►  October (9)
    • ►  September (14)
    • ►  July (9)
    • ►  June (15)
    • ►  May (133)
    • ►  April (174)
    • ►  March (176)
    • ►  February (157)
    • ►  January (189)
  • ►  2022 (2201)
    • ►  December (181)
    • ►  November (180)
    • ►  October (198)
    • ►  September (182)
    • ►  August (182)
    • ►  July (194)
    • ►  June (174)
    • ►  May (167)
    • ►  April (181)
    • ►  March (186)
    • ►  February (170)
    • ►  January (206)
  • ►  2021 (7379)
    • ►  December (327)
    • ►  November (645)
    • ►  October (646)
    • ►  September (639)
    • ►  August (557)
    • ►  July (649)
    • ►  June (656)
    • ►  May (697)
    • ►  April (683)
    • ►  March (697)
    • ►  February (518)
    • ►  January (665)
  • ►  2020 (7956)
    • ►  December (653)
    • ►  November (659)
    • ►  October (598)
    • ►  September (654)
    • ►  August (660)
    • ►  July (682)
    • ►  June (683)
    • ►  May (708)
    • ►  April (692)
    • ►  March (698)
    • ►  February (638)
    • ►  January (631)
  • ▼  2019 (9458)
    • ►  December (601)
    • ►  November (643)
    • ►  October (650)
    • ►  September (637)
    • ►  August (645)
    • ►  July (681)
    • ►  June (654)
    • ►  May (1034)
    • ►  April (1079)
    • ▼  March (1122)
      • Omitted Dummy Variable on -spxtregress-
      • Problem with Multiple Imputation
      • Plot confidence interval for median
      • Seasonally adjusted GDP
      • How to filter data using keywords
      • how to surpress the "graphs by group" when graphin...
      • METAN command on log-transformed odds ratios
      • Stata file to learn from
      • Instrumental Variables
      • Moderating effects in VAR possible
      • bootstraping clustered standard errors in system G...
      • Foreach in mata
      • reshape the dataset
      • RESET test for omitted variables
      • Fill missing observations of a variable with zero
      • Why logit regression and marginal effects can't ge...
      • How to find best similar variables using overlaid ...
      • Interaction between categorical and continous vari...
      • SFA Trans log fuctional form
      • Missing values, but no gaps in the data
      • Export browse table to Excel
      • Rolling regression or loops - missing values
      • stripplot specifications
      • graph pie with some of percentages
      • Oaxaca decomposition for nonlinear regression (nld...
      • Generate
      • regression result only except first variable
      • Year fixed effects
      • survey data help: dropping observations
      • GMM: Multiple lagged moment conditions
      • Controlling for averages of lags
      • rangestat/runby
      • In the loop
      • Execute R packages within Stata?
      • Covariate measurement error with binary outcomes
      • Predicting values which incorporate fixed and rand...
      • Help Generating a Feeling Thermometer
      • Is there any way to absorb time dummies in xtreg, fe?
      • Looping using forvalue in winsor2
      • Full calculation of R^2 when using ivreghdfe and r...
      • Help with nonstationarity and Cointegration (Phill...
      • Export to single Excel file with multiple sheets (...
      • How to use nonlinear least squares regression for ...
      • Indicator for more than one marital change
      • Any way to recover results after a crash?
      • making loop with the values within the variable
      • Splitting a data set into four data sets over all ...
      • Generating categorical dummy variable
      • Clustering Standard Errors help
      • Problem with opening the dataset
      • Group and label variables (perhaps using -rangejoin-)
      • Appropriateness of Fixed Effects when using a dumm...
      • Sorted bar graphs by year for multiple variables
      • Problem with specifying a range of year or listing...
      • Average and Median values by group
      • Maki's Cointegration
      • How can I select observations containing specific ...
      • Two limit Tobit with robust and clustered standard...
      • Opposite sign for ivprobit marginal effect compare...
      • Fixed effects regression drops a variable of interest
      • Calculating the length
      • Coefplot - option rename()
      • mi estimate not using all observations
      • Lasso for binary outcome
      • Embedded quotes question
      • Creating a Regression Table from 2SLS Regressions
      • Why has Stata dropped observations from my fixed e...
      • -tabout- -show(all)- and -mi- not working
      • Renaming graphs
      • egen rank for multiple variables
      • Maximum of indexed variables
      • Predictors of Class Membership with Latent Class A...
      • Independent variable becomes significant when i in...
      • Trying to use .txt without a delimiter
      • Generating the average of previous observations in...
      • Number of Panels
      • Panel data and within individual effects
      • How to add reference lines (yline) for different ID?
      • Panel Regression
      • chi2 not allowed with mrtab and weight
      • Insufficient data when trying looped regressions a...
      • Variables omitted due to multicollinearity- is it ...
      • Value weighted returns are the same as equal weigh...
      • Replacing with lagged value.
      • How to export unit root test results to excel?
      • Testing for autocorrelation in a logistic regressi...
      • Merger of datasets with different data frequency
      • Difference between Intraclass Correlation and With...
      • Multilevel Model with ESS Data (Survey Data) doesn...
      • Spatial matrix user defines
      • invalid error using nwcommands
      • Creating variable to capture before/after effect u...
      • example for merge m:m
      • Combining treatment units for synthetic control me...
      • How to transfer a fmm code into matlab
      • Brant tests: What should I conclude from Brant tes...
      • Question about pweight and fixed effect
      • How to create graphs from svy weighted data?
      • xtlogit error
      • Panel regression
    • ►  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