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
cluster 2 varlist not allowed

cluster 2 varlist not allowed

Monday, November 30, 2020 Data Cleaning Data management Data Processing
Hi, I'm replicating a report, and this is the attached do-file use wintertime_final, clear gen snodas_weighted=snodas_max+(.25+.125*w...
Specific Values of Variables and creating a new Variable

Specific Values of Variables and creating a new Variable

8:25 PM Data Cleaning Data management Data Processing
Hello, I am trying to takes 3 variables and take a specific value from that variable, and create a new variable with this.I am trying to t...
Terrible parallelization performance in Mata

Terrible parallelization performance in Mata

6:25 PM Data Cleaning Data management Data Processing
I just ran an example from the SJ paper about boottest ("Fast and Wild") and was surprised at its poor performance. I'm fortu...
Replace missing values with those of previous values or those of the partner

Replace missing values with those of previous values or those of the partner

5:25 PM Data Cleaning Data management Data Processing
Hi Statalist. I am using annual survey responses on marital status from a panel study (for each partner in a couple - married/cohabitation...
Lincom for interpreting interactions in logistic regression

Lincom for interpreting interactions in logistic regression

4:25 PM Data Cleaning Data management Data Processing
Hello, I am estimating, for example, the following double-difference / difference-in-difference logistic regression where opt_dum, depstat...
Plot Transition Matrix on a Graph

Plot Transition Matrix on a Graph

9:25 AM Data Cleaning Data management Data Processing
Hi all, I would like to plot in a graph the transition matrix from employment to employment (EtoE), unemployment to employment (UtoE), une...
Twoway graph with two bars in one diagram

Twoway graph with two bars in one diagram

9:25 AM Data Cleaning Data management Data Processing
Hello everyone, I am new to Stata and currently trying to create a bar chart that shows GDP data from two different countries over a certa...
Sum of dummy variable up until the point of observation

Sum of dummy variable up until the point of observation

9:25 AM Data Cleaning Data management Data Processing
Dear STATALIST forum, I have a question about generating a variable that depicts the sum of a dummy variable up until point x. To help you...
Let values continue

Let values continue

9:25 AM Data Cleaning Data management Data Processing
Hello, can someone tell me the command how to do what is shown on the screenshot. You copy the values of another variable and then pull it ...
Intercepts at knots in mixed

Intercepts at knots in mixed

9:25 AM Data Cleaning Data management Data Processing
Dear all, I am currently working on a mixed model with incorporation of knots at specific timepoints to compare the course over time betwe...
distribution explanatory variable for different birth cohorts

distribution explanatory variable for different birth cohorts

8:25 AM Data Cleaning Data management Data Processing
Hi there, I'm struggling to understand part of a assignment that I need to do. I have to examine whether education has an effect on ...
tabstat of multiple dummy variables

tabstat of multiple dummy variables

8:25 AM Data Cleaning Data management Data Processing
Hello, I have a large dataset of N = 59,000,000. I have a set of diagnoses dummy variables a00_a09 - u_unclassified, and a set of servic...
Confidence-interval plots / any plot : resize possible?

Confidence-interval plots / any plot : resize possible?

8:25 AM Data Cleaning Data management Data Processing
Dear Statalisters My question, basically, is whether there is a 'correct' way to resize Stata graphs (including the background reg...
How to perform NLS estimation with a complex function

How to perform NLS estimation with a complex function

7:25 AM Data Cleaning Data management Data Processing
Dear Stata users, I need to use NLS to estimate the following equation describing the so-called Bass diffusion model: y t = m * [ ( (1...
Endogeneity & dropping of constraints

Endogeneity & dropping of constraints

7:25 AM Data Cleaning Data management Data Processing
Hi, I am doing Durbin–Wu–Hausman test to test my independent variables for endogeniety. My data is cross sectional and I have a matched ...
Hausman test/Estimating pmg,mg, dfe

Hausman test/Estimating pmg,mg, dfe

6:25 AM Data Cleaning Data management Data Processing
Good afternoon I am estimating a dynamic model with pmg, mg and dfe. the study has to do with the application of the kuznets curve to CO2...
Subsample dataset under multiple conditions

Subsample dataset under multiple conditions

6:25 AM Data Cleaning Data management Data Processing
Windows 10 Stata 16 Code: * Example generated by -dataex-. To install: ssc install dataex clear input long region str6 gender float age...
Looping to create a difference score

Looping to create a difference score

6:25 AM Data Cleaning Data management Data Processing
Hello all, I am working on a project where I need difference scores. I will have a number of difference scores, so typing the command over...
Cross tabulations based on multiple dummy variables

Cross tabulations based on multiple dummy variables

4:25 AM Data Cleaning Data management Data Processing
Hello, I have a large dataset for N= 59,000,000 observations. I have 154 dummy variables relating to a set of diagnosis codes, and 173 d...
Ordered Probit with 2 continuous interaction term

Ordered Probit with 2 continuous interaction term

4:25 AM Data Cleaning Data management Data Processing
Hello all, I am doing an ordered probit regression as follows: Y takes the value from 1 to 10 X is a continuous variable Z is also a con...
Interaction terms on robust standard errors result in no F-stat and p-value

Interaction terms on robust standard errors result in no F-stat and p-value

4:25 AM Data Cleaning Data management Data Processing
Hi all, I am currently experiencing some difficulties with my model, and I hope you will be able to help me. When I'm running my regr...
marginal effects in hurdle model

marginal effects in hurdle model

3:25 AM Data Cleaning Data management Data Processing
Dear All I'm fitting a hurdle model (with the command churdle linear) and use the margin (margins, dydx(CategoricalVariable)). I wonde...
Intra-Day Data Differences

Intra-Day Data Differences

3:25 AM Data Cleaning Data management Data Processing
Hi, I am working with the following intra-day data. Code: * Example generated by -dataex-. To install: ssc install dataex clear input ...
Merging data

Merging data

3:25 AM Data Cleaning Data management Data Processing
Dear all, I want to merge data from two different datasets. The first has only one observation per firm(CUSIP) for a given year, as shown....
Anyone want to do my homework?

Anyone want to do my homework?

1:25 AM Data Cleaning Data management Data Processing
Anyone want to do a statistics assignment for me? I am strugglinggg. It's an elementary course for Stata and I'm suppose to analyze ...
expression too long r(130) while specifying starting values

expression too long r(130) while specifying starting values

1:25 AM Data Cleaning Data management Data Processing
I am using sfpanel() command and I need to set initial values for the variables before running the regression. In order to set the initial ...
Combining multiple variables

Combining multiple variables

Sunday, November 29, 2020 Data Cleaning Data management Data Processing
Hello! I just started learning Stata and I am using a consensus data set and trying to combine a bunch of different variables to make one ...
Combining multiple variables

Combining multiple variables

11:25 PM Data Cleaning Data management Data Processing
Hello! I jsut started learning Stata and I am using a consensus data set and trying to combine a bunch of different variables to make one ...
Split file by group i.e. group 1 (non clinical) vs group 2 (clinical)

Split file by group i.e. group 1 (non clinical) vs group 2 (clinical)

9:25 AM Data Cleaning Data management Data Processing
Hi there, Might someone please advise how I split my Stata dataset by 1 variable "Group" which is has two levels 1 (non clinical...
Control variable that varies accross time but not accros countries how to add to dataset and regression

Control variable that varies accross time but not accros countries how to add to dataset and regression

8:25 AM Data Cleaning Data management Data Processing
Hello everyone, For my regression i am using the VIX as a proxy for volatility and the TED spread as a proxy for the global risk free rate...
Quintile Sorting two variables

Quintile Sorting two variables

7:25 AM Data Cleaning Data management Data Processing
I have monthly observations from various funds over along amount of time but the time series are unbalanced. For each fund I have an average...
Displaying results in full form - double format

Displaying results in full form - double format

7:25 AM Data Cleaning Data management Data Processing
Hi All, I am using the following command, in stata 13.1 total subsidyamt, over(fiscal_year1) to calculate the total amount of subsidy ...
Very weird spmap problem: "master data not sorted"

Very weird spmap problem: "master data not sorted"

7:25 AM Data Cleaning Data management Data Processing
Hello all Suddenly, I am having some unexplained problem with spmap: syntax which previously was working now does not anymore, reporting t...
R2 difference from different regressions

R2 difference from different regressions

7:25 AM Data Cleaning Data management Data Processing
Array Hello, i'm working on replicating Peters and Taylor(2016) i want to know how to compare R^2 from different regressions like pane...
Year and industry fixed efffects

Year and industry fixed efffects

6:25 AM Data Cleaning Data management Data Processing
Hello; I have a paneldataset of the S&P 500 from 2002 to 2019 and need to implement industry and year fixed effects. However i get t...
An issue using esttab syntax

An issue using esttab syntax

6:25 AM Data Cleaning Data management Data Processing
Hello, I would like to show the `y' variable in excel when running each of the following regressions using "esttab" syntax. I...
How to rename and format variables from appended tempfile?

How to rename and format variables from appended tempfile?

6:25 AM Data Cleaning Data management Data Processing
Hi Statalist, I'm trying to append, rename, format and generate new variables. may goals are to; 1. rename variables "SCH_ID...
Comparing independent variables in different models with the samen depedent variable

Comparing independent variables in different models with the samen depedent variable

3:25 AM Data Cleaning Data management Data Processing
Hello, I am running three multiple linear regression models. In all three, the dependent variable is the democracy index score of a range ...
Latent class analysis - constraining categorical variables

Latent class analysis - constraining categorical variables

3:25 AM Data Cleaning Data management Data Processing
Hi Statalist! I am trying to perform a latent class analysis and I am very new to this method, so I hope you will understand if my questio...
Testing significance for Alphas CAPM

Testing significance for Alphas CAPM

2:25 AM Data Cleaning Data management Data Processing
Hello everybody, I have calculated monthly alphas and betas for monthly fund data from different portfolioids. How can I test the statisti...
Survey data- Pool Cross Sectional data with weights- What to do with weights?

Survey data- Pool Cross Sectional data with weights- What to do with weights?

12:25 AM Data Cleaning Data management Data Processing
Dear all, I have a pooled cross sectional data ( weakly balanced, 9 different years wealth and income data for individuals belonging to 4...
Loops to make variables compatible

Loops to make variables compatible

Saturday, November 28, 2020 Data Cleaning Data management Data Processing
Hi, I have a variable which has been coded differently in two datasets. (old one for year 2000 and new one for year 2005 ) Old codes are...
IPTW - strategies

IPTW - strategies

11:25 PM Data Cleaning Data management Data Processing
Hi everyone, I'm evaluating whether increased dosage (number of completed sessions) of an behaviour change therapeutic program, is ass...
creating a loop

creating a loop

10:25 PM Data Cleaning Data management Data Processing
Hi guys: as you can see, below are four parts of repetitive codes, and the only difference is ccode2 (31, 40, 41, 42). so i am wondering if...
Panel index within group

Panel index within group

10:25 PM Data Cleaning Data management Data Processing
Hey there, I like to create a new column indicating the occurrence of non-missing BAM within each id. For example, a new column named "...
Question: Generating summary statistics table with tabstat and table

Question: Generating summary statistics table with tabstat and table

7:25 PM Data Cleaning Data management Data Processing
Dear all, I have recently attempted to generate a descriptive statistic table with the command Code: tabstat govtdebt metrde, statisti...
Fitting two lines using aaplot

Fitting two lines using aaplot

7:25 PM Data Cleaning Data management Data Processing
Dear All, Is it possible to fit two lines (i.e. more than two variables) using the aaplot command? If yes, will appreciate any possible he...
Time fixed effects as dummies change significance

Time fixed effects as dummies change significance

6:25 PM Data Cleaning Data management Data Processing
Dear Statalist, I am doing research on using nighttime light (radiances per area) to predict real regional GDP (random effect model). I hav...
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)
      • cluster 2 varlist not allowed
      • Specific Values of Variables and creating a new Va...
      • Terrible parallelization performance in Mata
      • Replace missing values with those of previous valu...
      • Lincom for interpreting interactions in logistic r...
      • Plot Transition Matrix on a Graph
      • Twoway graph with two bars in one diagram
      • Sum of dummy variable up until the point of observ...
      • Let values continue
      • Intercepts at knots in mixed
      • distribution explanatory variable for different bi...
      • tabstat of multiple dummy variables
      • Confidence-interval plots / any plot : resize poss...
      • How to perform NLS estimation with a complex function
      • Endogeneity & dropping of constraints
      • Hausman test/Estimating pmg,mg, dfe
      • Subsample dataset under multiple conditions
      • Looping to create a difference score
      • Cross tabulations based on multiple dummy variables
      • Ordered Probit with 2 continuous interaction term
      • Interaction terms on robust standard errors result...
      • marginal effects in hurdle model
      • Intra-Day Data Differences
      • Merging data
      • Anyone want to do my homework?
      • expression too long r(130) while specifying starti...
      • Combining multiple variables
      • Combining multiple variables
      • Split file by group i.e. group 1 (non clinical) vs...
      • Control variable that varies accross time but not ...
      • Quintile Sorting two variables
      • Displaying results in full form - double format
      • Very weird spmap problem: "master data not sorted"
      • R2 difference from different regressions
      • Year and industry fixed efffects
      • An issue using esttab syntax
      • How to rename and format variables from appended t...
      • Comparing independent variables in different model...
      • Latent class analysis - constraining categorical v...
      • Testing significance for Alphas CAPM
      • Survey data- Pool Cross Sectional data with weight...
      • Loops to make variables compatible
      • IPTW - strategies
      • creating a loop
      • Panel index within group
      • Question: Generating summary statistics table with...
      • Fitting two lines using aaplot
      • Time fixed effects as dummies change significance
      • Adding auxiliary variables in a model
      • Imposing two parameter entries are equal in impact...
      • Retrieve the numeric value of a label
      • r601 error - file C:\Users\admin\AppData\Local\Tem...
      • using nlcom to calculate combinations of parameter...
      • creating a loop for multiple regressions
      • Stata ignores else condition in if-else blocks wit...
      • Euler's Number in Stata
      • Merging certain variables whilst matching ID number
      • issue when converting from panel to pooled cross s...
      • Interpretation of coefficients
      • Graph dummy variable
      • Cumulative frequency of unique values within groups
      • Within Estimator Stata
      • Changing Axis Range - Pre Saved .gph
      • How to find the matched observation with nearest M...
      • Cox-Model with very few observations
      • Aggregating Weekly Data to Monthly
      • Graph: display negative sign using en-dash instead...
      • Graph: couldn't get the looking of apostrophe right
      • Command for estimating household consumption aggre...
      • repeating a smoothing function in a time series
      • Collapsing unique country names and country IDs
      • Which robust standard error to choose - panel data...
      • Mrprobit
      • Use of mse with arima predict command (Stata MP 16.1)
      • Effect on aggregate supply with a DiD regression f...
      • Creating dummy variable
      • Survival Analysis at specific time point, ltable v...
      • Economic student that needs some help with date an...
      • Conceptual/statistical question about supop().
      • The overall age-standardised rate (ASR) with 95% CI
      • ARDL - SR and LR Elasticities
      • replacing missing values
      • regressions
      • Fama French
      • Using -atjoint- in -margins- targeting only one at...
      • spell-type data/survival time analyses
      • meta regress - STATA16
      • Simultaneous equation model with dynamic panel
      • Allocating cases to the class with the highest pro...
      • Setting Stub
      • DiD and Matching
      • Is the normalized dependent variable suitable for ...
      • Fractional or beta regression, with weights that r...
      • MATA Error "Nothing found where while expected"
      • Interaction terms for two dummies
      • Hausman Test
      • Generating dependent variables for country pairs
      • Rolling Window Regression CAPM
      • Interaction terms giving error "factor variables m...
      • Margins of an interaction after xtlogit, re
    • ►  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