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
Converting panel data from WEAKLY balanced to STRONGLY balanced (Bacon decomposition)

Converting panel data from WEAKLY balanced to STRONGLY balanced (Bacon decomposition)

Sunday, May 31, 2020 Data Cleaning Data management Data Processing
Hi Statalisters, I am working on the Bacon decomposition (using bacondecomp command), which requires a strongly balanced panel. The panel...
Results stop by showing (more)...

Results stop by showing (more)...

10:25 PM Data Cleaning Data management Data Processing
I use Stata/IC 14.2 for Mac (64-bit Intel). I'm looking for a solution where Stata can execute commands without a pause. During a longer...
Pause in results window

Pause in results window

10:25 PM Data Cleaning Data management Data Processing
I use Stata/IC 14.2 for Mac (64-bit Intel). I'm looking for a solution where Stata can execute commands without a pause. During a longer...
Descriptive statistics for panel data

Descriptive statistics for panel data

9:25 PM Data Cleaning Data management Data Processing
Hi Statalist, I'm struggling to generate the descriptive statistics for my dataset. Here is the example of my data: Code: * Exampl...
Appropriate model to use

Appropriate model to use

9:25 PM Data Cleaning Data management Data Processing
hello, I have a question on the most appropriate model to use. I have the data set below, I am trying to find whether the treatment had an e...
Interpreting outputs from "raschjmle" command

Interpreting outputs from "raschjmle" command

8:25 PM Data Cleaning Data management Data Processing
Hi! I am doing my research on Rasch analysis for measuring knowledge. I am using Stata-14 to construct a scale by rasch analysis. Recently ...
Counting number of variables across groups

Counting number of variables across groups

6:25 PM Data Cleaning Data management Data Processing
Hi, I have three variables KeyEventDates KeyEventHistory KeyEventDetails that I am splitting into several columns. I want to check if the ...
Could I include the survey data of "prefer not to say"?

Could I include the survey data of "prefer not to say"?

5:25 PM Data Cleaning Data management Data Processing
Dear friends, I collect survey data with categorical outcome variables whose outcome includes "prefer not to say". Original data i...
Difference in Difference

Difference in Difference

2:25 PM Data Cleaning Data management Data Processing
Hello, I'm trying to do a difference in difference for the data below. The treatment starts after January-2012-01 but when I try running...
Merging Two Data Set

Merging Two Data Set

1:25 PM Data Cleaning Data management Data Processing
Hello Stata Users, I am trying to combine two different data sets according to the variables "Area" and "Year". While o...
Graphs after forecasts

Graphs after forecasts

1:25 PM Data Cleaning Data management Data Processing
Hi everyone! I try to make forecasts four hourly electricity load. I use the forecasts option from Stata's manuals. However i cannot o...
Graphs after forecasts

Graphs after forecasts

1:25 PM Data Cleaning Data management Data Processing
Hi everyone! I try to make dynamic forecasts for hourly load predictions.. I use the forecast commands and I get the following results: s...
create variable names from a variable value, and then group by id

create variable names from a variable value, and then group by id

1:25 PM Data Cleaning Data management Data Processing
Hello Statalisters, thank you in advance for considering the following. I'm trying to creating new variables names from a single var...
Validating and Cross Checking Stata Code

Validating and Cross Checking Stata Code

12:25 PM Data Cleaning Data management Data Processing
Hi Everyone, I have done an analysis of the Demographic and Health Survey data for my research project. Because this is my first serious a...
Identify all user-written commands used in a do-file

Identify all user-written commands used in a do-file

10:25 AM Data Cleaning Data management Data Processing
Hi, I've a paper accepted at a journal and have to send my do-files for replication purposes. I'd like to include all the ados us...
Local inside program

Local inside program

9:25 AM Data Cleaning Data management Data Processing
Hi, I cannot seem to make the following program use the local inside it. MWE: Code: sysuse auto,clear * Reg program capture program ...
difference between predcit and predict, xb

difference between predcit and predict, xb

8:25 AM Data Cleaning Data management Data Processing
Hi, i know that predict yh, xb gives you a linear prediction using X'b. But how does the command predict by itself (without ,xb) does? ...
difference between predcit and predict, xb

difference between predcit and predict, xb

8:25 AM Data Cleaning Data management Data Processing
Sorry for the multiple posts, please delete this.
difference between predictand predict, xb

difference between predictand predict, xb

8:25 AM Data Cleaning Data management Data Processing
Hi, i know that predict yh, xb gives you a linear prediction using X'b. But how does the command predict by itself (without ,xb) does? ...
How to drop duplicates under certain conditions for a subset of observations?

How to drop duplicates under certain conditions for a subset of observations?

8:25 AM Data Cleaning Data management Data Processing
Hi all, I am trying to drop duplicate observations under certain conditions. My data looks something like the following: Code: * Exampl...
fractional probit with sample selection using CMP

fractional probit with sample selection using CMP

7:25 AM Data Cleaning Data management Data Processing
Hello everyone! I am planning to run a fractional response model with sample selection. I wonder if it is possible to do so with a CMP comm...
Reshaping data for tabplot

Reshaping data for tabplot

7:25 AM Data Cleaning Data management Data Processing
Array Hello, How do I reshape the following data to be able to use the tabplot command? Basically I have 8 different symptoms like ...
Matrix not found error after just listing the matrix

Matrix not found error after just listing the matrix

6:25 AM Data Cleaning Data management Data Processing
Dear All, Sorry for a very lengthy post, but I am trying to explain the problem comprehensively. I am attempting to estimate an event-study...
command tabcount is unrecognized

command tabcount is unrecognized

6:25 AM Data Cleaning Data management Data Processing
Hi everyone, I'm learning stata these days. I was trying to use tabcount but I get the following error: "command tabcount is unre...
Applying weights to mixed-effects logistic regression model

Applying weights to mixed-effects logistic regression model

4:25 AM Data Cleaning Data management Data Processing
Hello Statalist, I am trying to add weights to my mixed-effects logistic regression model. I could use regression commands melogit or meqr...
How to calculate mean and 95%CI of willingness to pay (Discrete choice experiment)

How to calculate mean and 95%CI of willingness to pay (Discrete choice experiment)

2:25 AM Data Cleaning Data management Data Processing
Hi everyone I am new in the forum. Hope one of you with expertise in choice experiments method can advice me. My name is Poonyawee. I am ...
Unique Geographic Identifiers from Pooled Data Samples

Unique Geographic Identifiers from Pooled Data Samples

Saturday, May 30, 2020 Data Cleaning Data management Data Processing
Hello, I am using pooled data from selected samples of DHS data. Each sample(country) has a set of unique regions - sometimes ranging from...
Absorbing fixed effects using gsem

Absorbing fixed effects using gsem

11:25 PM Data Cleaning Data management Data Processing
I am trying to run a poisson fixed effects model using gsem. Basically I want to duplicate the results from the following command after sett...
Absorbing fixed effects using gsem

Absorbing fixed effects using gsem

11:25 PM Data Cleaning Data management Data Processing
I am trying to run a poisson fixed effects model using gsem. Basically I want to duplicate the results from the following command after sett...
Confidence intrevals and marginal effects significance for continuos variables in non-linear models

Confidence intrevals and marginal effects significance for continuos variables in non-linear models

11:25 PM Data Cleaning Data management Data Processing
When using margins to evaluate the effect of a continuous variable in a non-linear model (e.g., logit, nbreg), it is common to look at the m...
import delimited does not work..

import delimited does not work..

7:25 PM Data Cleaning Data management Data Processing
Hello, I'm trying to import delimited a csv file, separated by commas. Please find a sample of 5 rows. I run import delimited "as...
How to choose model with different log likelihood values?

How to choose model with different log likelihood values?

10:25 AM Data Cleaning Data management Data Processing
Dear friends, Sorry for my stupid question! I am confused if the model is fitted better when respective (positive) log likelihood value is...
Rangestat for leave-out mean

Rangestat for leave-out mean

10:25 AM Data Cleaning Data management Data Processing
----------------------- copy starting from the next line ----------------------- Code: * Example generated by -dataex-. To install: ssc i...
renaming several variables in loop to reshape by category

renaming several variables in loop to reshape by category

9:25 AM Data Cleaning Data management Data Processing
i have several variables that i want to rename according to their category for example S2_Q1P- S2_Q7P would be plot and i want to rename the...
Small question on bar charts

Small question on bar charts

9:25 AM Data Cleaning Data management Data Processing
I want to draw a hbar chart with three variables via the following command: graph hbar incomep90 incomep95 incomep99, over(year) stacked ...
PSA: I need an Econometrics tutor asap $30/hr

PSA: I need an Econometrics tutor asap $30/hr

8:25 AM Data Cleaning Data management Data Processing
Somebody please help me study for a test ( undergrad ). I'm an adult, just went back to school during slow covid times. We can study via...
Convert Long String Order to Time Index

Convert Long String Order to Time Index

8:25 AM Data Cleaning Data management Data Processing
So this is a separate question following from my last post. It is in regards to the same variable "question_order", but now I am t...
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)
      • Converting panel data from WEAKLY balanced to STRO...
      • Results stop by showing (more)...
      • Pause in results window
      • Descriptive statistics for panel data
      • Appropriate model to use
      • Interpreting outputs from "raschjmle" command
      • Counting number of variables across groups
      • Could I include the survey data of "prefer not to ...
      • Difference in Difference
      • Merging Two Data Set
      • Graphs after forecasts
      • Graphs after forecasts
      • create variable names from a variable value, and t...
      • Validating and Cross Checking Stata Code
      • Identify all user-written commands used in a do-file
      • Local inside program
      • difference between predcit and predict, xb
      • difference between predcit and predict, xb
      • difference between predictand predict, xb
      • How to drop duplicates under certain conditions fo...
      • fractional probit with sample selection using CMP
      • Reshaping data for tabplot
      • Matrix not found error after just listing the matrix
      • command tabcount is unrecognized
      • Applying weights to mixed-effects logistic regress...
      • How to calculate mean and 95%CI of willingness to ...
      • Unique Geographic Identifiers from Pooled Data Sam...
      • Absorbing fixed effects using gsem
      • Absorbing fixed effects using gsem
      • Confidence intrevals and marginal effects signific...
      • import delimited does not work..
      • How to choose model with different log likelihood ...
      • Rangestat for leave-out mean
      • renaming several variables in loop to reshape by c...
      • Small question on bar charts
      • PSA: I need an Econometrics tutor asap $30/hr
      • Convert Long String Order to Time Index
      • Using mkspline for stratified vs interaction models
      • Model confidence set of Hansen
      • Long String Variable w/ Multiple ("...") Substrings
      • Multivariate multiple imputation - Imputation vers...
      • Getting reproducible sample-observations
      • calculating sample attrition in panel dataset (xts...
      • OLS regression with industry fixed effect
      • Bootstrapping with dummies
      • Overlaying two KM graphs: same dataset, different ...
      • Creating one more observation systematically
      • Two questions
      • Expand panel data to the latest datapoint availabl...
      • Proper way to merge data
      • Proper way to merge data
      • Proper way to merge data
      • Swimmer Plot
      • foreach and if condition: if not found r(111);
      • coefplot: point estimates + significance levels
      • Summing a row for one observation only
      • New Stata module for robust estimation of producti...
      • Multi-level multiple imputation in a longitudinal ...
      • ISOweek from dates in Stata: Code below
      • How to change dot appearance in a marginsplot with...
      • calculating true confidence intervals across binom...
      • Identifying area of overlap from geoinpoly
      • Performing OLS after Lasso Model Selection
      • Multiple response data cleaning
      • Create timeperiod for existing data by ID
      • Structural Break VAR
      • mtitles for titles and sub-titles within estab com...
      • Regression output
      • Start counter counting missing values after each n...
      • Matrix raised to a certain power
      • How to get fiited value of trade with ppmlhdfe?
      • Separating string variables with asterisk into two...
      • Create an identification variable for a panel data...
      • simplify generate codes with loops always possible?
      • Random Stratified Sampling
      • test for interaction for subgroup analyses and pop
      • Loop Lasso Regression and Store Values
      • putexcel formula with loops
      • The difference in interpretation between country-y...
      • Command for this panel data regression
      • Normality distribution after mixed
      • Difference between poisson model with exposure and...
      • generate varialbe on the condition
      • Running regression based on size each year
      • Calculating annual visit using visit date
      • Robust Estimation - VAR model
      • Combining multi-item measures
      • Propensity score matching and outcome variable
      • Tabulating and dropping grouped data
      • Combining meglm and svy: error message
      • 2x7 table differences
      • xtmixed difference between main model and postesti...
      • Merging two datasets
      • Format forest plot after ipdmetan
      • Generating total load variable using item weight
      • Uncombining data points when graphing longitudinal...
      • Piecewise Linear mixed model with trajectories and...
      • Rescaling the variable
      • Creating interactions of independent variable with...
      • Can I restore previously closed ado files when I r...
    • ►  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