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
Between subjects error term for three-way repeated measures anova

Between subjects error term for three-way repeated measures anova

Saturday, July 31, 2021 Data Cleaning Data management Data Processing
I have been having some difficulties trying to run a three-way, repeated measures anova. I have made several attempts to try and run this su...
Panel Data Regression and ANOVA

Panel Data Regression and ANOVA

8:23 PM Data Cleaning Data management Data Processing
Hi, I am using panel data for US manufacturing companies for the period 2000-19. I am focusing on the impact of international diversificat...
Find value starting with a pattern ( similar to LIKE operator in SQL)

Find value starting with a pattern ( similar to LIKE operator in SQL)

8:23 PM Data Cleaning Data management Data Processing
Hello ALL, I am new to Stata, I have a small doubt, Any Help would be greatly appreciated. TABLE1(.dta) Column1 Column2 Column3 Co...
mata mlib create

mata mlib create

5:23 PM Data Cleaning Data management Data Processing
I'm having trouble with mata mlib create . I can't see to get a mata library set up anywhere
Changes in Control/Treatment groups after PSM

Changes in Control/Treatment groups after PSM

4:23 PM Data Cleaning Data management Data Processing
Dear friends, Hi. As in the previous post, Hi All, In case anyone viewing this thread is interested, here's the code to do wha...
Trying to calculate time length for hospital episodes of multiple consec. rows, but also multiple nested within one 'person'

Trying to calculate time length for hospital episodes of multiple consec. rows, but also multiple nested within one 'person'

4:23 PM Data Cleaning Data management Data Processing
Hi STATALIST, First time poster here. I am hoping someone can assist with my hospital record data calculations of nested episodes length of...
Set colors

Set colors

2:23 PM Data Cleaning Data management Data Processing
Sorry, I have asked this before. But now I have two computers and have spend an hour with help and the manuals and can 't remember how t...
local macro and loop

local macro and loop

2:23 PM Data Cleaning Data management Data Processing
Hi Statalist, I am trying to use a local macro with a foreach loop to clean up some vars. Here is my code: Code: local yn1 q1 q2 q7 q8 q...
Modelling temporal dependence in within-between "hybrid" models

Modelling temporal dependence in within-between "hybrid" models

11:23 AM Data Cleaning Data management Data Processing
Dear Statalisters, I would like to know how to properly specify a temporal variable in within-between "hybrid" random effects mo...
Marginal effects for group comparisons in probit regression

Marginal effects for group comparisons in probit regression

9:23 AM Data Cleaning Data management Data Processing
Hi all, I am trying to use a probit model to analyze a bunch of interaction effects for a binary dependent variable in a probit model. My ...
Idiosyncratic Skewness

Idiosyncratic Skewness

8:23 AM Data Cleaning Data management Data Processing
I run the below code on appended dataset to calculate monthly idiosyncratic skewness as skewness of residuals obtaining by regressing previo...
Likehood ratio test showing error

Likehood ratio test showing error

7:23 AM Data Cleaning Data management Data Processing
Dear colleagues, can someone kindly assist me in identifying problem while you likelihood ratio test in this data.Am getting the error messa...
DSGE model relating-questions

DSGE model relating-questions

6:23 AM Data Cleaning Data management Data Processing
Christiano,2017, abstract stated that Macroeconomic policy questions involve trade-offs between competing forces in the economy . The probl...
Combine two dataset and matching

Combine two dataset and matching

6:23 AM Data Cleaning Data management Data Processing
Hello Everyone, I have a problem with two different datasets with not the exact name, which makes it hard to match. For example, the first...
Creating spine variables for regression

Creating spine variables for regression

6:23 AM Data Cleaning Data management Data Processing
I am hoping someone can help me. I have a time variable coded as months from Jan 2016 to Feb 2020 I am hoping to fit some splines to my re...
Fuzzy Regression Discontinuity estimates and plots do not match

Fuzzy Regression Discontinuity estimates and plots do not match

6:23 AM Data Cleaning Data management Data Processing
I'm using the ssc packages rdrobust and rdplot to estimate and plot the fuzzy RD estimates of a regression of expenditure on population,...
Test with panel data

Test with panel data

3:23 AM Data Cleaning Data management Data Processing
Hi, This is my first post in this forum, hoping to get some help. I am doing a test on a panel data from year 2000-2020 which should be or...
Categorical variable as an instrument

Categorical variable as an instrument

2:23 AM Data Cleaning Data management Data Processing
Hello, We are running a model with a binary endogenous X variable and a continuous Y variable. We potentially want to instrument our X var...
Cluster standard errors in SUR estimation - sureg or gsem?

Cluster standard errors in SUR estimation - sureg or gsem?

2:23 AM Data Cleaning Data management Data Processing
Hi, I am trying to estimate vote shares of different parties. So, I have 3 parties, each having its own column in the data set. Hence, the...
ttesti: using se as input instead of sd

ttesti: using se as input instead of sd

Friday, July 30, 2021 Data Cleaning Data management Data Processing
Hi everyone, I am trying to calculate the independent t-test using ttesti which requires mean, sd, and sample size. Given that I do not hav...
do we have simpler syntax to realize this goal?

do we have simpler syntax to realize this goal?

8:23 PM Data Cleaning Data management Data Processing
Code: if lnEmployee1Y ~=. & lnCash1Y~=. & lnTtlAsset1Y~=. & stdRevenue1Y~=. & stdNetProfit1Y~=. & lnRDExp1Y~=. Thanks...
PPML and fixed effects commands

PPML and fixed effects commands

6:23 PM Data Cleaning Data management Data Processing
Good evening, guys. I'm currently working on a gravity model with PPML estimator. Here is the thread: I'm using a book from Yotov et...
reshape error

reshape error

4:23 PM Data Cleaning Data management Data Processing
Hi, I am trying to reshape from wide to long, but it keeps saying that "variable id does not uniquely identify the observations". ...
Exact matching on Propensity Score Matching

Exact matching on Propensity Score Matching

3:23 PM Data Cleaning Data management Data Processing
Dear Stata Forum, I’m trying to perform a Propensity Score Matching with exact matching but found most examples on years using double, whi...
Converting Stata version 16 to Stata version 12 with Stat/Transfer in Linux

Converting Stata version 16 to Stata version 12 with Stat/Transfer in Linux

3:23 PM Data Cleaning Data management Data Processing
Dear Forum Members, I have some Stata version 16 data files, which I would like to convert to Stata version 12 files. I know that I can us...
post and postfile help after regression

post and postfile help after regression

3:23 PM Data Cleaning Data management Data Processing
I am running a simple regression repeated for ~1,000 variables in a loop. I would like to capture the beta coefficients, se, and p values fo...
Question about "spxtregress, re sarpanel" and serial correlation

Question about "spxtregress, re sarpanel" and serial correlation

2:24 PM Data Cleaning Data management Data Processing
Recently saw this tweet from Jeffrey Wooldridge and it made me question my understanding of how spxtregress, re sarpanel models are capabl...
Dropping unnecessary variable from BRFSS data to save space

Dropping unnecessary variable from BRFSS data to save space

2:24 PM Data Cleaning Data management Data Processing
Is there any efficient way to keep the variables I need and drop all the unnecessary variables ? In BRFSS , I need to clean year by year and...
fe and first-difference estimator with controls and weight in baseline year

fe and first-difference estimator with controls and weight in baseline year

1:23 PM Data Cleaning Data management Data Processing
I have been learning from Statalist for some years now. Thank you for being there for us! First time I ask a question as I normally find sol...
How to force vertical lines to be above of all horizontal lines using twoway

How to force vertical lines to be above of all horizontal lines using twoway

9:24 AM Data Cleaning Data management Data Processing
Dear all, How do I force the gray area to be above the yellow areas in the graph below? Code: clear set obs 100 gene x = runiform() ge...
Drop if in range

Drop if in range

7:23 AM Data Cleaning Data management Data Processing
Hello, how can I drop a group if there is a missing value in any variable per group. In the example blow, my group is identified by "...
Interaction analysis - Problematic Wald test results

Interaction analysis - Problematic Wald test results

6:24 AM Data Cleaning Data management Data Processing
-
Marginal effects at representative values

Marginal effects at representative values

5:24 AM Data Cleaning Data management Data Processing
Dear all, I am working with Stata's margins command and have some difficulties to interpret the meaning of "marginal effects at r...
Generating sequence of observations.

Generating sequence of observations.

5:24 AM Data Cleaning Data management Data Processing
Hi, I have the "have" variable and based on that "have" variable, I want to generate the two variables, i.e., "want...
NA's in sureg()

NA's in sureg()

4:23 AM Data Cleaning Data management Data Processing
Hi, How are NAs in the dependent variable column dealt for in sureg()? I want to estimate a system of 4 equations using sureg(), where al...
r(198) invalid varname

r(198) invalid varname

3:23 AM Data Cleaning Data management Data Processing
Hello , I do not know why stata tell me "r(198)invalid varname. " I check it for several times. I hope I recieve your assistance s...
How to generate the column before a column

How to generate the column before a column

3:23 AM Data Cleaning Data management Data Processing
Sorry if this has been asked before I have dataset containing var1 and var2. I want to generate a new variable(var3), such that it matches...
Forloop: too many variables specified r(103) error

Forloop: too many variables specified r(103) error

2:23 AM Data Cleaning Data management Data Processing
Hello, I've been around for a year on this community, but this is my first post. I am running a forloop, and it gives me this error: t...
Repeatedly obtain values after a certain condition holds and ignore observations inbetween

Repeatedly obtain values after a certain condition holds and ignore observations inbetween

2:23 AM Data Cleaning Data management Data Processing
Hi all! I would really appreciate your help with the following: I have obtained buy signals from stock data close prices for every 5 minut...
What is the required sample size to use Panel VAR in Stata?

What is the required sample size to use Panel VAR in Stata?

12:23 AM Data Cleaning Data management Data Processing
Dear researchers, please I would like to ask this question: I have a yearly dataset covering 35 countries and with 3 variables. The idea fo...
Calibration plot for logistic regression models

Calibration plot for logistic regression models

Thursday, July 29, 2021 Data Cleaning Data management Data Processing
I want to perform a calibration plot for several logistic regression models like this. But I did not find how to do it with Stata. Thanks i...
Problem with Merging

Problem with Merging

11:23 PM Data Cleaning Data management Data Processing
Hi, I am trying two merge two datasets using the key ID (Neighborhood_Code). However, Im getting the error " Each key variable -- t...
Obtain very different results using -xtreg- and -margins- / can I store the results from -margins- in a table

Obtain very different results using -xtreg- and -margins- / can I store the results from -margins- in a table

8:23 PM Data Cleaning Data management Data Processing
When I run the interaction between a dummy (0/1) variable (at3) and a categorical variable (vtype), the results from -xtreg- are very differ...
How to group several columns?

How to group several columns?

4:23 PM Data Cleaning Data management Data Processing
I am dealing with data with information of different candidates, the results of each candidate is distributed by class 1, 2, 3, 4 Candidate...
Breusch and Pagan LM test for random effects

Breusch and Pagan LM test for random effects

3:23 PM Data Cleaning Data management Data Processing
Dear community, I am deciding among Pooled OLS, Fixed and Random Effects panel models in the presence of first-order autocorrelation ( nul...
Puzzling Post Hoc Power Calculation

Puzzling Post Hoc Power Calculation

3:23 PM Data Cleaning Data management Data Processing
I was trying to show a colleague that post hoc power calculations are nonsensical with the following example: Code: . /* Congruent Resul...
Applying the Mundlak approach in 3-level hierarchical model. Which is the correct mean of a level-2 variable?

Applying the Mundlak approach in 3-level hierarchical model. Which is the correct mean of a level-2 variable?

8:23 AM Data Cleaning Data management Data Processing
Hello! We have a question about implementing the ‘Mundlak’ approach in a multilevel (3-levels) nested hierarchical model. We have employee...
Error exporting dataset to excel using foreach loop

Error exporting dataset to excel using foreach loop

7:24 AM Data Cleaning Data management Data Processing
Hello, I am trying to export data set to excel using foreach loop in STATA 13.1. But the stata throws the error observations must be betwee...
combining two graphs

combining two graphs

7:24 AM Data Cleaning Data management Data Processing
Hello, Is there a way to combine the scatter plot with the fitted line from the regression with an indicator variable? I am trying to co...
sureg with fixed effects and clustered errors

sureg with fixed effects and clustered errors

7:24 AM Data Cleaning Data management Data Processing
I want to estimate a system of 4 equations, where the Y-Variables sum to one approximately, and so the error terms are correlated. The data ...
Triple Difference and Kernel-based PSM

Triple Difference and Kernel-based PSM

6:26 AM Data Cleaning Data management Data Processing
Dear all, I run differeneces-in-differences regressions with a kernel-based PSM adjustement with the command "diff". I would li...
Import value labels for each variable in a loop in frequency tables generated using putdocx

Import value labels for each variable in a loop in frequency tables generated using putdocx

6:26 AM Data Cleaning Data management Data Processing
Hello, I have been browsing manuals and forums but I have been stuck with this issue and hoping to get some advice. I managed to get frequ...
Contrast statement after multiple imputation

Contrast statement after multiple imputation

5:25 AM Data Cleaning Data management Data Processing
Hi Statalist I am trying to analyse some data collected from a randomised controlled trial using a mixed model. The outcome score is colle...
Graph bar

Graph bar

5:25 AM Data Cleaning Data management Data Processing
Hello, I need to reproduce a similar graph bar to the one attached. It is basically an histogram, but with various subgroups, so I have to...
Interpeting interaction estimation reuslts from regressions

Interpeting interaction estimation reuslts from regressions

5:25 AM Data Cleaning Data management Data Processing
Hi all, My name is Gráinne Gibson and I am currently doing my masters dissertation on the effect of Single-Sex schooling on adolescents no...
Time-varying interaction term with year fixed effects

Time-varying interaction term with year fixed effects

2:26 AM Data Cleaning Data management Data Processing
Hi, I am investigating the effect of a commodity price on conflict. I have created a grid of cells with georeferenced data. I am using xtreg...
Quantile Panel Regression

Quantile Panel Regression

2:26 AM Data Cleaning Data management Data Processing
Hello. I just wanted to know this. How do I exactly know when to use quantile panel regression
multiple values for same value label

multiple values for same value label

2:26 AM Data Cleaning Data management Data Processing
Hi everyone, I am working with a categorical variable called Code: plnowm which expresses the month in which every individual moved int...
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)
      • Between subjects error term for three-way repeated...
      • Panel Data Regression and ANOVA
      • Find value starting with a pattern ( similar to LI...
      • mata mlib create
      • Changes in Control/Treatment groups after PSM
      • Trying to calculate time length for hospital episo...
      • Set colors
      • local macro and loop
      • Modelling temporal dependence in within-between "h...
      • Marginal effects for group comparisons in probit r...
      • Idiosyncratic Skewness
      • Likehood ratio test showing error
      • DSGE model relating-questions
      • Combine two dataset and matching
      • Creating spine variables for regression
      • Fuzzy Regression Discontinuity estimates and plots...
      • Test with panel data
      • Categorical variable as an instrument
      • Cluster standard errors in SUR estimation - sureg ...
      • ttesti: using se as input instead of sd
      • do we have simpler syntax to realize this goal?
      • PPML and fixed effects commands
      • reshape error
      • Exact matching on Propensity Score Matching
      • Converting Stata version 16 to Stata version 12 wi...
      • post and postfile help after regression
      • Question about "spxtregress, re sarpanel" and seri...
      • Dropping unnecessary variable from BRFSS data to s...
      • fe and first-difference estimator with controls an...
      • How to force vertical lines to be above of all hor...
      • Drop if in range
      • Interaction analysis - Problematic Wald test results
      • Marginal effects at representative values
      • Generating sequence of observations.
      • NA's in sureg()
      • r(198) invalid varname
      • How to generate the column before a column
      • Forloop: too many variables specified r(103) error
      • Repeatedly obtain values after a certain condition...
      • What is the required sample size to use Panel VAR ...
      • Calibration plot for logistic regression models
      • Problem with Merging
      • Obtain very different results using -xtreg- and -m...
      • How to group several columns?
      • Breusch and Pagan LM test for random effects
      • Puzzling Post Hoc Power Calculation
      • Applying the Mundlak approach in 3-level hierarchi...
      • Error exporting dataset to excel using foreach loop
      • combining two graphs
      • sureg with fixed effects and clustered errors
      • Triple Difference and Kernel-based PSM
      • Import value labels for each variable in a loop in...
      • Contrast statement after multiple imputation
      • Graph bar
      • Interpeting interaction estimation reuslts from re...
      • Time-varying interaction term with year fixed effects
      • Quantile Panel Regression
      • multiple values for same value label
      • Export*coefficient and standard error of factor va...
      • ivreg2 and interactions of the endogenous regressor
      • Reshaping data for conditional logit modeling
      • Does _parse comma have a bug with identifying unbo...
      • Difference between instrumental variable interacti...
      • Help on storing estimates from multiple regression...
      • identifying random slope by group
      • ebalfit: New command for entropy balancing
      • Omitted dummy variable because of collinearity
      • Fuzzy RD Plot
      • Collapsing two variables that occur multiple times
      • An event study plot in STATA - multiple, staggered...
      • Any suggestions on addressing endogeneity while es...
      • Creating biological and step families with the new...
      • Storing and graphing the lincom estimates (inside ...
      • Robustness check
      • Selectively dropping 1 of 2 similar variables meas...
      • Question on bar graph (percentages of answer optio...
      • Event History Analysis vs. Logit
      • Help with small sample panel data with cross-secti...
      • Summary stat. to excel
      • -ritest- Checking for statistical significance
      • interaction effect
      • NetCourse® 101: Introduction to Stata
      • Matching cases and controls 1:4
      • Regressions and the coefficient of the constant
      • How to present (in-)direct effects when using mult...
      • Asking for some subsample tests approaches
      • Missing values (obersvations)
      • How to get residuals returned after a rolling wind...
      • Summation of data before and after an event (dummy...
      • "matsize too small" for logistic regressions
      • CRSP Wharton Research
      • Collinearity issue for difference-in-difference
      • Multiple continuous stays into single claim
      • Question about marginal effects for interaction te...
      • Rowtotal of Multiple Variables Conditional on Othe...
      • Interpretation of a survival time model
      • Export xtsum output (using asdoc)
      • Store a value
      • Panel Data: Rolling window; fixed effects regressi...
      • Creating additional rows to match dates in column ...
    • ►  June (656)
    • ►  May (697)
    • ►  April (683)
    • ►  March (697)
    • ►  February (518)
    • ►  January (665)
  • ►  2020 (7956)
    • ►  December (653)
    • ►  November (659)
    • ►  October (598)
    • ►  September (654)
    • ►  August (660)
    • ►  July (682)
    • ►  June (683)
    • ►  May (708)
    • ►  April (692)
    • ►  March (698)
    • ►  February (638)
    • ►  January (631)
  • ►  2019 (9458)
    • ►  December (601)
    • ►  November (643)
    • ►  October (650)
    • ►  September (637)
    • ►  August (645)
    • ►  July (681)
    • ►  June (654)
    • ►  May (1034)
    • ►  April (1079)
    • ►  March (1122)
    • ►  February (876)
    • ►  January (836)
  • ►  2018 (931)
    • ►  December (692)
    • ►  November (239)

© BJ Data Tech Solution | Theme by Rifki.id | Premium Blogger Templates | PBT | Powered by Blogger |-| About | Privacy Policy | Sitemap | Contact | Disclaimer