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
McNemar's chi2 test for proportion

McNemar's chi2 test for proportion

Wednesday, May 24, 2023 Data Cleaning Data management Data Processing
Dear Community, In a RCT design with 2 groups (control group n=18 ; and Exercise Training group n=17) that were tested at baseline and at 2...
Interpretation Magnitude Interaction Two Continuous Variables Economic Significance

Interpretation Magnitude Interaction Two Continuous Variables Economic Significance

2:24 AM Data Cleaning Data management Data Processing
Hi all, I have read a few threads regarding this topic (e.g. https://www.statalist.org/forums/for...uous-variables ) but have not yet foun...
Thoughts about Cross-lagged panel

Thoughts about Cross-lagged panel

12:23 AM Data Cleaning Data management Data Processing
I am currently sitting on modeling for a paper and had actually assumed that I was well positioned with my model. However, in consultation w...
Order variables from left to right based on their latest value

Order variables from left to right based on their latest value

Tuesday, May 23, 2023 Data Cleaning Data management Data Processing
I would like to order the variables (corresponding to the Stata command "order") from left to right based on the latest observatio...
Rolling windows VAR IRF and graphs

Rolling windows VAR IRF and graphs

5:23 PM Data Cleaning Data management Data Processing
Dear Stata users, I am trying to implement the var, vector autoregression, and a panel var (pavar) stata command using rolling windows. Whi...
Repeated measures ANOVA

Repeated measures ANOVA

3:23 PM Data Cleaning Data management Data Processing
Dear Statalist, I'm currently trying to replicate a piece of analysis originally done on SPSS in Stata 17 (Mac OS); specifically, a re...
Order data in descending order

Order data in descending order

2:24 PM Data Cleaning Data management Data Processing
Dear all, I use the TNIC data from Hoberg&Phillips and want to sort the scores pro competitor_rank1 in descending order in order to ke...
generating many dummy variables with the var name and label name

generating many dummy variables with the var name and label name

3:24 AM Data Cleaning Data management Data Processing
Hi all, Although I was going through some of the website links, I could not solve my issue. So, I am posting here and seeking the help. My ...
Normalize variable as an expanding window

Normalize variable as an expanding window

12:23 AM Data Cleaning Data management Data Processing
Hi, I would like to normalize the price of the following as an expanding window taking into account all information up to time t (but not ...
How do I find out which excel file was imported into STATA (origin of data?)

How do I find out which excel file was imported into STATA (origin of data?)

Monday, May 22, 2023 Data Cleaning Data management Data Processing
Hey all, Months ago, I imported an excel file into stata for analysis. However, I would like to do this again but in a new dta but I cann...
Query on ordering coefficients from multiple models when using coefplot

Query on ordering coefficients from multiple models when using coefplot

2:24 AM Data Cleaning Data management Data Processing
Hi All We need help with using the coefplot command. Briefly, we have run a series logistic regression models (5 models in total with a lo...
Reminder: UK Stata Conference submission deadline 26 May

Reminder: UK Stata Conference submission deadline 26 May

1:24 AM Data Cleaning Data management Data Processing
UK Stata Conference, 7-8 September 2023: reminder I'm bumping the thread at https://www.statalist.org/forums/for...and-first-call to ...
Stata Command: including interaction terms of the endogenous variable in 2SLS using xtivreg

Stata Command: including interaction terms of the endogenous variable in 2SLS using xtivreg

12:24 AM Data Cleaning Data management Data Processing
Hi, I am wondering if anyone had any experience in including an interaction term in 2SLS using xtivreg? I am now having a successful 2SL...
number increased or decreased?

number increased or decreased?

Sunday, May 21, 2023 Data Cleaning Data management Data Processing
Dear All, I found this question here (in Chinese). The variable x denotes the product. Code: * Example generated by -dataex-. To install...
inter-religious marriage

inter-religious marriage

9:23 PM Data Cleaning Data management Data Processing
Dear sir I am working with Census data. To make it simple, consider a database as follows: id family_id position (in family) religi...
Problem with csdid command

Problem with csdid command

8:24 AM Data Cleaning Data management Data Processing
I have the following dataset: Code: id_municipio ano uf munic imposto_renda taxpayers ano_3g ano_4g treatment_3g...
Hausman test after reghdfe with two-way cluster

Hausman test after reghdfe with two-way cluster

7:24 AM Data Cleaning Data management Data Processing
Hello, I am a complete novice in terms of Stata and have encountered a challenge I can’t seem to overcome. I have tried searching the foru...
Hausman test after reghdfe with two-way cluster

Hausman test after reghdfe with two-way cluster

7:24 AM Data Cleaning Data management Data Processing
Hello, I am a complete novice in terms of Stata and have encountered a challenge I can’t seem to overcome. I have tried searching the foru...
Converting Unix time to human readable time format

Converting Unix time to human readable time format

Saturday, May 20, 2023 Data Cleaning Data management Data Processing
Hi, I am having an issue converting what is assumably Unix time stamp to human readable time format. * Example generated by -dataex-. For ...
Advice on backtesting when an interaction is significant

Advice on backtesting when an interaction is significant

7:23 PM Data Cleaning Data management Data Processing
Hi all, Currently in the works of writing my thesis where one of the regressions is the following: Array rhp = Real House Prices shock...
catplot with "empty" categories

catplot with "empty" categories

3:24 PM Data Cleaning Data management Data Processing
I'd like to plot the response percentages to a question using catplot or tabplot . However some of the response categories are empty (i...
coefplot line color

coefplot line color

12:24 AM Data Cleaning Data management Data Processing
Hi I was wondering how I can change the color of a graph line generated by coefplot. here is my code: Code: coefplot , drop(_cons) verti...
Graph legend(off) does not work

Graph legend(off) does not work

Friday, May 19, 2023 Data Cleaning Data management Data Processing
Hello, I have health expenditure data for 20 countries covering 1971-2019 which looks like below. I also calculated a Fourier function to...
Analysis of multiple outcome measurements with censored dependent variables

Analysis of multiple outcome measurements with censored dependent variables

7:24 PM Data Cleaning Data management Data Processing
Our working group has a data set that contains about 10 measured urinary pesticides or their metabolites in a sample of about 1000 women. We...
Insufficient observations with bsrifhdreg

Insufficient observations with bsrifhdreg

5:24 PM Data Cleaning Data management Data Processing
Hello, I was trying to conduct quantile regressions with fixed effects using the following command (for the 25th quantile): Code: bsri...
sample

sample

3:24 PM Data Cleaning Data management Data Processing
Query
Mismatch between date formatted as string and numeric date

Mismatch between date formatted as string and numeric date

3:24 PM Data Cleaning Data management Data Processing
Dear all, I am processing hourly time series data (DD.MM.YYYY hh:mm), where the date variable is formatted as a string and looks the follo...
How to expand the variable within group?

How to expand the variable within group?

2:24 AM Data Cleaning Data management Data Processing
Here is what I am trying to do I want to make each one of the observations in the following dataset from left to right. Namely, within the g...
One-step stochastic frontier using Stata

One-step stochastic frontier using Stata

12:24 AM Data Cleaning Data management Data Processing
Greetings, dear Statalist members! Could I use Stata to estimate a one-stage stochastic frontier with exponential, log-normal and half-norm...
Force negative time values in 'stset'

Force negative time values in 'stset'

Thursday, May 18, 2023 Data Cleaning Data management Data Processing
Dear Stata users, I wonder if there is any way to force negative time values (age-centred) in stset. Code: stset stop, enter(start) f(...
Stata 18 data editor displaying ampersands incorrectly in string variable observations

Stata 18 data editor displaying ampersands incorrectly in string variable observations

5:23 PM Data Cleaning Data management Data Processing
I am experiencing an issue with the data editor displaying string ampersands (ASCII Code 38) in Stata 18.0 MP (current update level 5/15/23)...
Fixed effect regression questions

Fixed effect regression questions

3:24 PM Data Cleaning Data management Data Processing
Hello, i'm kinda new to stata and empirical research so sorry if this question is very basic. 1: So i have observations for differe...
ASGEN command for weighted average

ASGEN command for weighted average

3:24 AM Data Cleaning Data management Data Processing
Hello everyone, I have to compute the weighted average of democratic scores in the destination countries, weighted it with my shares of e...
[Error: icio] Missing adb tables (2001-2006)

[Error: icio] Missing adb tables (2001-2006)

Wednesday, May 17, 2023 Data Cleaning Data management Data Processing
Hello everyone, I want to ask how I can contact or report issues in using the icio command. I am currently doing a study on GVCs using the A...
two graphs

two graphs

8:24 PM Data Cleaning Data management Data Processing
Hello I want to combine these two graphs into one graphs please twoway (scatter ed yearofbirth) || (lfit ed yearofbirth if yearofbirth...
Help to combine graph bar and connected into single graph, by group(s)

Help to combine graph bar and connected into single graph, by group(s)

7:23 PM Data Cleaning Data management Data Processing
Have been trying without luck to combine the two graph types (bar and connected line) to be overlayed. Both are to be displayed by group (or...
ERROR Fixed effect estimation (reghdfe) : treatment variable is collinear with the fixed effects

ERROR Fixed effect estimation (reghdfe) : treatment variable is collinear with the fixed effects

6:23 PM Data Cleaning Data management Data Processing
Hi all, I am conducting a study to estimate the effect of Medicaid expansion on the uninsured rate using a classic Difference-in-Differenc...
nested CES function

nested CES function

4:24 PM Data Cleaning Data management Data Processing
Hello, I have a function with 4 inputs including capital(K), labor(L), energy(E), and material(M) in a nested CES form: Y=A⋅ {a[b(c⋅K^(-α)+...
How can I add the the decomposition of the R² in "between" and "within" to a a table (xtreg) ?

How can I add the the decomposition of the R² in "between" and "within" to a a table (xtreg) ?

1:23 AM Data Cleaning Data management Data Processing
I am studying the relationship between university rankings (dependant variable) and academic freedom (independant variable). During my resea...
ds - how to display fullnames

ds - how to display fullnames

12:23 AM Data Cleaning Data management Data Processing
Dear Statalisters - I have a large dataset and am looking to list out the names of all my string variables. I have found the command ds wh...
renaming multi-variables using foreach

renaming multi-variables using foreach

12:23 AM Data Cleaning Data management Data Processing
Hi, I am asking this clarification after going through STATA doc and some of the web content. Although I could not get the "foreach...
command table with option markvar(newvar) creates error __000001 not found

command table with option markvar(newvar) creates error __000001 not found

Tuesday, May 16, 2023 Data Cleaning Data management Data Processing
Why do the commands table and table twoway with the option markvar(newvar) create the error " __000001 not found r(111); "? The...
How to reshape data with dates as variable names?

How to reshape data with dates as variable names?

5:24 PM Data Cleaning Data management Data Processing
Greetings everyone, I need your help reshaping my district-level daily temperature data from a wide to a long format. I have provided a ...
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)
      • McNemar's chi2 test for proportion
      • Interpretation Magnitude Interaction Two Continuou...
      • Thoughts about Cross-lagged panel
      • Order variables from left to right based on their ...
      • Rolling windows VAR IRF and graphs
      • Repeated measures ANOVA
      • Order data in descending order
      • generating many dummy variables with the var name ...
      • Normalize variable as an expanding window
      • How do I find out which excel file was imported in...
      • Query on ordering coefficients from multiple model...
      • Reminder: UK Stata Conference submission deadline ...
      • Stata Command: including interaction terms of the ...
      • number increased or decreased?
      • inter-religious marriage
      • Problem with csdid command
      • Hausman test after reghdfe with two-way cluster
      • Hausman test after reghdfe with two-way cluster
      • Converting Unix time to human readable time format
      • Advice on backtesting when an interaction is signi...
      • catplot with "empty" categories
      • coefplot line color
      • Graph legend(off) does not work
      • Analysis of multiple outcome measurements with cen...
      • Insufficient observations with bsrifhdreg
      • sample
      • Mismatch between date formatted as string and nume...
      • How to expand the variable within group?
      • One-step stochastic frontier using Stata
      • Force negative time values in 'stset'
      • Stata 18 data editor displaying ampersands incorre...
      • Fixed effect regression questions
      • ASGEN command for weighted average
      • [Error: icio] Missing adb tables (2001-2006)
      • two graphs
      • Help to combine graph bar and connected into singl...
      • ERROR Fixed effect estimation (reghdfe) : treatmen...
      • nested CES function
      • How can I add the the decomposition of the R² in "...
      • ds - how to display fullnames
      • renaming multi-variables using foreach
      • command table with option markvar(newvar) creates ...
      • How to reshape data with dates as variable names?
      • Type Mismatch Error with tabcount
      • 2SLS F-Statistics
      • Matching different ID between two periods
      • teffects with multivalued treatments
      • Not understanding how to get my panel data ready
      • Troubleshooting Advice for r(198) Message with Use...
      • Variable creation
      • Measure outcome at three time points
      • Panel data
      • how to solve error r(608)
      • Predicted values after reg by group
      • Bonferroni code ttest
      • Specifying lcolor in twoway line plot with boleans
      • Different Outputs for the same programs
      • Using STATA "mixed" command with autoregressive co...
      • including weights in crosstab with percentages
      • xtgee - nbinomial family distribution - estimates ...
      • ? = number of redundant parameters may be higher
      • foreach loop error r(100) using required
      • Estimate incidence rate (looping)
      • Can you help me write Two-step system GMM command ?
      • How to change label position with coeffplot ?
      • Calculate AUC and diagnostic accuracy for each out...
      • how to create a table that display a variable's su...
      • How to show p-value in sembuilder path diagram?
      • How to make age groups ?
      • Exporting direct, indirect and total effects after...
      • Higher bar graph
      • Line graph depicting coefficient results at differ...
      • Coefplot: Increase gap size between subgraphs, dec...
      • Combing dichotomous into one
      • How to equality test for multnomial logit model wi...
      • Pooled OLS with year interaction vs. OLS by year
      • Econometric modelling
      • Creating margin victory election data
      • How to interpret coefficients obtained with the "p...
      • Kruskal-Wallis (or similar) in a complex sample
      • Country-level differences - fixed effects for pane...
      • Loop opening txt file and create a variable
      • Random slopes and random effects with melogit and ...
      • Endogeneity in double hurdle models
      • Why is Hausman Test cannot work on my panel ARDL?
      • Need help Mixed effect model for my PhD project
      • Generate correlation as variable
      • Panel
      • Metan – override pooled effect with user-defined p...
      • High specificity in a ROC model with the lroc command
      • A question on how to bootstrap placebo test 1,000 ...
      • specifying waves for xtlogit panel data regression
      • Portfolio returns
      • forvalues acting strangely
      • Post-hoc fisher's exact test to determine which le...
      • Aggregate data by TWO groups
      • Creating new variables by combining others on a Li...
      • robvar to excel
      • Negative Predicted Margins
      • Adding upword/downword mobility in DRM
    • ►  April (174)
    • ►  March (176)
    • ►  February (157)
    • ►  January (189)
  • ►  2022 (2201)
    • ►  December (181)
    • ►  November (180)
    • ►  October (198)
    • ►  September (182)
    • ►  August (182)
    • ►  July (194)
    • ►  June (174)
    • ►  May (167)
    • ►  April (181)
    • ►  March (186)
    • ►  February (170)
    • ►  January (206)
  • ►  2021 (7379)
    • ►  December (327)
    • ►  November (645)
    • ►  October (646)
    • ►  September (639)
    • ►  August (557)
    • ►  July (649)
    • ►  June (656)
    • ►  May (697)
    • ►  April (683)
    • ►  March (697)
    • ►  February (518)
    • ►  January (665)
  • ►  2020 (7956)
    • ►  December (653)
    • ►  November (659)
    • ►  October (598)
    • ►  September (654)
    • ►  August (660)
    • ►  July (682)
    • ►  June (683)
    • ►  May (708)
    • ►  April (692)
    • ►  March (698)
    • ►  February (638)
    • ►  January (631)
  • ►  2019 (9458)
    • ►  December (601)
    • ►  November (643)
    • ►  October (650)
    • ►  September (637)
    • ►  August (645)
    • ►  July (681)
    • ►  June (654)
    • ►  May (1034)
    • ►  April (1079)
    • ►  March (1122)
    • ►  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