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
Merging two panel datasets

Merging two panel datasets

Saturday, February 29, 2020 Data Cleaning Data management Data Processing
Hello everyone, I have searched the forum but did not manage to find help for my problem. Im new to stata and still trying to learn so i ap...
Help needed to fix GMM iteration problem

Help needed to fix GMM iteration problem

9:43 AM Data Cleaning Data management Data Processing
I am trying to write a wrapper using GMM. When I do it manually, it converges very fast and provides me coefficients and SE. However, when I...
Margins for Interaction Term

Margins for Interaction Term

8:43 AM Data Cleaning Data management Data Processing
I have run the following regression and am trying to analyse whether the initial level of Income of a country affects changes the effect of ...
What kind of a binary regression model should I choose if I work with pool or panel data?

What kind of a binary regression model should I choose if I work with pool or panel data?

7:43 AM Data Cleaning Data management Data Processing
Hello! I have a longitudinal dataset, which contains observations of individuals between 2008-2017. I want to examine only one year period...
Difference between quietly gen, quietly test and quietly regress?

Difference between quietly gen, quietly test and quietly regress?

7:13 AM Data Cleaning Data management Data Processing
Hi guys, I'm trying to replicate a paper but could not understand the meaning of the following commands. I tried googling it but still, ...
Combining a newly constructed dummy variables to one categorical variable for analysis/refcat

Combining a newly constructed dummy variables to one categorical variable for analysis/refcat

6:43 AM Data Cleaning Data management Data Processing
Dear Statalist, I have currently created four variables about family status: 1) Parents living together 2) Shared custody 3) Lonley parent...
Computing IPW estimator by hand

Computing IPW estimator by hand

5:13 AM Data Cleaning Data management Data Processing
Hello everyone, For my project, I try to know if a certain type of policy ("pol", which is a dummy) has an impact on credit grow...
New to SSC mbitobit - Bivariate Tobit model

New to SSC mbitobit - Bivariate Tobit model

4:43 AM Data Cleaning Data management Data Processing
Dear all, Thanks to Professor Baum, A new command is available in SSC. -mbitobit-. This command re-addresses an old problem. The estimatio...
hausman test problem

hausman test problem

4:43 AM Data Cleaning Data management Data Processing
Dear all, I am working with panel data and when I use the command: hausman fe re, force, I get the following: chi2(55) = (b-B)'[(V_...
Bar Chart Percentiles

Bar Chart Percentiles

4:13 AM Data Cleaning Data management Data Processing
Hello, I plotted a bar graph of the education level agains the mean of the average pay. Because of outliers, this grap is useless. This is...
Kolmogorov – Smirnov Test for panel database

Kolmogorov – Smirnov Test for panel database

4:13 AM Data Cleaning Data management Data Processing
Hello! I want to perform the Kolmogorov –Smirnov test to a panel database given that it is a frequently employed method within the literat...
Create a new variable based on observations within a group

Create a new variable based on observations within a group

3:13 AM Data Cleaning Data management Data Processing
Hello, my dataset is structered the following: clear input float (group_id won_close_dummy loss_close_dummy) 1 0 1 2 1 0 2 1 0 3 1 ...
How to load in the vertex attributes in network

How to load in the vertex attributes in network

3:13 AM Data Cleaning Data management Data Processing
Hello everyone, I am struggling to find out how to load the vertex attributes into a network? I am currently using the "nwcommands...
How to add a constraint when matching using teffects psmatch, cem or psmatch2?

How to add a constraint when matching using teffects psmatch, cem or psmatch2?

2:13 AM Data Cleaning Data management Data Processing
Hello dear statalists, I am trying to match the houses sold at year t with similar houses sold in year t-1, t-2,..., t-5, respectively. Tha...
How to genearte the list of vars for nodes using nw2fromedge command when the number of nodes exceeds 1000

How to genearte the list of vars for nodes using nw2fromedge command when the number of nodes exceeds 1000

1:13 AM Data Cleaning Data management Data Processing
Hello, could someone help me on this question. I am using the network analysis command "nw2fromedge" to generate a one-mode networ...
Define nested loops for dependent and independent variables

Define nested loops for dependent and independent variables

Friday, February 28, 2020 Data Cleaning Data management Data Processing
I have a panel data set from 1970 to 2014 on yields and prices for four different crops. I need to regress yield on prices and the controls ...
Two Stage Least Squares with multiple Fixed Effects (using reghdfe)

Two Stage Least Squares with multiple Fixed Effects (using reghdfe)

10:13 PM Data Cleaning Data management Data Processing
Dear Statalist, I am trying to estimate a two stage least squares where both stages contain multiple fixed effects and interactions betwee...
Dropping repeated columns from a matrix

Dropping repeated columns from a matrix

9:13 PM Data Cleaning Data management Data Processing
Dear statalist, I have a matrix in which two or more columns are exactly same. Is there some way of keeping one of them and dropping all o...
Subsetting twice with independent group t-tests

Subsetting twice with independent group t-tests

9:13 PM Data Cleaning Data management Data Processing
I'm looking to use an independent group t-test to compare the difference between students' grade estimates and their assigned grades...
Combining Shapefiles and the households survey data

Combining Shapefiles and the households survey data

7:27 PM Data Cleaning Data management Data Processing
Hello! I am working with the household survey with the Household Geocodes displaced at 10km buffer and an external shapefile. I converted a...
Inequality analysis

Inequality analysis

6:27 PM Data Cleaning Data management Data Processing
Hi, I’am new in this forum, I don’t know if I posted in good place for my question, this is my first message. I’am taking class about Inequ...
Fitting Gompertz distribution using streg

Fitting Gompertz distribution using streg

6:27 PM Data Cleaning Data management Data Processing
Hello, I want to know how can I restrict the hazard rate (γ) ancillary parameter to be strictly positive while fitting Gompertz distributi...
merging different levels of data

merging different levels of data

5:27 PM Data Cleaning Data management Data Processing
I have three datasets that I want to merge for multilevel regression. The first one is individual-level survey data (afro6new). The other tw...
Creating a balanced dataset

Creating a balanced dataset

5:57 AM Data Cleaning Data management Data Processing
Dear all, I am currently attempting the following task. I have a country-product-year dataset (91 countries, 27 years from 1991-2016) whic...
Testing differences in abnormal returnsusing estudy

Testing differences in abnormal returnsusing estudy

4:57 AM Data Cleaning Data management Data Processing
Hello, I am currently performing an event study. I have a Sample of 84 european banks with daily returns calculated on closing Stock prices...
prevent pagebreak in table putdocx

prevent pagebreak in table putdocx

4:27 AM Data Cleaning Data management Data Processing
Hi I making summary tables in putdocx looping through 100+ cities. The problem is that pagebreaks occur in the middle of tables. It is not ...
Spmatrix creating empty weighting matrices

Spmatrix creating empty weighting matrices

4:27 AM Data Cleaning Data management Data Processing
Hi, I'm trying to do a very standard spatial analysis. The aim is to run ML and 2SLS estimations with spregress. I've successfully...
Interquartile range

Interquartile range

4:27 AM Data Cleaning Data management Data Processing
Hello, Please can anyone advise how I generate the interquartile range? I have a data example for age here: Code: . sum age, detail ...
Imputation

Imputation

3:27 AM Data Cleaning Data management Data Processing
Hey guys, I work with panel data and I have the following problem. I've dummy variables from 2 years (2002/2007), but I need to crea...
Gologit2 autofit option

Gologit2 autofit option

3:27 AM Data Cleaning Data management Data Processing
Hi, I have developed a gologit2 with autofit option. My dependent variable is Prudence coded as 1 low, 2 neutral, 3 high. I obtained two mod...
Exogenous variables in Olley and Pakes estimation (opreg)

Exogenous variables in Olley and Pakes estimation (opreg)

3:27 AM Data Cleaning Data management Data Processing
Hello, I want to estimate a Cobb-Douglas production function with Stata's opreg command as explained here: https://journals.sagepub....
Matching within certain intervals in the list of matching variables

Matching within certain intervals in the list of matching variables

3:27 AM Data Cleaning Data management Data Processing
Hi everyone, I'm planning to match cases and controls based on age (within 3 years), gender, index date (within 3 years – index date is...
Reshape long to wide

Reshape long to wide

3:27 AM Data Cleaning Data management Data Processing
Hi everyone, Im a newbie in stata and will really appreciate if somebody will help me. I have searched the forum, but haven't found a...
Panel GARCH Model?

Panel GARCH Model?

3:27 AM Data Cleaning Data management Data Processing
Dear all, I am attempting to estimate a panel EGARCH-M model in STATA, as of yet I have had no luck. Has anyone been successful in doing s...
Year and Month fixed effects

Year and Month fixed effects

3:27 AM Data Cleaning Data management Data Processing
Hi, I would like to run a regression with year month fixed effects. My data consists of year and months but I am unsure how I should inclu...
Boxplot in complex design survey

Boxplot in complex design survey

3:27 AM Data Cleaning Data management Data Processing
Dear Statalist users: I have a data set with weight syntax as below, How can I run a box plot with weight.? svyset province [pweight=c_w...
cmp multivariate probit

cmp multivariate probit

3:27 AM Data Cleaning Data management Data Processing
Hi, I am running a multivariate probit model using the cmp function on 4 binary dependent variables.Yesterday I ran the model several time...
How to correct the alignment of output

How to correct the alignment of output

1:27 AM Data Cleaning Data management Data Processing
I am doing data cleaning and the output is hard to clean because of how it is coming out. For some tables there are a lot of things which I ...
Standard Errors FE IV Regression, Panel Data

Standard Errors FE IV Regression, Panel Data

12:27 AM Data Cleaning Data management Data Processing
Hello, I am working with StataIC16, and with Panel Data, where i=550 and t=6. To determine the effect of expenditure on test schore perfor...
GMM on static models

GMM on static models

12:27 AM Data Cleaning Data management Data Processing
Hi, I was wondering if is it possible to use the GMM (xtabond2) on a static model. I'm aware that the GMM on dynamic models require GMM-...
qlqc30 error

qlqc30 error

Thursday, February 27, 2020 Data Cleaning Data management Data Processing
Can anyone explain/solve this problem? . qlqc30, filename("mira_feb_2020_kun_baseline.dta") version(3) grp(1) (ComparisonOfTran...
randomly choosing a sub-group of items

randomly choosing a sub-group of items

11:27 PM Data Cleaning Data management Data Processing
I would like to generate a random 10 variables from a set of 42 variables and I wonder how i could do it in stata 14.2. Basically, we asked ...
Multiple industry variables

Multiple industry variables

10:27 PM Data Cleaning Data management Data Processing
Hello, I'm using STATA 15, SE. I'm facing an issue, trying to come up with a way to control for industry fixed effects in my reg...
no room to add more variables

no room to add more variables

9:27 PM Data Cleaning Data management Data Processing
Hi, I am using PSID data set. I believe it is a very large data set. Stata tells me: no room to add more variables Up to 2,048 variables ...
Reshaping data from wide to long panel-data

Reshaping data from wide to long panel-data

5:27 PM Data Cleaning Data management Data Processing
Good day, I recently reshaped my dataset from wide to long into balanced panel dataset. Clyde Schechter has been so gracious in helping m...
Recoding Values of A Variable based on conditions

Recoding Values of A Variable based on conditions

5:27 PM Data Cleaning Data management Data Processing
Hello, I am stuck with a problem. I hope someone can help me to find the answer. The first part of the problem is -Write codes that prints...
Bootstrap with 2 way fixed effects in panel data using reghdfe

Bootstrap with 2 way fixed effects in panel data using reghdfe

7:57 AM Data Cleaning Data management Data Processing
Dear Statalist, I am estimating a model of House Price shocks on divorce rates. I am using the reghdfe command with county and time fixed ...
Calculate normalized euclidean distance

Calculate normalized euclidean distance

7:27 AM Data Cleaning Data management Data Processing
Hi all, The Euclidean distance matrix could be obtained by using Code: use http://www.stata-press.com/data/r10/iris.dta,clear matrix di...
Frequency weight in a before and after graph (twoway pccapsym)

Frequency weight in a before and after graph (twoway pccapsym)

6:57 AM Data Cleaning Data management Data Processing
Hi. I have a data set where I look at number of events before and after a certain time-point. I want to show this in a before and after gr...
Creating a new variable based on the value of other variables

Creating a new variable based on the value of other variables

5:57 AM Data Cleaning Data management Data Processing
Hi all, I have created a categorical variable (values 1 through 5) in excel based on certain characteristics of US states in a 20 year tim...
Selected Graphs for Panel Data Categories

Selected Graphs for Panel Data Categories

3:57 AM Data Cleaning Data management Data Processing
Hi, I'm new to Stata and I'm trying to get some panel-times series graphs for selected countries. Specifically, I got a dataset co...
attnd

attnd

3:27 AM Data Cleaning Data management Data Processing
Hi I am using survey data and I want to use sample weights for estimating attnd and attk after running psmatch2. How can I do that? Thank...
Gravity model - PPML fixed-effect estimation

Gravity model - PPML fixed-effect estimation

3:27 AM Data Cleaning Data management Data Processing
Dear all, I am doing a study on how Brexit can impact the EU export by using the gravity model. My sample is a panel data, in which 28 EU ...
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)
      • Merging two panel datasets
      • Help needed to fix GMM iteration problem
      • Margins for Interaction Term
      • What kind of a binary regression model should I ch...
      • Difference between quietly gen, quietly test and q...
      • Combining a newly constructed dummy variables to o...
      • Computing IPW estimator by hand
      • New to SSC mbitobit - Bivariate Tobit model
      • hausman test problem
      • Bar Chart Percentiles
      • Kolmogorov – Smirnov Test for panel database
      • Create a new variable based on observations within...
      • How to load in the vertex attributes in network
      • How to add a constraint when matching using teffec...
      • How to genearte the list of vars for nodes using n...
      • Define nested loops for dependent and independent ...
      • Two Stage Least Squares with multiple Fixed Effect...
      • Dropping repeated columns from a matrix
      • Subsetting twice with independent group t-tests
      • Combining Shapefiles and the households survey data
      • Inequality analysis
      • Fitting Gompertz distribution using streg
      • merging different levels of data
      • Creating a balanced dataset
      • Testing differences in abnormal returnsusing estudy
      • prevent pagebreak in table putdocx
      • Spmatrix creating empty weighting matrices
      • Interquartile range
      • Imputation
      • Gologit2 autofit option
      • Exogenous variables in Olley and Pakes estimation ...
      • Matching within certain intervals in the list of m...
      • Reshape long to wide
      • Panel GARCH Model?
      • Year and Month fixed effects
      • Boxplot in complex design survey
      • cmp multivariate probit
      • How to correct the alignment of output
      • Standard Errors FE IV Regression, Panel Data
      • GMM on static models
      • qlqc30 error
      • randomly choosing a sub-group of items
      • Multiple industry variables
      • no room to add more variables
      • Reshaping data from wide to long panel-data
      • Recoding Values of A Variable based on conditions
      • Bootstrap with 2 way fixed effects in panel data u...
      • Calculate normalized euclidean distance
      • Frequency weight in a before and after graph (twow...
      • Creating a new variable based on the value of othe...
      • Selected Graphs for Panel Data Categories
      • attnd
      • Gravity model - PPML fixed-effect estimation
      • Keeping only unique combination of observations in...
      • What is the best method to test these relationship...
      • Different number of decimals for different scalars...
      • Measuring Spells - two special cases in panel data
      • GEE: results significant only with independent and...
      • DOS windows how to remove it
      • Variable types for regressions
      • Extracting Year From Date
      • Obtaining marginal effects for all possible predicts
      • How to produce a table that shows the estimates of...
      • [HELP] Destring Variables Dilema
      • Duplicates list full pieces of observations
      • I want to run a VAR with bootstrap standard errors
      • Storing values of a multivariate regression
      • Guidance on Multilevel Modeling
      • Problem with margins in multilevel random slope an...
      • ivreg2
      • Operations with egen variables and export to Excel...
      • IV Regression Validity of Instruments, xtivreg 2, ...
      • Setting up spatial data for spatial regressions
      • Simulating skewed variable bound by zero
      • Constraints does not work in gsem
      • "prodest"- the markup estimate of the first year o...
      • Coefficient comparison across two sub-samples regr...
      • Comparing regression coefficients of different ind...
      • Maximum slope of learning curve
      • reliability rasch model -
      • Need a clarification regarding the Difference in D...
      • using input in stata for file name
      • Pearson's chi square test when data are in conting...
      • How to Interpret the results of Discriminant Analysis
      • Panel Data Fixed Effect - Autocorrelation Problem
      • Using Predict or forecast after a dynamic model
      • Data set of gravity model in stata
      • Help on VECM
      • Create string variable that copies all string lett...
      • about tuples:why observation numbers are out of ra...
      • Rename variables numerically through loop
      • Panel data random effects with small n and large t...
      • REGHDFE and tests for serial correlation
      • Scatterplots with weighted marker size revisited
      • GSEM with "observed" but "treated-as-latent" varia...
      • Assign (A,B) and (B,A) to the same group?
      • How to find controls in cross sectional data
      • Interaction term omitted due to collinearity
      • putexcel query
      • Robustness Checks - coefficients unchanged, but ad...
    • ►  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