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
Invalid Syntax while looping

Invalid Syntax while looping

Thursday, September 30, 2021 Data Cleaning Data management Data Processing
hello, i dont know why stata keeps me showing invalid syntax in this loop: foreach x of p524a1_14 p524a1_15 p524a1_16 p524a1_17 p524a1_18{...
Survival Analysis - different outputs

Survival Analysis - different outputs

6:23 PM Data Cleaning Data management Data Processing
Hello everyone, I am trying to do survival analysis on 2018 Nigeria Demographic and Health Survey Data. The data has 33,924 observations,...
Arranging bars of graph bar

Arranging bars of graph bar

4:23 PM Data Cleaning Data management Data Processing
Hello community. I am producing a graph with Stata. Here is the output : Array And here is the code Code: graph bar var1 var2 var3 [aw=w...
Reshape numerous variables

Reshape numerous variables

2:23 PM Data Cleaning Data management Data Processing
I have a vector of numerous variables (>100) that I need to reshape. Basically the format of the variables are the following. Country ...
Stratified sample with probability proportional to size

Stratified sample with probability proportional to size

2:23 PM Data Cleaning Data management Data Processing
We have a total of 908 communities (each community has a number of households) which are located in the sphere of influence of roads / highw...
Combining Two Similar Variables To be in one row

Combining Two Similar Variables To be in one row

2:23 PM Data Cleaning Data management Data Processing
Hi All, I have the following 2 variables that serve the same purpose and I'm trying to generate one variable for both. Schoolfees1 has...
quarterly returns

quarterly returns

3:23 AM Data Cleaning Data management Data Processing
Hi To calculate quarterly index returns from monthly index returns starting from the first month of the quarter to the third month of the...
The "replace" option to the table command in Stata 16 is on longer available in Stata17; is there an alternative in Stata 17?

The "replace" option to the table command in Stata 16 is on longer available in Stata17; is there an alternative in Stata 17?

3:23 AM Data Cleaning Data management Data Processing
In Stata 16 you could code: table ..., replace to replace the data in memory with the results produced by the table command. Is there an...
Kleibergen Paap F statistic test in xtdpdgmm

Kleibergen Paap F statistic test in xtdpdgmm

3:23 AM Data Cleaning Data management Data Processing
Hi everyone, I'm currently working with xtdpdgmm for my thesis but I'm confused how to get Kleibergen Paap F statistic test for weak...
how to do instrument strength test for non-i.i.d error (more than one endogenous variables)

how to do instrument strength test for non-i.i.d error (more than one endogenous variables)

2:23 AM Data Cleaning Data management Data Processing
Dear all, I wish to test instrument strength for the non-i.i.d error, and I have 3 endogenous variables. I noticed that the STATA command ...
How do I create a new variable which counts number of variables that satisfy a given condition?

How do I create a new variable which counts number of variables that satisfy a given condition?

1:23 AM Data Cleaning Data management Data Processing
Hallo Statalist, I am new here. I have a dataset of different towns with monthly temperatures over a 10-year period (i.e. 120 months). The...
create v3 which shows number of v1 that share the same v2 value

create v3 which shows number of v1 that share the same v2 value

1:23 AM Data Cleaning Data management Data Processing
Hi, My dataset has 2 variables that I am interested in seeing the relationship between. v1 is 'unique_attend' which creates a un...
coefplot plotting results from categorical variable

coefplot plotting results from categorical variable

1:23 AM Data Cleaning Data management Data Processing
Dear all, I would like to use coefplot to compare the coefficients from different models and categorical variables. I am using different d...
Labels of restricted categories appearing in graph when using -by()-

Labels of restricted categories appearing in graph when using -by()-

Wednesday, September 29, 2021 Data Cleaning Data management Data Processing
I want to graph tobacco use for couples in different value groups. While the values variable has 12 categories, I only want to graph the fir...
What fixed effects I should add when using triple difference in firm level?

What fixed effects I should add when using triple difference in firm level?

11:23 PM Data Cleaning Data management Data Processing
In my difference-in-difference setting (double diff), I examine the impact of anticorruption laws on firms' asset growth of all countrie...
Square CSR: a brief overview

Square CSR: a brief overview

10:33 PM Research Methodology
Square CSR programs and initiatives mainly focus on four key priority areas – Climate Action, Social Impact, Employees and Culture, and Corp...
Is there any package for stacked event-by-event estimates ?

Is there any package for stacked event-by-event estimates ?

8:23 PM Data Cleaning Data management Data Processing
I am reading a paper of Cengiz, 2019 about using stacked event-by-event estimates for the Difference-in-Differences settings. This is a go...
What is the difference between "stack" and "pca" ?

What is the difference between "stack" and "pca" ?

8:23 PM Data Cleaning Data management Data Processing
From my understanding, it seems that pca and stack syntaxes are all about suppressing two or more variables (similar characteristics) to o...
Trying to open shapefile but Stata looks for .dbf file

Trying to open shapefile but Stata looks for .dbf file

8:23 PM Data Cleaning Data management Data Processing
Hello, I am trying to open a shapefile under the name "pga.shp" that I downloaded from the US Geological Survey. I am using shp2...
2SLS: Interpretation of Results

2SLS: Interpretation of Results

8:23 PM Data Cleaning Data management Data Processing
Hi - I am working with panel data (US industrials, 2000-2019) and am researching the impact of firm geographic diversification (GSD) on firm...
How to list all unique values based on value of another variable?

How to list all unique values based on value of another variable?

8:23 PM Data Cleaning Data management Data Processing
Hi all, I am conducting a cross-country analysis. I have a variable named developed has the value of 1 if this country is a developed coun...
Square Ecosystem: a brief overview

Square Ecosystem: a brief overview

7:33 PM Research Methodology
Square ecosystem represents a growing ecosystem of financial services. Ecosystem of Square can be divided into two groups: seller ecosystem ...
Square McKinsey 7S Model

Square McKinsey 7S Model

7:33 PM Research Methodology
Square McKinsey 7S model is intended to illustrate how seven elements of business can be aligned to increase effectiveness. The framework di...
Square Value Chain Analysis

Square Value Chain Analysis

7:33 PM Research Methodology
Value chain analysis is a strategic analytical tool that can be used to identify business activities that create the most value. The framewo...
What is the ideal way to keep only needed variables in panal dataset?

What is the ideal way to keep only needed variables in panal dataset?

5:23 PM Data Cleaning Data management Data Processing
I have around 40 variables in my dataset but I actually only use around 8 of them. I assume that keeping 8 variables is better than keeping ...
How to delete observation if one of these variables missing?

How to delete observation if one of these variables missing?

5:23 PM Data Cleaning Data management Data Processing
A common practice to reduce the size of the panel sample (to reduce the time that Stata process the data) is to delete the observation where...
Confirmatory factor analysis

Confirmatory factor analysis

5:23 PM Data Cleaning Data management Data Processing
Hi! Just wonder in the computation of confirmatory factor analysis, what input is putting in the formula in STATA, correlation matrix or cov...
Regression with multiple dependent variables

Regression with multiple dependent variables

2:23 PM Data Cleaning Data management Data Processing
Hi, I am trying to run a set of logit models using the following formula, but it is not working. Can you please suggest what is not correc...
Comparing two string variables and extract difference into a new variable

Comparing two string variables and extract difference into a new variable

2:23 PM Data Cleaning Data management Data Processing
Hi, I am trying to tackle the problem of comparing text between two string variables and identify (and extract) “updated” parts. Strin...
Looping to create marginsplots for different moderators but how to get the same y-axis?

Looping to create marginsplots for different moderators but how to get the same y-axis?

8:23 AM Data Cleaning Data management Data Processing
Hi everybody I am researching how outsourcing affects employees in terms of income, employment, and benefits and, next, how these effects ...
Reference on manipulation of locals/macros/lists

Reference on manipulation of locals/macros/lists

6:23 AM Data Cleaning Data management Data Processing
I would like to learn more how to work with locals to store objects and then add, remove things, manipulate them according to criteria. I lo...
cmmixlogit does not converge

cmmixlogit does not converge

6:23 AM Data Cleaning Data management Data Processing
Hi, I am facing slight issues with the cmmixlogit command, which worries me a bit. I am working with a discrete choice experiment, in whi...
Surveys and lists.

Surveys and lists.

4:23 AM Data Cleaning Data management Data Processing
Hi there, Can you please help me with how can I do this in STATA? My data set: Several waves of data from 60 countries. Around 3000 respo...
problem in dummy approach-interaction terms

problem in dummy approach-interaction terms

3:23 AM Data Cleaning Data management Data Processing
Dear I use the panel regressions using augmented mean group (AMG) method, I add the dummy variables and interact it with my independent ...
Select all variables based on suffix

Select all variables based on suffix

3:23 AM Data Cleaning Data management Data Processing
I want to select all variables that contain a certain suffix to store them in a macro. Any suggestions? MWE: Code: sysuse auto.dta ds ...
Using World Values Survey Wave 7 in Stata

Using World Values Survey Wave 7 in Stata

Tuesday, September 28, 2021 Data Cleaning Data management Data Processing
Hello, I am getting started with using World Values Survey Wave 7 (WVS-7) in Stata. Is there anyone who has used WVS-7 in Stata ? I am inter...
Creating a variable with several condition using the foreach loop

Creating a variable with several condition using the foreach loop

10:23 PM Data Cleaning Data management Data Processing
Hello Everyone, I am trying to create a variable ,"grad_AA", that will determine respondents' graduation year using the vari...
error using svy bootstrap with self-written program

error using svy bootstrap with self-written program

10:23 PM Data Cleaning Data management Data Processing
Dear list, I want to calculate bootstrapped standard error (and pvalue) of the difference between two correlation coefficients. In my con...
Sensitivity analysis following mediation with sureg

Sensitivity analysis following mediation with sureg

9:23 PM Data Cleaning Data management Data Processing
Greetings, I'm running Stata 15.1 on a Mac OS and working with experimental data. I've been conducting tests of mediation with the...
How to replace the value of a variable by the most frequently occured value

How to replace the value of a variable by the most frequently occured value

9:23 PM Data Cleaning Data management Data Processing
Hi, I have a dataset looks like this: Code: * Example generated by -dataex-. To install: ssc install dataex clear input str2 id str8 l...
Find number of children, age at birth for women using identifiers

Find number of children, age at birth for women using identifiers

9:23 PM Data Cleaning Data management Data Processing
Hi: I am working with a dataset that looks something like this: HHID PID MID Rel_Head Age 10 1 3 1 56 10 2 . 2 48 10 3 . 7 75 10 4 ....
Square Porter’s Five Forces Analysis

Square Porter’s Five Forces Analysis

7:33 PM Research Methodology
Porter’s Five Forces analytical framework developed by Michael Porter (1979)[1] represents five individual forces that shape an overall exte...
Square Marketing Communication Mix

Square Marketing Communication Mix

7:33 PM Research Methodology
Square marketing communication mix comprises communication channels to communicate the marketing message to the target customer segment. The...
Square Segmentation, Targeting & Positioning

Square Segmentation, Targeting & Positioning

6:33 PM Research Methodology
Square segmentation, targeting and positioning refers to a series of consecutive marketing efforts. It comprises the following stages: 1. Se...
endogeneity test after xtologit and xtoprobit

endogeneity test after xtologit and xtoprobit

5:23 PM Data Cleaning Data management Data Processing
Hi all, please I need help with testing for endogeneity after xtologit and xtoprobit. Firstly, how do I check for presence of endogeneity? S...
data annualization

data annualization

5:23 PM Data Cleaning Data management Data Processing
Dear all, May I have your guidance please on the following: I have 5 subjects with 5 observations over 15 months period (Day0 ,Day 30, Mon...
How to find duplicate across variables

How to find duplicate across variables

5:23 PM Data Cleaning Data management Data Processing
Hello, I am relatively new to stata, but I have encountered a problem of not being able to find duplicates across variables. I have a tabl...
rate of admission in NRD

rate of admission in NRD

5:23 PM Data Cleaning Data management Data Processing
hello all i'm working on NRD I am looking to compare rate of hospitalizations before and after certain procedure. The way it was done ...
Simple graphing issue

Simple graphing issue

5:23 PM Data Cleaning Data management Data Processing
I am tring to create a simple bar graph, but I cannot get the categories on the x axis to display as I would like. I want them to be smaller...
The critical thinking about the "staying forever" in Difference-in-Differences estimator of differential timing setting?

The critical thinking about the "staying forever" in Difference-in-Differences estimator of differential timing setting?

3:23 PM Data Cleaning Data management Data Processing
When dealing with the differential timing DiD setting, we may apply some modern approaches like Callaway, 2020 , Borusyak, 2021 (I focus mo...
Unexpected behavior of the egen function median()

Unexpected behavior of the egen function median()

3:23 PM Data Cleaning Data management Data Processing
Hello all, This is my first post but I've read up on the FAQ so I hope it will be acceptable. To give some context, I'm working wi...
Response surface analysis (RSA)

Response surface analysis (RSA)

3:23 PM Data Cleaning Data management Data Processing
Hi! Does STATA support RSA analysis and the surface plotting?
Screeplot of eigenvalues from the reduced correlation matrix

Screeplot of eigenvalues from the reduced correlation matrix

9:23 AM Data Cleaning Data management Data Processing
I assume that STATA's screeplot command prints the eigenvalues from the sample correlation matrix. However, I want to plot a scree test ...
Generate difference variable between 2 digits sectors and relevant 3 digits sub-sectors of NACE Rev.2

Generate difference variable between 2 digits sectors and relevant 3 digits sub-sectors of NACE Rev.2

9:23 AM Data Cleaning Data management Data Processing
Dear all, I have a data set consisting of Inflation rates relating to 2-,and 3- digit sectors of Nace Rev.2 (EU statistical classification...
Create a Variable in stata that is a value minus it's last month value

Create a Variable in stata that is a value minus it's last month value

9:23 AM Data Cleaning Data management Data Processing
Hi all, I put some data below, but I have a question about making a varialbe that is it's value minus the value of the last month. I h...
counting days between date and another date

counting days between date and another date

7:23 AM Data Cleaning Data management Data Processing
Dear all, I have 5 subjects who had 5 visits at different dates, I want to create a new variable that has the number of days elapsed since ...
Automating meta-analyses code for several outcomes using metaan

Automating meta-analyses code for several outcomes using metaan

7:23 AM Data Cleaning Data management Data Processing
Hi, I have data for 40 outcomes for 2 studies. I am wondering if there is a way to automate this rather than do this manually for each out...
Predict and margins after melogit with interactions

Predict and margins after melogit with interactions

6:23 AM Data Cleaning Data management Data Processing
Hello Statalisters, I am running a mixed effect model in Stata 15.1 using melogit, with weights. I need to calculate the predicted values o...
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...
  • "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...
  • 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...
  • 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)
      • Invalid Syntax while looping
      • Survival Analysis - different outputs
      • Arranging bars of graph bar
      • Reshape numerous variables
      • Stratified sample with probability proportional to...
      • Combining Two Similar Variables To be in one row
      • quarterly returns
      • The "replace" option to the table command in Stata...
      • Kleibergen Paap F statistic test in xtdpdgmm
      • how to do instrument strength test for non-i.i.d e...
      • How do I create a new variable which counts number...
      • create v3 which shows number of v1 that share the ...
      • coefplot plotting results from categorical variable
      • Labels of restricted categories appearing in graph...
      • What fixed effects I should add when using triple ...
      • Square CSR: a brief overview
      • Is there any package for stacked event-by-event es...
      • What is the difference between "stack" and "pca" ?
      • Trying to open shapefile but Stata looks for .dbf ...
      • 2SLS: Interpretation of Results
      • How to list all unique values based on value of an...
      • Square Ecosystem: a brief overview
      • Square McKinsey 7S Model
      • Square Value Chain Analysis
      • What is the ideal way to keep only needed variable...
      • How to delete observation if one of these variable...
      • Confirmatory factor analysis
      • Regression with multiple dependent variables
      • Comparing two string variables and extract differe...
      • Looping to create marginsplots for different moder...
      • Reference on manipulation of locals/macros/lists
      • cmmixlogit does not converge
      • Surveys and lists.
      • problem in dummy approach-interaction terms
      • Select all variables based on suffix
      • Using World Values Survey Wave 7 in Stata
      • Creating a variable with several condition using t...
      • error using svy bootstrap with self-written program
      • Sensitivity analysis following mediation with sureg
      • How to replace the value of a variable by the most...
      • Find number of children, age at birth for women us...
      • Square Porter’s Five Forces Analysis
      • Square Marketing Communication Mix
      • Square Segmentation, Targeting & Positioning
      • endogeneity test after xtologit and xtoprobit
      • data annualization
      • How to find duplicate across variables
      • rate of admission in NRD
      • Simple graphing issue
      • The critical thinking about the "staying forever" ...
      • Unexpected behavior of the egen function median()
      • Response surface analysis (RSA)
      • Screeplot of eigenvalues from the reduced correlat...
      • Generate difference variable between 2 digits sect...
      • Create a Variable in stata that is a value minus i...
      • counting days between date and another date
      • Automating meta-analyses code for several outcomes...
      • Predict and margins after melogit with interactions
      • Variable creation
      • post doesn't post results successfully
      • population distribution for stsplit
      • Summary statistics by country
      • Pooled meta regression to estimate cross-country e...
      • How to adjust the colour of event plot ?
      • How to get Durbin-Watson stat in GMM regressions?
      • help in generating count variable
      • Reproducing "estat trendplots" linear-trends model
      • Import multiple CSV files
      • How to drop the mtitle row in esttab ?
      • Lineear mixed model/Repeated measure model
      • generating compatible ID variables
      • How to run Stata Codes in Mac nvim?
      • Collapse all values of one string variable to one ...
      • Understanding/Reading Regression Output With Categ...
      • How to overlay distributions using a pie chart usi...
      • About structural equation modelling
      • Iterations in Poission Regression
      • DataSet Notes from huge DTA file
      • DataSet Notes from huge DTA file
      • Subtracting time series and creating new group
      • Multilevel modeling and density function
      • How to fill in created blank based on predicted va...
      • The "omitted" results in interaction between two d...
      • Instrumental Variable (2SLS) First stage different...
      • Matching with identifiers
      • Lognormal regression & Trucated normal regression ...
      • appropriate filter
      • Out-of-sample prediction with threshold regression
      • Factor variables may not contain noninteger values
      • Square Marketing Strategy: a brief overview
      • Square PESTEL Analysis
      • Square SWOT Analysis
      • Square Ansoff Matrix
      • How to remove (horizontal) blue lines when using c...
      • Persistent class objects with ado programs
      • how to use an asterisk(*) for multiple variables w...
      • Using margins, test, and lincom to test hypothesis...
      • Consideration on the Expand command : Rename a dup...
      • Help Recreating a Graph (Regression line and densi...
      • Confidence* intervals in synthetic control method
    • ►  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