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
Computing indices from panel data

Computing indices from panel data

Wednesday, August 31, 2022 Data Cleaning Data management Data Processing
I have a panel Data from 1995 to 2021 for 14 products. I want to normalize var1 by its value in 2008 across time. How can I do that?
Mathematical Optimization in Stata: LP and MILP

Mathematical Optimization in Stata: LP and MILP

8:23 PM Data Cleaning Data management Data Processing
Here's a 2013 presentation, posted on https://ideas.repec.org , describing two user-developed commands that do mathematical optimizatio...
interaction terms in stata (without main effect)

interaction terms in stata (without main effect)

5:23 PM Data Cleaning Data management Data Processing
Hi, I am little confuse about the way stata handle and designate interaction variables. To me (and to all textbooks), an interaction varia...
Two time-point measure, subgroups

Two time-point measure, subgroups

3:25 PM Data Cleaning Data management Data Processing
Hi Statalist, I hope for some ideas - because I am stuck. I have dyadic (child & caregiver) data with two time points (pre- and post-i...
metaprop: error on using cimethod(exact)

metaprop: error on using cimethod(exact)

3:25 PM Data Cleaning Data management Data Processing
Hi, I have been getting error as below on using cimethod(exact). But with cimethod(score) there is no such error. How do I resolve this iss...
ci2 interferes with esttab

ci2 interferes with esttab

3:25 PM Data Cleaning Data management Data Processing
Hello, After hours of troubleshooting code that used to work and stopped doing so, I figured out that the problem was introduced by my new...
logit and mixed regression

logit and mixed regression

3:25 PM Data Cleaning Data management Data Processing
Hello together, I am currently working on my Stata code for my bachelor thesis. I’m quite a beginner and would be super grateful for so...
Twoway Bar Graph Colors for Each Bar

Twoway Bar Graph Colors for Each Bar

3:25 PM Data Cleaning Data management Data Processing
s
Distinct occurrences of variable value within each individual in a panel

Distinct occurrences of variable value within each individual in a panel

Tuesday, August 30, 2022 Data Cleaning Data management Data Processing
The server I’m working on does not allow me to install -dataex-, so I apologize for the lack of standardized example! I’m working with a p...
Cox proportional test

Cox proportional test

5:23 PM Data Cleaning Data management Data Processing
my proportional-hazard assumption test based on Global test derived from Schoenfeld residuals was significant -----------------------------...
Relative risk ratios and their CIs from teffects psmatch

Relative risk ratios and their CIs from teffects psmatch

3:45 PM Data Cleaning Data management Data Processing
I am trying to work out relative risk ratios from the ATET result on a binary outcome in teffects psmatch. I'd like to present the resul...
Replace a observation by a missing value

Replace a observation by a missing value

3:45 PM Data Cleaning Data management Data Processing
I would like to know the command to replace the observations where it is written "refusal" and "don´t know" in the varia...
Count number of individuals that gave an answer in a questionnarie

Count number of individuals that gave an answer in a questionnarie

3:45 PM Data Cleaning Data management Data Processing
I would like to know the code to know the number of individuals (each individuak is identified by the number "pidp") that answer ...
Specifying a 'fill in the blank' variable in a loop

Specifying a 'fill in the blank' variable in a loop

2:36 PM Data Cleaning Data management Data Processing
Hello, I'm sure this is a function but I'm having trouble finding it -- I'm trying to make a loop that behaves differently fo...
Loop mixed model over a least of predictors and store the coefficients and P values

Loop mixed model over a least of predictors and store the coefficients and P values

2:36 PM Data Cleaning Data management Data Processing
Hi, I want to loop a mixed model over a list of predictors (fixed effects) and store the coefficients and P values in Stata v. 17. Code...
preparing data for propensity score match

preparing data for propensity score match

Monday, August 29, 2022 Data Cleaning Data management Data Processing
Dear All, I want to analyze if the gain in public health insurance due to this policy (Medicaid expansion) has led poor individuals to inc...
Matching Actions to Years

Matching Actions to Years

9:39 PM Data Cleaning Data management Data Processing
I have to different databases. Database 1 has executive actions in specific years, but this is not continuous (there may be an executive act...
generate a value indicating how many time a situation happens before the specific date

generate a value indicating how many time a situation happens before the specific date

8:32 PM Data Cleaning Data management Data Processing
Hello everyone in the community! Sorry to have some problems with the same data again , thanks again, in advance, for all your help! This...
rename variables

rename variables

6:27 PM Data Cleaning Data management Data Processing
I am poor at Stata coding. I would like to rename from "logind1-logind84" to " logcoefstandind101, logcoefstandind102, logc...
Kaplan Meier survival description output - no median result

Kaplan Meier survival description output - no median result

5:25 PM Data Cleaning Data management Data Processing
hi all, I am using Stat 16 on Mac. I am calculating Kaplan Meier survival curves for 2 groups of patients who do or do not have a genetic ...
Interval censored survival using aggregate data

Interval censored survival using aggregate data

5:25 PM Data Cleaning Data management Data Processing
Hello, I've got data on vials of drosophila infected with a virus. Then at each time point, I record how many are still alive. I would...
Changing a binary policy variable shifting it to next year for repeated cross section data

Changing a binary policy variable shifting it to next year for repeated cross section data

3:26 PM Data Cleaning Data management Data Processing
I've enlisted policy as a binary variable which I need to take 1 year forward. Like in my data for county 1003 the policy takes value 1...
Selecting a subset of ordered variables without typing them manually

Selecting a subset of ordered variables without typing them manually

2:23 AM Data Cleaning Data management Data Processing
Dear all, I am trying to execute a fairly simple operation: Code: egen duration_desk=rowtotal(t_*_pagesubmit) The issue I have is th...
A numerical representation of distance from a regression line?

A numerical representation of distance from a regression line?

2:23 AM Data Cleaning Data management Data Processing
Hello Am a novice Stata user/ statistician. I have created a two way scatter of aggregated travel distances (y axis) and passenger counts ...
Creating lagged variables with pooled cross sectional data

Creating lagged variables with pooled cross sectional data

1:23 AM Data Cleaning Data management Data Processing
I am working with a dataset that contains student grade observations in a variety of subjects, in different schools, over ten years. This is...
Interpreting Interaction Term Coefficients

Interpreting Interaction Term Coefficients

Sunday, August 28, 2022 Data Cleaning Data management Data Processing
Dear Stata Users, I intend to study the relationship between ethnicity and COVID-19 on income. I conduct a log-linear regression with th...
HELP! xtline producing different graphs each run

HELP! xtline producing different graphs each run

5:23 PM Data Cleaning Data management Data Processing
Please help! I have a simple, balanced longitudinal data set. I xtset the data and then run xtline. Each time I run xtline I am getting a ...
Spilt variable and fill in numeric terms in the string

Spilt variable and fill in numeric terms in the string

2:23 PM Data Cleaning Data management Data Processing
Dear Statalist, I have a variable called Name which looks like below. I would like to spilt Name into Name1 and Name2 by '/' or ...
Eliminating leading blanks from a string

Eliminating leading blanks from a string

9:23 AM Data Cleaning Data management Data Processing
Hi all, It seems there are leading blanks for a string variable state in 2 out of 5 rounds of data sets I'm working with. Due to these...
De-trending Panel Data

De-trending Panel Data

8:23 AM Data Cleaning Data management Data Processing
Hi everyone, I need help with detrending panel data. I have a panel of firm observations across years and industries. I want to detrend th...
How can I get gr_edit to refer to specific graphs when multiple graphs are open in the graph window?

How can I get gr_edit to refer to specific graphs when multiple graphs are open in the graph window?

7:23 AM Data Cleaning Data management Data Processing
I'm using a user-created command (-synth2-) that generates multiple graphs as outputs. I want to be able to edit these graphs with code,...
What components should I pay attention to when buying a new laptop for Stata?

What components should I pay attention to when buying a new laptop for Stata?

6:23 AM Data Cleaning Data management Data Processing
Hello Statalisters, I don't know if I'm allowed to post this thread as it is not related to Stata per se but to the best ways to u...
max # of variables in Cochran's Q test?

max # of variables in Cochran's Q test?

Saturday, August 27, 2022 Data Cleaning Data management Data Processing
Hello- I am trying to evaluate multiple choice (non-exclusive) binary questions. Ex: on a survey, a participant can choose "yes" b...
Abnormal return for everday in a year

Abnormal return for everday in a year

3:26 AM Data Cleaning Data management Data Processing
Good day everybody, I am new to Stata, and came up with an issue regarding the event study. I use the command from Princeton to calculate ...
Logistic Regression Output with Factor Variable i.Year - Issues with Interpretation

Logistic Regression Output with Factor Variable i.Year - Issues with Interpretation

2:15 AM Data Cleaning Data management Data Processing
Hi all! I’m having issues interpreting the coefficients in my regression output. My model has a dichotomous dependent variable: Education ...
spmap error

spmap error

1:05 AM Data Cleaning Data management Data Processing
Hi, I am learning how to create maps in Stata using spmap. Was trying out the examples using help spmap. But Stata is throwing an error t...
difficult to find the problem in MLE coding

difficult to find the problem in MLE coding

Friday, August 26, 2022 Data Cleaning Data management Data Processing
Hello everyone, this is the code i am writing to estimate MLE estimates. while writing this program i am trying to check this program by ML ...
Clustering with imputation

Clustering with imputation

5:31 PM Data Cleaning Data management Data Processing
I am using a dataset that uses a school-based sampling design, and thus I want to cluster with school id in my modeling. However, I'm al...
Using the coefplot command to plot odds ratios with p-values in multiple imputation estimations – potential bug to fix!

Using the coefplot command to plot odds ratios with p-values in multiple imputation estimations – potential bug to fix!

4:33 PM Data Cleaning Data management Data Processing
Dear Ben Jann , I was trying to plot odds ratios of mixed-effects logistic models of the association of four sexual risk-taking behaviours...
T-Test Using Three Groups

T-Test Using Three Groups

2:39 PM Data Cleaning Data management Data Processing
I am trying to do t-test where I have three groups (AIC, GIC, Others) - accordingly I created a variable (Test1) which is equal to 1 if AIC ...
Creating a Dummy variable (Time variant )

Creating a Dummy variable (Time variant )

12:23 AM Data Cleaning Data management Data Processing
Dear All, 1. I want to create a Dummy Variable ( Health Status of Indivuduals) which is either yes or no from INSURCY2 . if it yes i want...
Help trying to determine an Asymmetric effect for dummy variables in a Linear Random Effects Model

Help trying to determine an Asymmetric effect for dummy variables in a Linear Random Effects Model

Thursday, August 25, 2022 Data Cleaning Data management Data Processing
Hello this is my first post here. So I am making a model to try and show the asymmetric effect in my independent dummy variables but with ...
Reshape wide with no time/order variable

Reshape wide with no time/order variable

7:33 PM Data Cleaning Data management Data Processing
Hello. I am working with a dataset that has multiple observations for most of the identifiers labeled study_id. I would like to reshape wide...
Coefplot - multiple models with different dependent variables

Coefplot - multiple models with different dependent variables

6:24 PM Data Cleaning Data management Data Processing
All, I am running multiple regressions with the same independent variable and 29 different dependent variable, and then running these same m...
covariates and distal outcomes in a latent class model

covariates and distal outcomes in a latent class model

5:15 PM Data Cleaning Data management Data Processing
Hi Statalist Is there a way to implement the 3-step Latent Class Analysis (to include the covariates and distal outcomes in the model) in s...
ivreg2 - despite using partial option I get full rank error

ivreg2 - despite using partial option I get full rank error

4:00 PM Data Cleaning Data management Data Processing
In a multiple instrument regression using ivreg2 with gmm2s option I'm using partial. Despite using partial option, I get the following ...
optimization with STATA

optimization with STATA

4:00 PM Data Cleaning Data management Data Processing
I am unfamiliar with STATA programming, and I am trying to program some very rudimentary optimization problems. Suppose I have two variabl...
Transform a table: making options as variable

Transform a table: making options as variable

2:23 AM Data Cleaning Data management Data Processing
Dear all, I have this type of table: ID Date Culture ID Culture type Sample result 1 1 Jan 2022 001 MGIT Positive 1 1 Ja...
Assuming ICC

Assuming ICC

1:23 AM Data Cleaning Data management Data Processing
Hello everyone, This is my first post here. I need icc for power calculation. I have outcome variables test scores and student's effort ...
generate t-stat

generate t-stat

Wednesday, August 24, 2022 Data Cleaning Data management Data Processing
How can we modify this code to generate t-stat of the means instead of standard deviation (sd), and also for 4*4 sorts. Code: frame crea...
How to store p-value and CI in a new variable in prais-winsten regression?

How to store p-value and CI in a new variable in prais-winsten regression?

7:23 PM Data Cleaning Data management Data Processing
Hi! I'm new to Stata! I have a database model as shown below (hypothetical data). When running Prais-winsten regression, I would like ...
spatial weight matrix

spatial weight matrix

7:23 PM Data Cleaning Data management Data Processing
Hello, As part of my research, I want to build a spatial weight matrix. I want a variable that shows the average GVC of each of the contigu...
Post-estimation tests or heteroskedasticity check to confirm normality of the residuals?

Post-estimation tests or heteroskedasticity check to confirm normality of the residuals?

4:23 PM Data Cleaning Data management Data Processing
Hi Stata users, I'd like to ask for your help. I read STATA manual pdf on post-estimation for mixed-effects linear regression model, h...
what is the base for -collapse- percent statistic with by()?

what is the base for -collapse- percent statistic with by()?

Tuesday, August 23, 2022 Data Cleaning Data management Data Processing
The -collapse- command ( https://www.stata.com/manuals/dcollapse.pdf ) has a -percent- statistic that (according to the documentation) shows...
Correlating random effects to study interhospital variation

Correlating random effects to study interhospital variation

2:23 PM Data Cleaning Data management Data Processing
Hi All, Using data from ~2000 hospitals, I have identified patients who underwent 1 of 3 operations (type A, B, C). I would like to explor...
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)
      • Computing indices from panel data
      • Mathematical Optimization in Stata: LP and MILP
      • interaction terms in stata (without main effect)
      • Two time-point measure, subgroups
      • metaprop: error on using cimethod(exact)
      • ci2 interferes with esttab
      • logit and mixed regression
      • Twoway Bar Graph Colors for Each Bar
      • Distinct occurrences of variable value within each...
      • Cox proportional test
      • Relative risk ratios and their CIs from teffects p...
      • Replace a observation by a missing value
      • Count number of individuals that gave an answer in...
      • Specifying a 'fill in the blank' variable in a loop
      • Loop mixed model over a least of predictors and st...
      • preparing data for propensity score match
      • Matching Actions to Years
      • generate a value indicating how many time a situat...
      • rename variables
      • Kaplan Meier survival description output - no medi...
      • Interval censored survival using aggregate data
      • Changing a binary policy variable shifting it to n...
      • Selecting a subset of ordered variables without ty...
      • A numerical representation of distance from a regr...
      • Creating lagged variables with pooled cross sectio...
      • Interpreting Interaction Term Coefficients
      • HELP! xtline producing different graphs each run
      • Spilt variable and fill in numeric terms in the st...
      • Eliminating leading blanks from a string
      • De-trending Panel Data
      • How can I get gr_edit to refer to specific graphs ...
      • What components should I pay attention to when buy...
      • max # of variables in Cochran's Q test?
      • Abnormal return for everday in a year
      • Logistic Regression Output with Factor Variable i....
      • spmap error
      • difficult to find the problem in MLE coding
      • Clustering with imputation
      • Using the coefplot command to plot odds ratios wit...
      • T-Test Using Three Groups
      • Creating a Dummy variable (Time variant )
      • Help trying to determine an Asymmetric effect for ...
      • Reshape wide with no time/order variable
      • Coefplot - multiple models with different dependen...
      • covariates and distal outcomes in a latent class m...
      • ivreg2 - despite using partial option I get full r...
      • optimization with STATA
      • Transform a table: making options as variable
      • Assuming ICC
      • generate t-stat
      • How to store p-value and CI in a new variable in p...
      • spatial weight matrix
      • Post-estimation tests or heteroskedasticity check ...
      • what is the base for -collapse- percent statistic ...
      • Correlating random effects to study interhospital ...
      • Calculating days elapsed between dates in Panel data
      • ImportError after specifying set python_exec in Py...
      • Unable to find detailed parameters for variables
      • Fixed Effects Regression - Binary Variable Can Onl...
      • Questions on the validity of a dynamic model of th...
      • Reshape or transpose
      • Run regression separately for several periods
      • Using absorb to create dummy variables
      • Can somebody explain this Regression command to me ?
      • PPML and OLS Estimation with time-fixed effects
      • problem with backtick in a string
      • Difference-in-Hansen tests of exogeneity of instru...
      • Statistical Test for Continuous Variable Differenc...
      • Editing table label using latex
      • Tabulate at least 10 variables having same value l...
      • Input+end inside a Program
      • Boottest command for multiple hypothesis testing
      • xml_tab does not output required tstat or pvalue
      • Calculate percentages across rows
      • coefplot
      • How to use IV in a panel event study?
      • ROC analysis with pweights
      • mvn imputation - able to get unstandardized?
      • Bysort Trouble
      • Problem wtih running and exporting first and secon...
      • Problem wtih running and exporting first and secon...
      • Help identifying names
      • Renaming with renumbering
      • Merge identifier and date within range
      • Multiple correspondence analysis prediction
      • Margins plots and significance
      • Error message with 'collect export' in Stata 17
      • IKEA McKinsey 7S Model
      • jwdid: DID using ETwFE
      • IKEA Value Chain Analysis
      • Fix no room to add more variables because of width...
      • New version of stcmd on SSC
      • Generating date variable
      • Obtain regression residual for panel data
      • IKEA Marketing Communication Mix
      • IKEA Porter’s Five Forces Analysis
      • IKEA Segmentation, Targeting and Positioning: Targ...
      • IKEA Marketing Mix (IKEA 7Ps of Marketing)
      • error: rename using local inside loop
      • IKEA Marketing Strategy: a brief overview
    • ►  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