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
Coefplot graph error despite running the regression

Coefplot graph error despite running the regression

Friday, September 30, 2022 Data Cleaning Data management Data Processing
I'm supposed to get a coefplot graph using the following data and code but unfortunately I'm coming across this error. Why lths vari...
anycount

anycount

5:23 PM Data Cleaning Data management Data Processing
Dear all I would like to count the number of values across 5 numeric variables. I tried using "anycount", but there is a wide ra...
Multiple commands in one line stored in a local

Multiple commands in one line stored in a local

3:24 PM Data Cleaning Data management Data Processing
I have a problem executing a local with multiple Stata commands separated by ";". If I use this code Code: sysuse auto, clear...
Problems with regressions (regress.ado r(199)

Problems with regressions (regress.ado r(199)

4:23 AM Data Cleaning Data management Data Processing
Hi, I have run into some problems with making regressions in Stata (version 16). I have been using Stata on my Macbook Air (mid 2017) for ...
formula into regression

formula into regression

Thursday, September 29, 2022 Data Cleaning Data management Data Processing
Hi Is there any way to make a regression in this way regress ln(y) indep vars without generate a new variable such as lny = ln(y)? I...
Generate New Variable = Average Price Per Type Per Year

Generate New Variable = Average Price Per Type Per Year

7:23 PM Data Cleaning Data management Data Processing
I am using Stata version 15.1 and I have 47 variables and 1,010 observations in my dataset. I am doing educational research with 112 college...
Monte Carlo Simulation

Monte Carlo Simulation

5:24 PM Data Cleaning Data management Data Processing
Hi all, I want to be able to run a Monte Carlo simulation for an econometrics assignment that I have. From what I can tell, I need to desi...
Endogeneity correction via Gaussian Copulas - generating normal CDF of a non-normal empirical distribution function

Endogeneity correction via Gaussian Copulas - generating normal CDF of a non-normal empirical distribution function

4:23 PM Data Cleaning Data management Data Processing
Dear Stata experts, I am a passionate passive follower in the forum, you guys helped me a lot in the past 2 years of my research! I am f...
Help generating this type of plot

Help generating this type of plot

3:23 PM Data Cleaning Data management Data Processing
Hey all, I need some assistance regarding the appropriate data shaping and plot type to generate this simple plot (see attachment). Basica...
Lag of variable with condition of not being misssing

Lag of variable with condition of not being misssing

2:23 AM Data Cleaning Data management Data Processing
I want to create the lag of a variable with one caveat. If it is missing, I want to use the previous period's value etc. So it is the mo...
Post estimation models for latent class analyses

Post estimation models for latent class analyses

Wednesday, September 28, 2022 Data Cleaning Data management Data Processing
I recently ran a latent class analysis for my choice experiment data using the "lclogit" command. I am trying to get the latent cl...
Margins after csdid.

Margins after csdid.

8:24 AM Data Cleaning Data management Data Processing
Dear All, I want to update my traditional DiD analyses with Callaway and Sant’Anna's (2021) semi-parametric DiD estimator using the csd...
test - xsmle and interpretation

test - xsmle and interpretation

6:24 AM Data Cleaning Data management Data Processing
Hey listers, I am using the "xsmle" command to run fixed effects models on panel data. I am particularly interested in computing...
Is -python script- much slower in Stata 17 than in Stata 16?

Is -python script- much slower in Stata 17 than in Stata 16?

5:23 AM Data Cleaning Data management Data Processing
I use the tuples command (from SSC). The tuples command is implemented in terms of python script and, optionally, uses Mata code. I run...
How to export polychoric matrix results

How to export polychoric matrix results

5:23 AM Data Cleaning Data management Data Processing
Hello everyone I have now searched far and wide for an answer to this question. I am using polychoric matrices in a paper that I am workin...
Expanding obs depending on several variables

Expanding obs depending on several variables

4:23 AM Data Cleaning Data management Data Processing
Dear Statalist, I have a dataset of several firms patenting. However, there are patents with more than one firm, which is captured by differ...
Not show "Standard errors in parenthesis *p <0.10, **p<0.05, ***p<0.001" below table, while keeping the significance stars with esttab

Not show "Standard errors in parenthesis *p <0.10, **p<0.05, ***p<0.001" below table, while keeping the significance stars with esttab

Tuesday, September 27, 2022 Data Cleaning Data management Data Processing
Hey everyone, As in the title, I'd like to save my regression results in a table, however, I can't seem to find a way to keep the ...
Xtabond2 for system GMM. Please help me for coding

Xtabond2 for system GMM. Please help me for coding

3:23 PM Data Cleaning Data management Data Processing
Dear all, I am working with the xtabond2 command in Stata to solve the endogeneity problem of my estimation. I read the construction of do...
Does gen,sum() and egen,total() work differently when combined with bysort?

Does gen,sum() and egen,total() work differently when combined with bysort?

2:24 AM Data Cleaning Data management Data Processing
Hi, Please consider the following data: Code: * Example generated by -dataex-. For more info, type help dataex clear input float(distid...
How to make a graph that shows reliable and clinically significant change in particular variable?

How to make a graph that shows reliable and clinically significant change in particular variable?

Monday, September 26, 2022 Data Cleaning Data management Data Processing
Dear Statalisters, I appreciate if anyone can help with how to make a graph showing reliable and clinically significant change in particul...
how to use stcurve for Cox model after multiple imputation?

how to use stcurve for Cox model after multiple imputation?

10:23 PM Data Cleaning Data management Data Processing
Hello, Statalist! I have a question about the stcurve after a multiple imputation. So, after the following command: mi estimate:stcox v...
Interpretation for Vector Error Correction Model with 4 variables and 2 cointegration vectors

Interpretation for Vector Error Correction Model with 4 variables and 2 cointegration vectors

6:23 PM Data Cleaning Data management Data Processing
I have 4 time series variables, y, x, z, w,, which are filtered by tsmooth command. I tried to do cointegration test for these 4 variables ...
Selectively list date variable as matrix row name using macro

Selectively list date variable as matrix row name using macro

3:23 PM Data Cleaning Data management Data Processing
Greetings, I'm hoping for some aid here. Having searched the forum for a solution, I've yet to find one that works. Here is the code...
Code help: Monte Carlo simulation

Code help: Monte Carlo simulation

2:23 PM Data Cleaning Data management Data Processing
I've attached a small Do file for a Monte Carlo Simulation I am running for an economics class. For some reason the code errors. Can any...
Cluster based on string similarity

Cluster based on string similarity

4:24 AM Data Cleaning Data management Data Processing
Hey Community, I'm quite new to working with Stata and therefore desperately looking for help! I have a dataset consisting of >200 ...
Obtaining main results after jwdid

Obtaining main results after jwdid

3:23 AM Data Cleaning Data management Data Processing
Hello, I have just started to use jwdid command, however, I cannot see the effect on main coefficients as the output list is too long. How c...
How to get the predicted value of each group?

How to get the predicted value of each group?

Sunday, September 25, 2022 Data Cleaning Data management Data Processing
Dear all, I want get the predicted value of each regression of each group? Here is an example. Code: webuse grunfeld,clear forval i =...
Dropping observations if entity does not exist in both waves

Dropping observations if entity does not exist in both waves

8:23 PM Data Cleaning Data management Data Processing
Hi, I am new to Stata and trying to undertake a task for a stat class. I have a dataset containing two waves of a survey, and I want to ...
Making balanced panel by dropping observation based on a certain variable

Making balanced panel by dropping observation based on a certain variable

3:24 PM Data Cleaning Data management Data Processing
I want to make a balanced panel based on my ln_wage outcome variable. In my data most of data has 22 observations fro 22 years. But, there a...
IF statement using a local string variable

IF statement using a local string variable

12:23 PM Data Cleaning Data management Data Processing
I have a code that looks like the below (minimum working example). A loop that loops through 2 scenarios. Each scenario will use a different...
How can we set Stata so that potential commands would pop up downward whenever we type in a string or word?

How can we set Stata so that potential commands would pop up downward whenever we type in a string or word?

9:23 AM Data Cleaning Data management Data Processing
Hey colleagues, Today I was asked a question by a student of my intro. stat. using Stata class. Please refer to the attached picture clip....
keep if

keep if

7:23 AM Data Cleaning Data management Data Processing
Hi, I want to use " keep if" to keep a subset of observations in my dataset, but I get an error: Type mismatch This is the inst...
Saving matrices of results

Saving matrices of results

4:23 AM Data Cleaning Data management Data Processing
Hello all, I wonder if someone could help me. I'm using this code to save the results from quantile regressions. The strange thing is...
mitigate against the potential problem of life-cycle effects

mitigate against the potential problem of life-cycle effects

4:23 AM Data Cleaning Data management Data Processing
Dear Stata community, My data is panel data, and the independent variable is available only in the last year, so it's time invariant. ...
repeated time values within panel: combining rows with the same date

repeated time values within panel: combining rows with the same date

Saturday, September 24, 2022 Data Cleaning Data management Data Processing
Hi all, My question is about a panel data set for which in would like to regress a certain monthly score on holding period returns of equi...
Generating mean by interacting categorical variables

Generating mean by interacting categorical variables

3:23 PM Data Cleaning Data management Data Processing
Hi all I would like to generate a new variable newvar that is the mean of the dummy variable dummy by the interaction of year and place ...
remove * from string

remove * from string

8:24 AM Data Cleaning Data management Data Processing
Hello I have a variable Value, which is the value of some assets. The data is imported from excel and is in string format. For some values,...
Fitstat gives error message

Fitstat gives error message

7:23 AM Data Cleaning Data management Data Processing
Hi all, When I use fitstat after a ologit regression, I get this message: Code: . fitstat Measures of Fit for ologit of A1 variable _...
Count how often an ID occurs in a column

Count how often an ID occurs in a column

5:23 AM Data Cleaning Data management Data Processing
Hi, I have a question which should be fairly easy to answer. I have a variable in my dataset called ind_id (individual ids). I want to get...
how to choose one variable with non-missing value among 3 variables

how to choose one variable with non-missing value among 3 variables

4:23 AM Data Cleaning Data management Data Processing
Dear all, I have a set of data for firm deals. For each deal, there are 3 completion dates, Completeddate, Expectedcompletiondate, and Ass...
How to increase the category size in STATA

How to increase the category size in STATA

2:23 AM Data Cleaning Data management Data Processing
Please tell me how to increase the category size in the STATA output table. here I am attaching the STATA output table: orga11 1 3 4 Tot...
stratifying parametric lognormal regression model

stratifying parametric lognormal regression model

Friday, September 23, 2022 Data Cleaning Data management Data Processing
I wanted to find out how I can stratify a parametric regression model by a variable. So assuming I fit a lognormal distribution on ethnicity...
Variables selection methods , minimum number of variables - max information

Variables selection methods , minimum number of variables - max information

3:23 AM Data Cleaning Data management Data Processing
Good morning to everyone, I am trying to run a SEM with more levels: the fact is that it is very heavy and I would like to reduce variables...
Is it prudent to use both logistic regression and parametric survival models on same dataset?

Is it prudent to use both logistic regression and parametric survival models on same dataset?

2:23 AM Data Cleaning Data management Data Processing
I am doing a study which has two objectives: effects of variables on timing to vaccination factors associated with delays to vaccination ...
Dataset for Health Econometrics

Dataset for Health Econometrics

Thursday, September 22, 2022 Data Cleaning Data management Data Processing
Hello, I am reading a Book on "Applied Econometrics for Health" and they recommended a dataset called "Health and Lifestyle ...
Grouping with a condition

Grouping with a condition

6:23 PM Data Cleaning Data management Data Processing
Hello all, Below is the data I am using: Code: * Example generated by -dataex-. To install: ssc install dataex clear input double(star...
Bar graph: switching grouping category

Bar graph: switching grouping category

4:23 PM Data Cleaning Data management Data Processing
Hi everyone, Seems like a simple thing to do, but I can't figure it out. Code: graph bar innovation_faith innovation_reforms innov...
merge and reshape survey data (with ordinal and numerical variables) to long data

merge and reshape survey data (with ordinal and numerical variables) to long data

2:24 PM Data Cleaning Data management Data Processing
Hello and thank you for reading - I am dealing with survey data from 7 years and I need to merge them using the participants ID (nomem_enc...
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)
      • Coefplot graph error despite running the regression
      • anycount
      • Multiple commands in one line stored in a local
      • Problems with regressions (regress.ado r(199)
      • formula into regression
      • Generate New Variable = Average Price Per Type Per...
      • Monte Carlo Simulation
      • Endogeneity correction via Gaussian Copulas - gene...
      • Help generating this type of plot
      • Lag of variable with condition of not being misssing
      • Post estimation models for latent class analyses
      • Margins after csdid.
      • test - xsmle and interpretation
      • Is -python script- much slower in Stata 17 than in...
      • How to export polychoric matrix results
      • Expanding obs depending on several variables
      • Not show "Standard errors in parenthesis *p <0.10,...
      • Xtabond2 for system GMM. Please help me for coding
      • Does gen,sum() and egen,total() work differently w...
      • How to make a graph that shows reliable and clinic...
      • how to use stcurve for Cox model after multiple im...
      • Interpretation for Vector Error Correction Model w...
      • Selectively list date variable as matrix row name ...
      • Code help: Monte Carlo simulation
      • Cluster based on string similarity
      • Obtaining main results after jwdid
      • How to get the predicted value of each group?
      • Dropping observations if entity does not exist in ...
      • Making balanced panel by dropping observation base...
      • IF statement using a local string variable
      • How can we set Stata so that potential commands wo...
      • keep if
      • Saving matrices of results
      • mitigate against the potential problem of life-cyc...
      • repeated time values within panel: combining rows ...
      • Generating mean by interacting categorical variables
      • remove * from string
      • Fitstat gives error message
      • Count how often an ID occurs in a column
      • how to choose one variable with non-missing value ...
      • How to increase the category size in STATA
      • stratifying parametric lognormal regression model
      • Variables selection methods , minimum number of va...
      • Is it prudent to use both logistic regression and ...
      • Dataset for Health Econometrics
      • Grouping with a condition
      • Bar graph: switching grouping category
      • merge and reshape survey data (with ordinal and nu...
      • Start-of period controls in first difference estim...
      • Undiscovered mistake in regression with interactio...
      • Multiply and add
      • cluster/village fix effects
      • Ordering legend only in graph
      • Reshaping data from wide to long
      • Draw a stratified random sample
      • eclass store results
      • unknown function () in a simple generate command
      • how to write the loop statement?
      • Reverse the color of spmap
      • Help with boostrap code for indirect effects using...
      • Plotting a graph with several observations per year
      • MLE Function
      • Creating a unique household ID (HHID).
      • Outputting data in Word with formatting, preferabl...
      • Issue running xtreg commands with scalar
      • Loop with the command usespss in Stata 16
      • Summary statistics for 2 dimensions
      • loop
      • Lasso bug - always included variable disappears
      • Problems with importing datasheat
      • eventstudy 2 by Thomas Kaspereit - Implementation ...
      • Trouble horizontally orienting estpost tabstat tab...
      • Holtz-Eakin, Newey and Rosen regression on a lagge...
      • Creating a variable that is chosen from two differ...
      • support - neophyte stata
      • Display p-values with psmatch2 command
      • Lagrange Multiplier
      • change to long format
      • Dropping the whole group based on condition relati...
      • Original data source for colon.dta in strs
      • Major concern about xtdidregress after checking
      • How to generate count/ average no. of person
      • Trouble with stata outputs: graphing multiple catv...
      • Spatial shocks: when is collinearity too much?
      • The problem with count if syntax regarding encoded...
      • PPML estimation with bilateral trade agreement dum...
      • Confusion about the example in STATA help file of ...
      • Seeking help with unbalanced panel data analysis
      • How to deal with treatment assignment times vary p...
      • Collapsing observations in different rows
      • Issue with Graph Title Position - Issue with Ring ...
      • Confusion about command didregress in DiD help file
      • Panel-Data regression with time dummies, FE and ti...
      • Mixed or xthybrid for time varying covariates in l...
      • Converting a variable like Income in Nominal Terms...
      • Whether we should control for country-level contro...
      • Table command in stata 16 does not allow statistic...
      • binary choice model after collapse
      • Manually calculating IV standard errors and gettin...
      • Why many commands do not work?
    • ►  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