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
clogit vs. xtlogit, fe

clogit vs. xtlogit, fe

Friday, May 31, 2019 Data Cleaning Data management Data Processing
Is there a difference between clogit and xtlogit, fe ? It appears to me they both do conditional logistic regression with fixed effects.
Time lag for Multi_level fixed effect panel data.

Time lag for Multi_level fixed effect panel data.

7:45 PM Data Cleaning Data management Data Processing
Hi all, I have some douts about time lagging for my independent variables in multi-way FE panel data (reghddfe). I have this panel model wi...
-sreshape-

-sreshape-

5:45 PM Data Cleaning Data management Data Processing
i just installed -sreshape- onto stata mp.. does anyone know if it has a max variable limit? i have 7500 vars in wide format that i wanted t...
Lasso regress questions

Lasso regress questions

5:45 PM Data Cleaning Data management Data Processing
Hi, I am college student from Barcelona. It is hard to learn Stata by myself because the teacher does not explain how to use commands, what ...
Add Text to Graph Combine

Add Text to Graph Combine

1:58 PM Data Cleaning Data management Data Processing
I am combining three graphs using 'graph combine'. By default they appear in a 2 x 2 arrangement with the lower right slot empty. I...
Obtaining mean and SD from survey data

Obtaining mean and SD from survey data

1:42 PM Data Cleaning Data management Data Processing
Hello, I am trying to get the differences in the length of stay(LOS) in subpopulation of myocarditis, categorized by whether they have arr...
Showing country-specific treatment effects

Showing country-specific treatment effects

12:32 PM Data Cleaning Data management Data Processing
Hello, I'm currently working with a dataset with individual respondents. In my analysis, I show the average treatment effect for the t...
Standard Error Correction in a two step process

Standard Error Correction in a two step process

11:47 AM Data Cleaning Data management Data Processing
Dear all I wonder if anyone has any references, and perhaps Stata applications, that can help me solve a problem like follows: Code: us...
WLS regression using regwls and regress

WLS regression using regwls and regress

10:47 AM Data Cleaning Data management Data Processing
Dear All, I have a question regarding WLS regression using Stata commands regwls and regress and would kindly ask for your help. For your...
Inverted Normal Graph

Inverted Normal Graph

10:42 AM Data Cleaning Data management Data Processing
Hello all, Admittedly a mundane question here... I'm simply trying to plot an inverted normal distribution for an upcoming presentatio...
How to do matrix exponential operation in Stata?

How to do matrix exponential operation in Stata?

8:02 AM Data Cleaning Data management Data Processing
Code: matrix A = (1,0,0,0,0\0.6,0,.4,0,0\0,.6,0,.4,0\0,0,.6,0,.4\0,0,0,0,1) matrix list A matrix B = A*A I know how to do A^2. Now I wan...
gsem covstruct

gsem covstruct

7:52 AM Data Cleaning Data management Data Processing
Hello. I am running LPA analysis using gsem command. I ve run the analysis in R using the mclust command too. The problem I have is that I ...
Generate balance table

Generate balance table

7:27 AM Data Cleaning Data management Data Processing
Hi, I'm trying to replicate this balance table (as in the picture) using some of the example datasets installed with Stata, in particula...
extract variable labels for new variable names

extract variable labels for new variable names

6:22 AM Data Cleaning Data management Data Processing
Hi there I try to automate my programming as much as possible and one challenge I've come up against recently is in trying to name new...
Count number of cases if dates are within a certain range (a la statsby)

Count number of cases if dates are within a certain range (a la statsby)

5:52 AM Data Cleaning Data management Data Processing
Greetings all, I have single line per observation survival data (4 million lines). Here is a simplified example default zip code dat...
Multinomial logit with sample selection

Multinomial logit with sample selection

4:52 AM Data Cleaning Data management Data Processing
Dear everyone, I am looking for something similar to Heckman selection model/svysemlog with a modification. I have a selectiion variabl...
Manually installing Blindschemes by Daniel Bischof

Manually installing Blindschemes by Daniel Bischof

4:22 AM Data Cleaning Data management Data Processing
Dear Statalisters I admit this is a bit of a non-problem, but I'd like to find a solution nonetheless. Never underappreciate a nice gr...
How to declare data with tournament structure as panel data?

How to declare data with tournament structure as panel data?

4:13 AM Data Cleaning Data management Data Processing
Dear all, I recently read some papers using panel data from sports. I started to wonder how one would actually declear data e.g. from tenn...
Drop ID if different observations for that same ID do not vary across another variable

Drop ID if different observations for that same ID do not vary across another variable

2:07 AM Data Cleaning Data management Data Processing
Hello, I am using Stata 14.2 on Windows. This is my first post so I hope I am doing this correctly. The dataset I am using contains arou...
Drop ID if different observations for that same ID do not vary across another variable

Drop ID if different observations for that same ID do not vary across another variable

2:02 AM Data Cleaning Data management Data Processing
Hello, I am using Stata 14.2 on Windows. This is my first post so I hope I am doing this correctly. The dataset I am using contains arou...
Mixed or reg i.country i.year for repeated cross-section data

Mixed or reg i.country i.year for repeated cross-section data

1:39 AM Data Cleaning Data management Data Processing
Dear all, I am doing a time-series cross-sectional data from 4 waves and around 25 countries and I am using Stata 14. The dataset used is ...
destring numbers in scientific notation

destring numbers in scientific notation

1:27 AM Data Cleaning Data management Data Processing
Dear community, I was inattentive when pasting data into a new stata-file and now the following problem presents itself: I have a unique n...
Interpretation of the interaction term when the relevant dummy variable is insignificant

Interpretation of the interaction term when the relevant dummy variable is insignificant

12:42 AM Data Cleaning Data management Data Processing
Dear all, In the model that I have run to analyse the effect of currency swaps on the gross capital flows of the countries signing them I ...
categorizing data

categorizing data

Thursday, May 30, 2019 Data Cleaning Data management Data Processing
Hi all, I have a dataset includes up to 30 string variables. Some of them are dummy variables and the others are categorized with a limited...
Droping observations with x amount of missing values

Droping observations with x amount of missing values

7:42 PM Data Cleaning Data management Data Processing
Dear all, I'm working with a messy data set with approximately 870 observations at the moment. After using the command missings table ...
Meta analysis of hazard ratio

Meta analysis of hazard ratio

5:47 PM Data Cleaning Data management Data Processing
Dear , My name is Hatem Ali I am trying to do meta analysis of hazard ratio to assess effect of rise in IL6 on overall survival I have th...
Creating a value that equals the average of other values for the same variable

Creating a value that equals the average of other values for the same variable

5:17 PM Data Cleaning Data management Data Processing
(Sorry about the poor phrasing of the question) My dataset contains variables such as country and prevalence of obesity , for 34 countries...
Collinearity error when including continuous variable in dummy regression

Collinearity error when including continuous variable in dummy regression

1:52 PM Data Cleaning Data management Data Processing
I am trying to run the following two regressions to compare the coefficients on the 'iso_str' dummies. The only difference between t...
getting a sample size

getting a sample size

11:52 AM Data Cleaning Data management Data Processing
hi, I'm trying to get the sample size of black women from my data set. I created a black women(bw) variable, counted the bw and then c...
Cluster Randomized Controlled Trial

Cluster Randomized Controlled Trial

11:22 AM Data Cleaning Data management Data Processing
I have a question about the Cluster Randomized Controlled Trial. Is it recommended to perform the svyset command when doing the Cluster Rand...
traj command with hierarchical data structure

traj command with hierarchical data structure

11:22 AM Data Cleaning Data management Data Processing
I'm interested in using the user-written traj command (link below) to identify latent trajectories of change in patients' BMIs. The...
Dipendent Double-Sorting 25 Portfolios

Dipendent Double-Sorting 25 Portfolios

11:17 AM Data Cleaning Data management Data Processing
Dear all, I am struggling to replicate the FF-25 portfolios with a variant, I should employ a dependent sort instead of a independent sort....
Generate variables with forvals

Generate variables with forvals

10:32 AM Data Cleaning Data management Data Processing
Hello Statalist, I have a dataset which contains the following variables: firm (every firm has an assigned number from 1-1000), their produ...
Interaction between variables changes the results fundamentally!

Interaction between variables changes the results fundamentally!

10:02 AM Data Cleaning Data management Data Processing
Dear All, I would appreciate your help on the following please: The correlation between y and x1 x2 is negative but between y and the inte...
Weighted least squares (WLS) with wls0 and regwls

Weighted least squares (WLS) with wls0 and regwls

9:52 AM Data Cleaning Data management Data Processing
Dear Statalist, I am conducting a long-run event study with the use of the Fama French 3 Factors model. I am using the WLS regression, I w...
Which Flavor of ADF Estimation Does Stata Use?

Which Flavor of ADF Estimation Does Stata Use?

8:53 AM Data Cleaning Data management Data Processing
Hey Everyone, with WLS/ADF estimation there are different flavors out there that are being used in statistics software. It is rather easy ...
fill in empty adjacent cells within a group

fill in empty adjacent cells within a group

8:37 AM Data Cleaning Data management Data Processing
Dear all, I would like to ask how to fill in empty adjacent rows within a group. Problem here is the confusing data structure. Code: ...
Test for a unit root using panel data

Test for a unit root using panel data

7:57 AM Data Cleaning Data management Data Processing
Dear Community, For my master thesis I want to test wether the error term of my model is stationary or not, in order to verify if the regr...
Losing groups while running a regression

Losing groups while running a regression

6:57 AM Data Cleaning Data management Data Processing
Hello, I am trying to make a panel data regression. My group variable (cntry) has 41 countries. But when I run a regression the number of ...
Latent class analysis categorical variables

Latent class analysis categorical variables

5:02 AM Data Cleaning Data management Data Processing
Dear all, I have been using latent class analysis in STATA 15 and have been able to get results using the gsem command for binary variable...
X11 Forwarding only showing half screen with Stata

X11 Forwarding only showing half screen with Stata

4:52 AM Data Cleaning Data management Data Processing
I am using PuTTY to do SSH tunneling and X11 Forwarding with an Amazon EC2 Ubuntu instance. Multiple individuals in my system login to their...
xtivreg2 - identifying singleton observations

xtivreg2 - identifying singleton observations

4:52 AM Data Cleaning Data management Data Processing
Dear All, I have a panel dataset with 18,071 observations. I am estimating the following model in stata: xtivreg2 ret2_w mret2_w s_r10...
Saving WTP estimates to conduct Poe Test

Saving WTP estimates to conduct Poe Test

4:22 AM Data Cleaning Data management Data Processing
Dear all I have run a clogit model and have estimated wtp via wtp, krisnky command. I now want to save the wtp estimates so I can perform ...
Formatting and managing dates, from String to MMYYYY format

Formatting and managing dates, from String to MMYYYY format

4:07 AM Data Cleaning Data management Data Processing
Dear All, I am a new user in Stata. I am having a basic question and would kindly ask for your help. I want to change the data format from...
Bootstrap

Bootstrap

3:42 AM Data Cleaning Data management Data Processing
Hi everyone, I need some help with understanding why STATA doesn't let me use the command: bootstrap_b. It writes: unrecognized comma...
Advices on how to learn systematically how to work with panel

Advices on how to learn systematically how to work with panel

3:22 AM Data Cleaning Data management Data Processing
Hi everyone, I have very elementary skills in econometrics and until now I've only worked with cross-sectional data. Now I need to wor...
How to interpret the result of the "Total Factor Productivity of Manufacturing Firms" based on Levinsohn and Petrin (2003) approach?

How to interpret the result of the "Total Factor Productivity of Manufacturing Firms" based on Levinsohn and Petrin (2003) approach?

3:17 AM Data Cleaning Data management Data Processing
I intend to measure the TFP of manufacturing firms for 23 firms through Cobb - Douglas Production Function Approach using Prodest code in St...
PMG insufficient observation

PMG insufficient observation

3:12 AM Data Cleaning Data management Data Processing
Hi everyone, I was trying to run panel under PMG effect. N= 36 over the time period 1984-2016. When I run the command for the full panel, ...
Finding code snippets from Stata's base commands

Finding code snippets from Stata's base commands

1:27 AM Data Cleaning Data management Data Processing
Dear Statalist, Is there a way to see the programme code from Stata's own base commands? In my case, I am interested in seeing how t...
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)
    • ►  August (645)
    • ►  July (681)
    • ►  June (654)
    • ▼  May (1034)
      • clogit vs. xtlogit, fe
      • Time lag for Multi_level fixed effect panel data.
      • -sreshape-
      • Lasso regress questions
      • Add Text to Graph Combine
      • Obtaining mean and SD from survey data
      • Showing country-specific treatment effects
      • Standard Error Correction in a two step process
      • WLS regression using regwls and regress
      • Inverted Normal Graph
      • How to do matrix exponential operation in Stata?
      • gsem covstruct
      • Generate balance table
      • extract variable labels for new variable names
      • Count number of cases if dates are within a certai...
      • Multinomial logit with sample selection
      • Manually installing Blindschemes by Daniel Bischof
      • How to declare data with tournament structure as p...
      • Drop ID if different observations for that same ID...
      • Drop ID if different observations for that same ID...
      • Mixed or reg i.country i.year for repeated cross-s...
      • destring numbers in scientific notation
      • Interpretation of the interaction term when the re...
      • categorizing data
      • Droping observations with x amount of missing values
      • Meta analysis of hazard ratio
      • Creating a value that equals the average of other ...
      • Collinearity error when including continuous varia...
      • getting a sample size
      • Cluster Randomized Controlled Trial
      • traj command with hierarchical data structure
      • Dipendent Double-Sorting 25 Portfolios
      • Generate variables with forvals
      • Interaction between variables changes the results ...
      • Weighted least squares (WLS) with wls0 and regwls
      • Which Flavor of ADF Estimation Does Stata Use?
      • fill in empty adjacent cells within a group
      • Test for a unit root using panel data
      • Losing groups while running a regression
      • Latent class analysis categorical variables
      • X11 Forwarding only showing half screen with Stata
      • xtivreg2 - identifying singleton observations
      • Saving WTP estimates to conduct Poe Test
      • Formatting and managing dates, from String to MMYY...
      • Bootstrap
      • Advices on how to learn systematically how to work...
      • How to interpret the result of the "Total Factor P...
      • PMG insufficient observation
      • Finding code snippets from Stata's base commands
      • Graph options
      • Plot log outcome on predicted propensity of Treatment
      • Interpretation of the margins plot with categorica...
      • Generating unique ID variable from numeric and cat...
      • Finite mixture model vs. Latent class model
      • Hosmer–Lemeshow test for large data sets
      • reshape command
      • Using Multiple Imputations in Propensity Score Mat...
      • stata mp 15 computing speed
      • firthlogit: initial vector: matrix must be dimensi...
      • Replace values of a variable depending on a series...
      • Update to -kmatch- available from SSC
      • Estimating Demand Elasticity with Log-Log Model | ...
      • Random-Number Generator Version ##: set seed - dif...
      • Gsem -problems with SEM builder tool
      • Anyway to conduct dynamic model on panel data by u...
      • How to generate a new binary variable based on ind...
      • Power calculations in stata
      • 'xtoverid' after multiple imputation in panel data?
      • ANOVA error r(422); "could not determine between-s...
      • Reshape data wide to long for xtivreg
      • Data transformation from survey ratings to variables
      • Interaction with categorical independent (how to u...
      • ML bivariate discrete time duration. Error 102 too...
      • Filtering a Dataset by a second dataset
      • Scientific Notation default?
      • Calculating the difference between two paired obse...
      • Accessing ado code for svy: total to identify vari...
      • Creating graphs
      • (How) Can I calculate a significance test for Kend...
      • principal factor vs. principal-component factor op...
      • Monthly rolling regressions - recording residuals
      • Represent Table to Line graph
      • Conditional logistic regression
      • Comparing mortality rate over years
      • psmatch2 and pstest
      • Creating variables that sum variables in regularly...
      • Bootstraped mediation with multiple IVs
      • Is a Logarithmic interaction term possible?
      • s a Logarithmic interaction term possible?
      • Dates Conversion
      • how to produce share (%) of list of countries by s...
      • Delete words and rename variables
      • xtgls command
      • Formatting numbers saved in a local and using thes...
      • putpdf "failed to add paragraph" when saving
      • calculating an average across observations which h...
      • How to change local strings
      • Regression help on statistical significance
      • xtprobit random effects negative variance
      • looping over many regressions
    • ►  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