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
Sequence Index Plot

Sequence Index Plot

Thursday, October 31, 2019 Data Cleaning Data management Data Processing
Dear Stata Users I am trying to show how individuals move between a set of conditions or states over time. I think a sequence index plot s...
problem with Ivreg2 result

problem with Ivreg2 result

8:44 PM Data Cleaning Data management Data Processing
Dear All, After running my regression with ivreg2, in last portion of the result I saw error massage which contains the following: Warning...
Complex Reshape Long to Wide

Complex Reshape Long to Wide

8:44 PM Data Cleaning Data management Data Processing
Dear Stata Users I am dealing with a complex reshape wide problem. Here is an input data: Code: * Example generated by -dataex-. To...
multicollinearity test variables in a panel data

multicollinearity test variables in a panel data

8:09 PM Data Cleaning Data management Data Processing
Hi, how can I run a multicollinearity test in Stata 12 between variables in a panel data? Thanks!
Solve Macroeconometrics Model and Forecast

Solve Macroeconometrics Model and Forecast

6:21 PM Data Cleaning Data management Data Processing
I am trying to solve a macroeconometrics model of my country using STATA. Model has 7 endogenous variables and 7 equations. There is consump...
T Tests and Wilcoxon Tests export to MS Word or MS Excel

T Tests and Wilcoxon Tests export to MS Word or MS Excel

5:21 PM Data Cleaning Data management Data Processing
Hello Members I had been working on EViews for some time, I shifted to Stata now, since I am new, I have been trying to calculate T and Wi...
Nested forvalue loops - referring to previous macros in a relevant macro

Nested forvalue loops - referring to previous macros in a relevant macro

8:41 AM Data Cleaning Data management Data Processing
Good afternoon. Could anyone help me decipher what syntax error I am producing in the below command sequence? /*Given*/ regress offspri...
Why the different bootstrap errors in panel data random effects?

Why the different bootstrap errors in panel data random effects?

8:41 AM Data Cleaning Data management Data Processing
Hi, in help xt_vce_options I found the following recommendation: When working with panel-data models, we strongly encourage you to use ...
Detecting inverted duplicates over two columns

Detecting inverted duplicates over two columns

8:12 AM Data Cleaning Data management Data Processing
Hello, I have searched for an answer to this simple question on previous forums, and cannot find the specific situation I am hoping to recti...
Is it possible to not set values of optional integer arguments with the syntax command

Is it possible to not set values of optional integer arguments with the syntax command

7:41 AM Data Cleaning Data management Data Processing
When specifying optional arguments integer arguments using the syntax command it is usually necessary to set a value. Is it possible to get ...
Keep the first observation within a moving 30-day window

Keep the first observation within a moving 30-day window

7:31 AM Data Cleaning Data management Data Processing
I have the following dataset. I want to keep d=1 for the first observation within 30-day moving window, and replace d=0 if the observation i...
Effect of schooling on menstruation methods

Effect of schooling on menstruation methods

5:36 AM Data Cleaning Data management Data Processing
Hello, I am trying to find the effect of schooling on mensuration methods from Indian context.These methods may include use of locally prep...
summary forest plot for meta-analysis

summary forest plot for meta-analysis

5:31 AM Data Cleaning Data management Data Processing
Hello, I am doing a study-level meta-analysis with different outcomes. In addition to the standard forest plots, I would like to produce a...
2:Setting manual coefficients

2:Setting manual coefficients

4:41 AM Data Cleaning Data management Data Processing
Hi Listers, Y = β1+ β2*Area + β3Labor + β4*Fertilizer + u This time its given that B4=3*B3. Which model should you use? Give the estima...
Applying Bai-Perron Test to Time Series data structured in panel format

Applying Bai-Perron Test to Time Series data structured in panel format

4:31 AM Data Cleaning Data management Data Processing
Hello, I have a panel dataset where data is there for each country. I want to run the stata command for each country. https://www.wiwiss...
Forecast errors

Forecast errors

4:16 AM Data Cleaning Data management Data Processing
Hi Statlist, I would like to compute the variance of forecast errors in a panel data setting as indicated in Array . In particular, I hav...
Issue with xlabel command

Issue with xlabel command

4:02 AM Data Cleaning Data management Data Processing
Hello, I am trying to change the labels of a graph (without using the editor) Code: graph box job_hours if expectation == 2, over(gift_r...
Panel Regression versus Dynamic Models

Panel Regression versus Dynamic Models

3:11 AM Data Cleaning Data management Data Processing
Dear all, I am trying to replicate a study, where I am regressing the change in capital expenditures(DELCAPEX) is regressed on cash flows(C...
generate or replace a variable -- with a string type

generate or replace a variable -- with a string type

3:11 AM Data Cleaning Data management Data Processing
Hi guys I have a string variable in the dataset. It contains a long list of heart diseases. I would like to categorise it into a few ones,...
Setting manual coefficients

Setting manual coefficients

3:01 AM Data Cleaning Data management Data Processing
For a hypothetical case in class the following question is asked: We have the following model: Y = β1+ β2*Area + β3Labor + β4*Fertilizer +...
Handling large percentage of zero-valued observations in the dependent variable in a panel dataset

Handling large percentage of zero-valued observations in the dependent variable in a panel dataset

2:51 AM Data Cleaning Data management Data Processing
I am writing a paper using a panel dataset in which my depepent variable has an large percentage amount of zero values observations. Those z...
correlation and proportional weights

correlation and proportional weights

2:31 AM Data Cleaning Data management Data Processing
Hello, I am not able to use proportional weights with correlation but can use analytical weights. Can anyone help me to explain the reason...
Competing risks in survival analyses

Competing risks in survival analyses

2:21 AM Data Cleaning Data management Data Processing
Dear reader, I would like to know the difference in my survival analysis approach. I have 4 types of events that I want to examine, and n...
Two-way table where cells are %s and Totals are frequencies

Two-way table where cells are %s and Totals are frequencies

2:01 AM Data Cleaning Data management Data Processing
Hello, Is there a way to create a two-way table where the cells are percentages and the totals are the actual frequencies? I'm sure I ...
reghdfe - "noconstant" as standard option

reghdfe - "noconstant" as standard option

1:41 AM Data Cleaning Data management Data Processing
Dear community, I would please like to ask for your help concerning the following question. Recently, the server I am allowed to work on...
test for statistical difference

test for statistical difference

1:01 AM Data Cleaning Data management Data Processing
Hi Stata fam I would like to test for statistical difference between responses from two different populations, a intervention site and a co...
Transforming time series data into Panel data

Transforming time series data into Panel data

12:37 AM Data Cleaning Data management Data Processing
Hello, I have a time series dataset, downloaded from UNCTAD. Then I pasted the data into Stata datasheet. The data is the following var...
Interacting an independent variable with fixed effects

Interacting an independent variable with fixed effects

Wednesday, October 30, 2019 Data Cleaning Data management Data Processing
Dear Statalist members, Thank you so much for reading this post and helping me answer my question! In short, my question is how I can run ...
Correct Modeling of Data

Correct Modeling of Data

5:41 PM Data Cleaning Data management Data Processing
Stata Experts: I have been struggling for several days with my data analysis plan and I am hoping for some clarity. 1. I am working with ...
General xtabond2 queries

General xtabond2 queries

5:31 AM Data Cleaning Data management Data Processing
Dear Statalist, I am examining quarterly data for an unbalanced panel of 11,000+ banks from 1996:Q1 to 2016:Q4 using Stata/IC. I am using ...
PPML for one country

PPML for one country

5:16 AM Data Cleaning Data management Data Processing
Hi, If I estimate a gravity model using PPML from a balanced data panel for a several number of countries, but I would like to focus only ...
Not concave issue with multinomiallogit regression

Not concave issue with multinomiallogit regression

5:06 AM Data Cleaning Data management Data Processing
Dear Satalis, I hope you are well. I would like to ask please regarding the problem of 'not concave' iteration. I have a dataset f...
covariance structure in mixed model

covariance structure in mixed model

4:16 AM Data Cleaning Data management Data Processing
Dear all, I've been having problems selecting the correct covariance structure and for my mixed model (employees nested within firms)....
How to save graphs from loop in particular folder

How to save graphs from loop in particular folder

3:26 AM Data Cleaning Data management Data Processing
How to save graphs from loop in a particular folder. I have my out foder: global MY_OUT "C:\Users\out" and the loop as belo...
How to extract a country specific value for each country in a panel data set

How to extract a country specific value for each country in a panel data set

3:21 AM Data Cleaning Data management Data Processing
I have a panel date set wich consists of 49 countries and want to extract fed funds rate for each country. The variable interestrate have in...
Unobserved Componenet Model and State Space Model

Unobserved Componenet Model and State Space Model

3:01 AM Data Cleaning Data management Data Processing
Dear All I am try trying to construct an index, using Unobserved Component Model (UCM) and State Space Model (SSM) in Stata, but I am real...
Variance of each single residual

Variance of each single residual

2:36 AM Data Cleaning Data management Data Processing
Hi Statlist, I am struggling into constructing the residuals' specific variance for the following model: Code: xtreg tasso_crescit...
Stata : Rr mantel heanzel

Stata : Rr mantel heanzel

2:36 AM Data Cleaning Data management Data Processing
I have SMR results by lauching this command : strate maxexpo_ardbis, per(100000) smr(taux_esto) and i want to have the RR of mantel Haenzel...
only the estimated coefficient

only the estimated coefficient

2:01 AM Data Cleaning Data management Data Processing
Hi, Which could be the reason that Stata does not show me only the estimated coefficient?: --------------------------------------------...
Ramsey test

Ramsey test

1:36 AM Data Cleaning Data management Data Processing
Hi, Which is the command in Stata 12 for the Ramsey Test with data panel? Thanks!
Number of rows and columns of subplots using xtline

Number of rows and columns of subplots using xtline

1:31 AM Data Cleaning Data management Data Processing
Hi, how can I define the number of rows/columns of subplots when using "xtline"? The options "rows()" and "cols()...
help with local macros

help with local macros

1:21 AM Data Cleaning Data management Data Processing
Dear all, I would like to create several boxplots at once and combine them. i found the code below and it works very well. can some one hel...
Problem with Reshape on Panel Data

Problem with Reshape on Panel Data

12:16 AM Data Cleaning Data management Data Processing
Hi all, My aim is to make variable id to be unique and I think reshape is the command instead of collapse. When I was tried with reshape ...
Data which contain Multiple followups with hours variables

Data which contain Multiple followups with hours variables

12:16 AM Data Cleaning Data management Data Processing
Dear Statlist Users, Hope all you experts are doing great.I wanted to understand how to analyze the data which contains multiple followups...
non-linear optimisation with linear restrictions

non-linear optimisation with linear restrictions

Tuesday, October 29, 2019 Data Cleaning Data management Data Processing
Dear all: I need to find the B vector that minimises the following non-linear function (B-A)*IM*(B-A) such that a linear restriction (also i...
Fixed Effect troubles

Fixed Effect troubles

11:16 PM Data Cleaning Data management Data Processing
Hello, I'm a first-time poster and newbie to the world of Stata. I am trying to estimate a fixed effects model with city as the entity v...
Scatter of a local

Scatter of a local

10:26 PM Data Cleaning Data management Data Processing
Hi, is it not possible to create a scatter of a local variable? I'm evaluating the difference in the probabilities of Y btn men and wome...
Reg without constant term

Reg without constant term

9:31 PM Data Cleaning Data management Data Processing
Hi, I know that when I estimate a regression with fixed effects the constant term should not be included. However, when I run the regress...
Help with Stata's Graphs

Help with Stata's Graphs

9:31 PM Data Cleaning Data management Data Processing
Hi I'm trying to build a Graph on Stata but the variability of my Data is very high. I need to build a Graph of Brazilian's Infla...
Attrition and OLS estimatos

Attrition and OLS estimatos

8:21 PM Data Cleaning Data management Data Processing
How can I prove that the attrition bias affects or does not affect my OLS estimator? Can I do it with a balance table between the group of ...
Analyzing two time points with regression

Analyzing two time points with regression

8:11 PM Data Cleaning Data management Data Processing
I am analyzing data with the mental health component score (measured 0-100) for 4500 individuals. This score was measured at baseline and th...
longitudinal population survey data

longitudinal population survey data

7:51 PM Data Cleaning Data management Data Processing
Hello, I have a longitudinal population survey data. This is actually my first time working with such a huge dataset, and I am having a re...
mi predict problem

mi predict problem

11:51 AM Data Cleaning Data management Data Processing
Dear all, I am having problems trying to get the baseline survivor function after mi predict. I am using the following code: mi predict ...
groups command, export/copy table to excel

groups command, export/copy table to excel

10:51 AM Data Cleaning Data management Data Processing
the groups function is a very useful command, however the output seems to be not very transferable - is there a way to export the results to...
How to recreate longitudinal analyses from SAS in STATA using xtgee only using SAS output???

How to recreate longitudinal analyses from SAS in STATA using xtgee only using SAS output???

10:41 AM Data Cleaning Data management Data Processing
Hello all, I have been trying to recreate SAS output in Stata but keep getting discrepancies. Unfortunately, the biostatistician only gave...
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Latest Articles

Categories

  • CouchDb Skills
  • Data Analysis
  • Data Cleaning
  • Data management
  • Data Processing
  • Research Methodology

Popular Articles

  • How to drop random years from panel data?
    I have a panel data set, consisting of 125 countries, 36 years. I want to run an IV regression multible times and randomly drop 5 (of the 36...
  • Saving pointer matrixes using -mata matsave-
    I am relatively new to the use of pointers in Mata and have thusfar been impressed with their utility. Specific to this query, I have been...
  • instrumenting a binary endogenous regressor
    Hello, I am trying to run a model with a binary endogenous regressor. I am still learning econometrics so I am sorry if this may be a trivi...
  • "tsegen" by group
    Hi, I would like to calculate the moving average of _b_LogSize _b_LogBM _b_MOM12 _b_cons by months of the year over the last 10 years. For...
  • Fixed Effects for a Panel at a Coarser Level
    Hello, I want to include some fixed effects in my model that I believe are difficult to include so any advice on how exactly this can be d...
  • RDD rdrobust problem
    Dear all, I am researching the effect of grade retention on exam results (which can vary from 0 to 20) and I am using a RDD to research th...
  • Growth model - No convergence
    I would like to develop a latent growth model (LGM) with Stata. The point is to illustrate estimated effects of predictors by using Stata...
  • Nvidia Organizational Structure: functional and hybrid
    Nvidia is 7th largest company in the world with a market cap of USD 1 trillion. Due to the size and scope of its operations, it is difficult...
  • Getting values from second to last loop of a -while- loop
    Hi fellow Statalisters, I am using a -while- loop for a particular application, where I need to retrieve a particular value from the secon...
  • Using weights with xtheckman | xtheckman's fixed effects equivalent
    Hi, I am using six waves of the PSID to estimate several determinants (particularly wealth) of the wage equation and the selection equatio...

Recomended Articles

Powered by Blogger.

About Me

Mtenga Baltazar
View my complete profile

Blog Archive

  • ►  2024 (6)
    • ►  February (6)
  • ►  2023 (877)
    • ►  November (1)
    • ►  October (9)
    • ►  September (14)
    • ►  July (9)
    • ►  June (15)
    • ►  May (133)
    • ►  April (174)
    • ►  March (176)
    • ►  February (157)
    • ►  January (189)
  • ►  2022 (2201)
    • ►  December (181)
    • ►  November (180)
    • ►  October (198)
    • ►  September (182)
    • ►  August (182)
    • ►  July (194)
    • ►  June (174)
    • ►  May (167)
    • ►  April (181)
    • ►  March (186)
    • ►  February (170)
    • ►  January (206)
  • ►  2021 (7379)
    • ►  December (327)
    • ►  November (645)
    • ►  October (646)
    • ►  September (639)
    • ►  August (557)
    • ►  July (649)
    • ►  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)
      • Sequence Index Plot
      • problem with Ivreg2 result
      • Complex Reshape Long to Wide
      • multicollinearity test variables in a panel data
      • Solve Macroeconometrics Model and Forecast
      • T Tests and Wilcoxon Tests export to MS Word or MS...
      • Nested forvalue loops - referring to previous macr...
      • Why the different bootstrap errors in panel data r...
      • Detecting inverted duplicates over two columns
      • Is it possible to not set values of optional integ...
      • Keep the first observation within a moving 30-day ...
      • Effect of schooling on menstruation methods
      • summary forest plot for meta-analysis
      • 2:Setting manual coefficients
      • Applying Bai-Perron Test to Time Series data struc...
      • Forecast errors
      • Issue with xlabel command
      • Panel Regression versus Dynamic Models
      • generate or replace a variable -- with a string type
      • Setting manual coefficients
      • Handling large percentage of zero-valued observati...
      • correlation and proportional weights
      • Competing risks in survival analyses
      • Two-way table where cells are %s and Totals are fr...
      • reghdfe - "noconstant" as standard option
      • test for statistical difference
      • Transforming time series data into Panel data
      • Interacting an independent variable with fixed eff...
      • Correct Modeling of Data
      • General xtabond2 queries
      • PPML for one country
      • Not concave issue with multinomiallogit regression
      • covariance structure in mixed model
      • How to save graphs from loop in particular folder
      • How to extract a country specific value for each c...
      • Unobserved Componenet Model and State Space Model
      • Variance of each single residual
      • Stata : Rr mantel heanzel
      • only the estimated coefficient
      • Ramsey test
      • Number of rows and columns of subplots using xtline
      • help with local macros
      • Problem with Reshape on Panel Data
      • Data which contain Multiple followups with hours v...
      • non-linear optimisation with linear restrictions
      • Fixed Effect troubles
      • Scatter of a local
      • Reg without constant term
      • Help with Stata's Graphs
      • Attrition and OLS estimatos
      • Analyzing two time points with regression
      • longitudinal population survey data
      • mi predict problem
      • groups command, export/copy table to excel
      • How to recreate longitudinal analyses from SAS in ...
      • Testing statistical difference for 4 variables
      • One sided meta analysis
      • Difference in Difference with multiple time periods
      • Compound double quotes for single quotes
      • Hausman Test producing different results
      • Collapse by what?
      • Multiple imputation when there is a certain group ...
      • Reshaping multiple variables at once
      • different 'Beta' values in the same Effect coding ...
      • Finding the values behind encode
      • How to find the index of the observation that has ...
      • Marginal Effects of a Fractional Response Model
      • 2SLS with an instrumented variable as an instrument
      • 4-year interval and retardation variable
      • matrix var nov with zeros for base dummy level
      • List of institutes
      • Network Meta analysis
      • Event Study in Corporate Finance
      • Ranking in descending order
      • Generating variable based on two groups
      • Baseline hazard function for Piecewise constant model
      • Variable labels and frmttable
      • Simple question on asdoc and label lengths
      • Find attrition at personal level
      • Meta Command for prevalences
      • Multilevel regresion code doubt
      • Break in consecutive values to identify groups
      • Tabout and Fre suddenly not working?
      • Keep a group of observations if one record meets a...
      • Discrete choice experiment : WTP with effects coding
      • ksmirnov Test
      • odbc load can't find data source
      • by()-option in twoway graphs: Getting rid of the b...
      • how to calculate the experience diversity of panels?
      • Survival analysis
      • Convolutions of two WTP empirical distributions
      • Export either table or tabdisp as latex file
      • Quantile regression t-stata insignificant
      • mediation package: medsens command and why it does...
      • Overlay 3 kaplan-meier survival graphs from 3 diff...
      • xtreg regression leaves out one country for i.country
      • Rescaling Time
      • Creating a variable with three condtions
      • Error Using the Command 'using'
      • Should I rename all the variables with the year im...
    • ►  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