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
random treatment,50 times loop and store the estimate with p value for the variable of interest (POST) and display.

random treatment,50 times loop and store the estimate with p value for the variable of interest (POST) and display.

Monday, September 30, 2019 Data Cleaning Data management Data Processing
Hi, I want to randomly assign treatment and run the same regression in the loop for 50 times and then I want to see how many times my vari...
Interpreting dummy variable with no constant in the model

Interpreting dummy variable with no constant in the model

11:02 PM Data Cleaning Data management Data Processing
Hi statalist, I have a question regard to how to interpreting dummy variable with no constant in the model. For example, in this cross secti...
Replacing Contents of All Variables

Replacing Contents of All Variables

9:27 PM Data Cleaning Data management Data Processing
I have a data set in which I have students' grades for their 30 subjects aprox. These are letter grades like A*, A, B,... I want to conv...
ppml: Number of regressors excluded

ppml: Number of regressors excluded

5:42 PM Data Cleaning Data management Data Processing
Hi, I am using the PPML estimator but I am not really sure what does it mean?: "Number of regressors excluded to ensure that the es...
Smoothing Kaplan Meier Curves

Smoothing Kaplan Meier Curves

5:42 PM Data Cleaning Data management Data Processing
Hello STATA Community, I am a new STATA user and I am trying to compute smooth Kaplan Meier curves. Is this possible? After created my s...
Adding time variables

Adding time variables

5:24 PM Data Cleaning Data management Data Processing
Hi, I am currently working with time data. The following is the time each person spends alone on each activity (25 activities, shown only ...
Syntax of cross-classified multilevel model

Syntax of cross-classified multilevel model

1:27 PM Data Cleaning Data management Data Processing
Dear Statalist, I need to analyze data with complex structures. My data set consists of individuals who are fully nested within teams, wh...
Out of Sample/Scope Prediction with CI

Out of Sample/Scope Prediction with CI

12:47 PM Data Cleaning Data management Data Processing
I need some help to get more details for Examples 2&3 to work (page 7 in regress postestimation — Postestimation tools for regress ) ht...
IV

IV

12:17 PM Data Cleaning Data management Data Processing
Dear all, I have a question concerning a comment from a reviewer and I am not quite sure how to go about it. To keep it simple, I have a p...
.

.

12:02 PM Data Cleaning Data management Data Processing
.
Data management problem

Data management problem

11:02 AM Data Cleaning Data management Data Processing
Hi I am trying to analyze some data, and have entered some commands,..as reproduced below,.. however when i get to the loop in red,..i...
ci for categorial variables - tabci?

ci for categorial variables - tabci?

9:02 AM Data Cleaning Data management Data Processing
I'm just wondering why Stata gives CIs for binary variables - ci proportions varname - but, as far as I tried to find, we cannot have re...
Command stir does not accept iweights

Command stir does not accept iweights

8:52 AM Data Cleaning Data management Data Processing
Hello I've been using the command stir (incidence rate comparison). The manual says that stir allows iweights and fweights (more specif...
Replace if not found within a loop

Replace if not found within a loop

7:22 AM Data Cleaning Data management Data Processing
Dear all, I am trying to bottom and top coding the household income for each country - wave. I am using the following loop that I already ...
endogenous switching regression model

endogenous switching regression model

7:22 AM Data Cleaning Data management Data Processing
Hello, Please I am new in stata so it's quite difficult for me to solve some regression problems. Actually, I am trying to estimate a...
-dstdize- to calculate average age-adjusted death rate by race

-dstdize- to calculate average age-adjusted death rate by race

7:22 AM Data Cleaning Data management Data Processing
Good Morning, I would like to calculate the average age-adjusted death rate by race (separately for whites and blacks), and test if the ra...
Can I test country level data and firm level data in one regression

Can I test country level data and firm level data in one regression

7:22 AM Data Cleaning Data management Data Processing
Hello everyone, I'm trying to find the effects of culture on the existence of teamwork. My dataset consists of 29 countries and of aro...
Generating a new variable that equals the Nth non-missing value in a row

Generating a new variable that equals the Nth non-missing value in a row

6:42 AM Data Cleaning Data management Data Processing
Hi All, I am essentially trying to compress a row of variables into just the non-missing entries. My dataset looks like this Code: * E...
working out expressions(sum and multiply) in stata with some missing observations

working out expressions(sum and multiply) in stata with some missing observations

5:22 AM Data Cleaning Data management Data Processing
Hi Nick Cox I want to add and multiply certain variables in stata in a new variable VaR. My expression is: gen VaR=constant_term+ (coef...
two stage IV approch

two stage IV approch

5:02 AM Data Cleaning Data management Data Processing
bootstrap "repeated time values within panel" 2 SRI I'm trying to run 2sri approach(control function) in Stata 15. My first ...
Looping Over the numeric value of a variable and use it for the subsequent loop.

Looping Over the numeric value of a variable and use it for the subsequent loop.

3:42 AM Data Cleaning Data management Data Processing
Hi, thanks for your help in advance. I have the following dataset. And I come up with the following code: Code: egen t=max(dateday_coun...
Marginal effect after heckpoisson

Marginal effect after heckpoisson

1:42 AM Data Cleaning Data management Data Processing
Dear All, I am new to stata and I am using Heckpoisson, a poison regression model with endogenous sample selection model to estimate facto...
Numbering occurrences of a flag within patients.

Numbering occurrences of a flag within patients.

12:12 AM Data Cleaning Data management Data Processing
In the example below I have created OVERLAP_FLAG, which is equal to 1 where two consecutive regimens overlap and their start dates are withi...
Generate a new variable in a loop in different files and calculating the mean

Generate a new variable in a loop in different files and calculating the mean

Sunday, September 29, 2019 Data Cleaning Data management Data Processing
Hi, I want to write a loop to generate a new variable called savings (income-expenditure) in two separate files. Use sample weights with n...
how to export Summary Statistics to word

how to export Summary Statistics to word

11:32 PM Data Cleaning Data management Data Processing
Dear Sir/Madam I am working on my thesis on impact of informal credit on household welfare. I try to generate summary statistics for comman...
Adding partner data to responding person data in a panel data file

Adding partner data to responding person data in a panel data file

10:17 PM Data Cleaning Data management Data Processing
I wish to extend my analysis of panel data to include information about the responding person's partner so I began the process of mergin...
Matching observations across boundaries

Matching observations across boundaries

6:32 PM Data Cleaning Data management Data Processing
I am looking at houses on each side of a designated geographical boundary. Does anyone know how to match house characteristics on either s...
F test for cof.

F test for cof.

6:22 PM Data Cleaning Data management Data Processing
Hello everyone, My model is: Y = b0 + b1.x1 + b2.x2 + b3.x3 + e and I use GMM for this model. I want to test b1 + b2 < 0 by F-test ...
Panel data with three identifiers

Panel data with three identifiers

5:12 PM Data Cleaning Data management Data Processing
Dear All, I am currently working with a country-year panel dataset which has data for value added for multiple sectors. It looks as follow...
Split to multiple files, merge and append

Split to multiple files, merge and append

12:52 PM Data Cleaning Data management Data Processing
I have two files, each with 3 variables. The first one has date, city, and score. The second one has date, city and ret. Each has 49 citie...
Loop for running individual regression for sectors and then taking average of all coefficients

Loop for running individual regression for sectors and then taking average of all coefficients

11:57 AM Data Cleaning Data management Data Processing
Hi, I have to run three regressions , from three separate files and then take a mean of all explanatory variables (for national estimate) b...
Generate an initiale value for each five year interval in unbalanced panel data

Generate an initiale value for each five year interval in unbalanced panel data

5:52 AM Data Cleaning Data management Data Processing
Hi dear Statalister, I have an unbalanced panel data and i want to generate a new variable. This variable should take the first value of va...
Predictions using gologit2 - issues applying coeffcients to validation dataset

Predictions using gologit2 - issues applying coeffcients to validation dataset

5:32 AM Data Cleaning Data management Data Processing
I'm new to Stata, so apologies in advance if this is a basic question. I am having some issues applying coefficients from my gologit2 mo...
Forcing my Event Study through R2000 in loops

Forcing my Event Study through R2000 in loops

4:42 AM Data Cleaning Data management Data Processing
Hey Everyone, I'm currently trying to run a regression/prediction of some abnormal returns. All good so far, but during my iteration, ...
Merging multiple Spss data sets into STATA

Merging multiple Spss data sets into STATA

4:22 AM Data Cleaning Data management Data Processing
Hi, I'm trying to merge a few UNICEF MICS survey data files together which are on Spss onto stata, for example file ch.sav with hh.sav. ...
Specification of funnel plot with -funnelcompar-

Specification of funnel plot with -funnelcompar-

3:52 AM Data Cleaning Data management Data Processing
Hi Statalisters I want to assess county differences in medication rates in Norway to detect outliers. For this purpose I want to use funne...
Specification of funnel plot with -funnelcompar-

Specification of funnel plot with -funnelcompar-

3:42 AM Data Cleaning Data management Data Processing
Hi Statalisters I want to assess county differences in medication rates in Norway to detect outliers. For this purpose I want to use funne...
Panel data with fixed effects model having dummy/time-invariant variables in data set

Panel data with fixed effects model having dummy/time-invariant variables in data set

3:32 AM Data Cleaning Data management Data Processing
Greetings, I'm trying to conduct FE-model test on my panel data set. The panel consists of 116 companies, observed over 5 years. Withi...
Generating a new variable based on several specified conditions

Generating a new variable based on several specified conditions

3:02 AM Data Cleaning Data management Data Processing
Dear Stata-Community, I am currently working on a paper in which I want to create a variable that indicates the number of respondents that ...
Test for differences in Medians for Multiple Variables Using qreg

Test for differences in Medians for Multiple Variables Using qreg

1:02 AM Data Cleaning Data management Data Processing
Dear Stata Users: I would like to Test for differences in Medians for Multiple Variables Using qreg following the Stata Journal HTML Code:...
Generate mean and median test results in Stata

Generate mean and median test results in Stata

12:52 AM Data Cleaning Data management Data Processing
Dear Stata Users: I am trying to generate mean and median test results in Stata. Thanks to Kain Chen HTML Code: http://kaichen.work/?p=1...
Type mismatch issues with generating / replacing

Type mismatch issues with generating / replacing

Saturday, September 28, 2019 Data Cleaning Data management Data Processing
Hi all, I'm currently trying to create a dummy variable, inlaborforce, using the below code: gen inlaborforce = 0 replace inlaborfo...
Create several nested regression tables in the same file with asdoc

Create several nested regression tables in the same file with asdoc

7:37 PM Data Cleaning Data management Data Processing
Dear all, I want to create several nested regression tables in the same file and do it with option reset in asdoc. However, the created f...
Model selection to study individual fund attribute's impact

Model selection to study individual fund attribute's impact

7:22 PM Data Cleaning Data management Data Processing
hi, I have daily data for large number of exchange traded funds for 10 years . I am trying to examine the fund attributes such as expense ...
test

test

6:26 PM Data Cleaning Data management Data Processing
Code: l
-xtlogit- Four-Way Dummy Variable Interaction Term Interpretation

-xtlogit- Four-Way Dummy Variable Interaction Term Interpretation

5:21 PM Data Cleaning Data management Data Processing
I have a two-year panel data set of patients who all received a treatment at the end of year 1. The panel is split into eight 3-month period...
Having Variables in X-Axis side by side, rather than in different groups..

Having Variables in X-Axis side by side, rather than in different groups..

4:01 PM Data Cleaning Data management Data Processing
Hello all, probably a very basic question but I am brand new to stata and trying to teach it to myself (Stata 16) I am trying to create a ...
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Latest Articles

Categories

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

Popular Articles

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

Recomended Articles

Powered by Blogger.

About Me

Mtenga Baltazar
View my complete profile

Blog Archive

  • ►  2024 (6)
    • ►  February (6)
  • ►  2023 (877)
    • ►  November (1)
    • ►  October (9)
    • ►  September (14)
    • ►  July (9)
    • ►  June (15)
    • ►  May (133)
    • ►  April (174)
    • ►  March (176)
    • ►  February (157)
    • ►  January (189)
  • ►  2022 (2201)
    • ►  December (181)
    • ►  November (180)
    • ►  October (198)
    • ►  September (182)
    • ►  August (182)
    • ►  July (194)
    • ►  June (174)
    • ►  May (167)
    • ►  April (181)
    • ►  March (186)
    • ►  February (170)
    • ►  January (206)
  • ►  2021 (7379)
    • ►  December (327)
    • ►  November (645)
    • ►  October (646)
    • ►  September (639)
    • ►  August (557)
    • ►  July (649)
    • ►  June (656)
    • ►  May (697)
    • ►  April (683)
    • ►  March (697)
    • ►  February (518)
    • ►  January (665)
  • ►  2020 (7956)
    • ►  December (653)
    • ►  November (659)
    • ►  October (598)
    • ►  September (654)
    • ►  August (660)
    • ►  July (682)
    • ►  June (683)
    • ►  May (708)
    • ►  April (692)
    • ►  March (698)
    • ►  February (638)
    • ►  January (631)
  • ▼  2019 (9458)
    • ►  December (601)
    • ►  November (643)
    • ►  October (650)
    • ▼  September (637)
      • random treatment,50 times loop and store the estim...
      • Interpreting dummy variable with no constant in th...
      • Replacing Contents of All Variables
      • ppml: Number of regressors excluded
      • Smoothing Kaplan Meier Curves
      • Adding time variables
      • Syntax of cross-classified multilevel model
      • Out of Sample/Scope Prediction with CI
      • IV
      • .
      • Data management problem
      • ci for categorial variables - tabci?
      • Command stir does not accept iweights
      • Replace if not found within a loop
      • endogenous switching regression model
      • -dstdize- to calculate average age-adjusted death ...
      • Can I test country level data and firm level data ...
      • Generating a new variable that equals the Nth non-...
      • working out expressions(sum and multiply) in stata...
      • two stage IV approch
      • Looping Over the numeric value of a variable and u...
      • Marginal effect after heckpoisson
      • Numbering occurrences of a flag within patients.
      • Generate a new variable in a loop in different fil...
      • how to export Summary Statistics to word
      • Adding partner data to responding person data in a...
      • Matching observations across boundaries
      • F test for cof.
      • Panel data with three identifiers
      • Split to multiple files, merge and append
      • Loop for running individual regression for sectors...
      • Generate an initiale value for each five year inte...
      • Predictions using gologit2 - issues applying coeff...
      • Forcing my Event Study through R2000 in loops
      • Merging multiple Spss data sets into STATA
      • Specification of funnel plot with -funnelcompar-
      • Specification of funnel plot with -funnelcompar-
      • Panel data with fixed effects model having dummy/t...
      • Generating a new variable based on several specifi...
      • Test for differences in Medians for Multiple Varia...
      • Generate mean and median test results in Stata
      • Type mismatch issues with generating / replacing
      • Create several nested regression tables in the sam...
      • Model selection to study individual fund attribute...
      • test
      • -xtlogit- Four-Way Dummy Variable Interaction Term...
      • Having Variables in X-Axis side by side, rather th...
      • Order of lincom output within a regression results...
      • Using predicted variables from principal component...
      • In a fixed effects logit regression does Stata onl...
      • Generating a new variable from one variable and pa...
      • Stata shows "wrong" value
      • Difficulty in stata codes
      • convergence not achieved in qreg
      • Merging multiple files in multiple folder on diffe...
      • 3d graph
      • Calculating compound annual growth rate using the ...
      • Inlist Expression too long
      • Blank estimation values with non linear least squares
      • Is it necessary to use the unit root test before e...
      • date differences using max values where ID values ...
      • reghdfe
      • How to address two idenpendent random intercepts i...
      • Lags for Newey West Standard Errors in fmb
      • Storing Cumulative Risk Values
      • Test for trend using mi postestimation
      • multilevel models with non-nested data
      • Difference in Difference (DiD) with xtabond and xt...
      • Using a nested foreach loop to merge and then appe...
      • P-Value
      • Age Period Cohort analysis Graphs
      • Technical problem: A regression model runs slowly
      • How to use lnmvnormalden(M,V,X) function (natural ...
      • List string values of multiple varlists
      • Small sample of 38 observations
      • Conflicting results in did and dose response models
      • Generate/replace new variables in a repetitive way...
      • Change over time
      • Code blocks on this forum need fixing
      • question to stset _t and _t0
      • Trust game and a new method to measure reciprocity
      • Help with -foreach loop command
      • rerun the code to count TFP and error continues to...
      • Regressing panel data returns "repeated time value...
      • Changing a variable by a factor of 1000
      • Correlation and regression
      • Panel Fixed Effect, Clustering Standard Error (Pan...
      • Hedge fund data set for stata
      • Ideas on how to convert a hyphenated interval (e.g...
      • loop over the panel IDs to use quantile regression...
      • OLS model that includes related covariates that ad...
      • Help with outputting Mixed command results to Excel
      • Premature Deindustrialization
      • Merging two files on multiple criteria and imperfe...
      • Xtqreg-qunaitle regression in a panel data
      • xtline and standard deviation
      • create a new variable from weighted variables?
      • New on SSC - complexity : computes Complexity Inde...
      • Bilateral exchange rate data with and without make...
      • Generating a wave (time) variable in a panel data set
    • ►  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