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
Find first stage F-stats under xtivreg with factor variables (so no xtoverid)

Find first stage F-stats under xtivreg with factor variables (so no xtoverid)

Tuesday, December 31, 2019 Data Cleaning Data management Data Processing
It seems to be well-documented (here: https://www.statalist.org/forums/for...port-fvvarlist or here: https://www.stata.com/statalist/arch.....
Panel data - Creating a date variable from year and weeknumber as string

Panel data - Creating a date variable from year and weeknumber as string

10:59 AM Data Cleaning Data management Data Processing
Stata listers I am writing with a query relating to panel data for historical prices. I am trying to create a a date variable from an Exce...
Margins: trouble with continuous interactions under simultaneous fixed effects

Margins: trouble with continuous interactions under simultaneous fixed effects

9:59 AM Data Cleaning Data management Data Processing
Sometimes I wish to control for variable X via fixed effects (say, year fixed effects) but also allow the marginal effect of a second variab...
Please help: Importing and merging multiple sheets from an excel file while renaming variables using loops

Please help: Importing and merging multiple sheets from an excel file while renaming variables using loops

6:59 AM Data Cleaning Data management Data Processing
Hello, I am quite new using loops and really want to understand it better. I have an excel file with 11 sheets, I only need a couple sheet...
Panel data regression

Panel data regression

6:29 AM Data Cleaning Data management Data Processing
Hello everyone, I'm writing my thesis and I'm struggling with the processing of my data. First of all, my research question is: ...
Time varying covariate in Cox Regression model

Time varying covariate in Cox Regression model

5:59 AM Data Cleaning Data management Data Processing
Hi all. After a thorough search online I can't seem to find a solution to my problem, which is why I'm now asking the experts I...
Timevar for survival analysis

Timevar for survival analysis

5:59 AM Data Cleaning Data management Data Processing
Dear All, This might be a silly question, but it is driving me crazy. I am managing data which were not recorded for survival analysis a...
how to estimate individual betas of coefficients in a province-sector-year panel data (with 2 sectional identifiers)

how to estimate individual betas of coefficients in a province-sector-year panel data (with 2 sectional identifiers)

4:59 AM Data Cleaning Data management Data Processing
Hello everyone: I'm trying to estimate production functions for a panel data of manufacturing with 2 identifiers (province, sector) so ...
Discriminate analysis using stata

Discriminate analysis using stata

4:29 AM Data Cleaning Data management Data Processing
Hello everyone ; i need to apply 'Discriminate analysis' on stata , how can i apply it and get both the standardized and unstandard...
about synth instruction question

about synth instruction question

3:59 AM Data Cleaning Data management Data Processing
hello great master I have a question My stata version is 14 when I perform the instruction, it always displays the error message what ca...
Split string variable

Split string variable

3:59 AM Data Cleaning Data management Data Processing
Dear Experts, I want to split the string variable. Please advice. The issue is: I have the responses "a" "adc" ...
Removing NA Across var

Removing NA Across var

2:59 AM Data Cleaning Data management Data Processing
I have data in string as shown below data1 data2 NA NA NA NA NA NA NA 8415739 NA 10024002 N 12057882 N 10759322 N 11305650 N 1093...
Generate sum of variables with sequential variables names

Generate sum of variables with sequential variables names

Monday, December 30, 2019 Data Cleaning Data management Data Processing
Hi everyone, I have a data with these sequential variable names. p1_1_1_1 p1_1_1_2 p1_1_1_3 p1_1_1_4 p1_1_2_1 p1_1_2_2 p1_1_2_3 ...
Generate var using sequential variables names

Generate var using sequential variables names

8:59 PM Data Cleaning Data management Data Processing
Hi everyone, p1_1 p1_2 p1_3 p2_1 p2_2 p2_3 p3_1 p3_2 p3_3 1 1 1 2 2 2 3 3 3 1 1 1 2 2 2 3 3 3 1 1 1 2 2 2 3 3 3 1 1 1 2 2 2 3 3 3 1 ...
Identification of Treatment and Control Group

Identification of Treatment and Control Group

6:59 PM Data Cleaning Data management Data Processing
Respected members, I am trying to employ DID as a means of analysis. In my dataset of 287 firms between 2001 and 2016, there was a policy ...
Multilevel Panel Data with CPS Data

Multilevel Panel Data with CPS Data

5:32 PM Data Cleaning Data management Data Processing
Good evening, Using the below Census Population Survey variables, I need to figure out the change in percent Latino for each metarea from ...
Problem with merging multiple csv files using merge 1:1

Problem with merging multiple csv files using merge 1:1

2:02 PM Data Cleaning Data management Data Processing
Hi, I am a beginner in Stata (using Stata 16) and after going through many of the posts regarding merging multiple files from a folder, I ...
Assistance on Statistical analysis

Assistance on Statistical analysis

1:02 PM Data Cleaning Data management Data Processing
Can anyone help me out? I am investigating the coping strategies used among women by using the Brief COPE scale with Likert scale of 4. I wa...
Time stamps in forum software

Time stamps in forum software

1:02 PM Data Cleaning Data management Data Processing
Is there any chance the forum software could be changed to specify time zone in the time stamps? Right now (for me at least) it displays Cen...
Using anymatch in a forvalue loop to detect if each value in v1 matches ANY value in v2

Using anymatch in a forvalue loop to detect if each value in v1 matches ANY value in v2

12:02 PM Data Cleaning Data management Data Processing
I'm struggling to come up with a solution for finding if each observation in variable 1 matches ANY of the specified observations in v2....
standard error of 8280 in multinominal logit

standard error of 8280 in multinominal logit

9:32 AM Data Cleaning Data management Data Processing
Hi, I am analysing my data using multinominal logit. Firstly sorry that I cannot post my data and full results here. Let call dependent ...
Estimating adjusted means and 95% CI using regression stata

Estimating adjusted means and 95% CI using regression stata

8:32 AM Data Cleaning Data management Data Processing
Dear all, Now i am analyzing a repeated measurable longitudinal data. by linear regress model, Y, x, covariates ( age, sex, education, i...
Creating a local list from a variable

Creating a local list from a variable

8:02 AM Data Cleaning Data management Data Processing
I have the following string values for two variables. I would like to create a local list from Var1 and/or Var2. clear input str4 Var1 st...
Running sum of observations by group for last 3 years

Running sum of observations by group for last 3 years

8:02 AM Data Cleaning Data management Data Processing
Dear Statalists, my dataset includes company IDs and patents the companies invented per year. Each line is a patent invented in a certain ...
IV estimation with ordinal endogenous variable and ordinal instrumental variable

IV estimation with ordinal endogenous variable and ordinal instrumental variable

6:32 AM Data Cleaning Data management Data Processing
Hello, everyone. I am actually quite new with Statalist, and just beginning to learn Stata beyond what was taught in our syllabi. I need you...
ttest for time series

ttest for time series

6:02 AM Data Cleaning Data management Data Processing
Hello all, I got monthly data of the standard deviation of my betas (Sd_beta) and three dummy variables P1-P3, which indicate wheter the v...
Delete records with missing valuables

Delete records with missing valuables

5:02 AM Data Cleaning Data management Data Processing
How can I delete all observations that have missing data in any of the variables that I have I have more than 61000 observations with 3809...
Firm fixed effects

Firm fixed effects

5:02 AM Data Cleaning Data management Data Processing
Hi Statalist, I have a question about firm-fixed effects. My regression looks like: Dependent var = independent var + controls My d...
Standardized concentration indices with conindex

Standardized concentration indices with conindex

3:02 AM Data Cleaning Data management Data Processing
Hello everyone, I am trying to modify the conindex user-written program so as it would calculate indirectly standardized concentration ind...
Multi-Logistics Regression on DHS data

Multi-Logistics Regression on DHS data

2:02 AM Data Cleaning Data management Data Processing
Hi All, I am using DHS India data to undertake analysis on the topic related to Child Health. I have completed my analysis but before I pu...
CMP model for multnomial probit with varying choice set

CMP model for multnomial probit with varying choice set

Sunday, December 29, 2019 Data Cleaning Data management Data Processing
Hello, I am looking to build a multinomial probit with a varying choice set for each individual via CMP. The idea is to later add other ch...
Panel Data

Panel Data

6:02 PM Data Cleaning Data management Data Processing
Hi How do I estimate a random effects of individual and time effects in panel data models with stata? (I want the final estimate of the mo...
Resolving "Initial values not feasible" error after using melogit command and the choice between melogit and meqrlogit

Resolving "Initial values not feasible" error after using melogit command and the choice between melogit and meqrlogit

5:32 PM Data Cleaning Data management Data Processing
Dear Statalists, I'm working on a multi-level model using data from cross-countries survey data for the 2016 year. But I am encounteri...
PPML multicolineality

PPML multicolineality

4:32 PM Data Cleaning Data management Data Processing
Hi, I have estimated a model with OLS and PPML. With OLS I obtain R2 = 0.78 estat vif = 1.2 With PPML I obtain R2 = 0.95 Is it mea...
Difference of a variable based on corresponding variables in other columns

Difference of a variable based on corresponding variables in other columns

4:32 PM Data Cleaning Data management Data Processing
Hi, Based on a subset of data pasted below: Code: * Example generated by -dataex-. To install: ssc install dataex clear input double yea...
georoute command and HERE API not working?

georoute command and HERE API not working?

2:02 PM Data Cleaning Data management Data Processing
hello all, I'm having some trouble with the HERE API and the georoute package. I registered for a HERE account and generated both a ja...
Mediation analysis with STATA and control variables?

Mediation analysis with STATA and control variables?

10:02 AM Data Cleaning Data management Data Processing
I've seen a lot of forms to do a mediation analysis, being Baron and Kenny (1986) steps the most popular. However, I see that they do th...
'End Duplicates' error in mata programing

'End Duplicates' error in mata programing

6:32 AM Data Cleaning Data management Data Processing
Hello, everyone. I'm Zhang. I would like to ask you a question about an 'End Duplicates' error in my mata programming. My p...
Testing of adjusted Kaplan-Meier survival

Testing of adjusted Kaplan-Meier survival

6:32 AM Data Cleaning Data management Data Processing
How to test for adjusted kaplan-meier survival analysis ? I am able to create adjusted KM graph but i don't know how to test adjusted K...
Marginsplots for different values of x

Marginsplots for different values of x

5:32 AM Data Cleaning Data management Data Processing
Hello, first post so apologies if something similar has been asked before. I'm investigating the relationship between intergroup ethni...
Generating data according to a pattern

Generating data according to a pattern

4:02 AM Data Cleaning Data management Data Processing
Hello list, I am trying to generate data according to the following pattern: Obs A B C ---------------- 1 0 0 0 2 0 0 1 3 0 1 0 4 0 ...
Comparing two probit models with clustered standard errors

Comparing two probit models with clustered standard errors

3:02 AM Data Cleaning Data management Data Processing
Hey everyone, I would like to compare two probit models (that are nested) to see whether the addition of further variables improves the mo...
Panel Data Analysis: Growth rates or levels?

Panel Data Analysis: Growth rates or levels?

2:02 AM Data Cleaning Data management Data Processing
Hi Statalist-community! I am currently writing a seminar paper. I am estimating the effect of the share of leftwing government members in ...
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)
      • Find first stage F-stats under xtivreg with factor...
      • Panel data - Creating a date variable from year an...
      • Margins: trouble with continuous interactions unde...
      • Please help: Importing and merging multiple sheets...
      • Panel data regression
      • Time varying covariate in Cox Regression model
      • Timevar for survival analysis
      • how to estimate individual betas of coefficients i...
      • Discriminate analysis using stata
      • about synth instruction question
      • Split string variable
      • Removing NA Across var
      • Generate sum of variables with sequential variable...
      • Generate var using sequential variables names
      • Identification of Treatment and Control Group
      • Multilevel Panel Data with CPS Data
      • Problem with merging multiple csv files using merg...
      • Assistance on Statistical analysis
      • Time stamps in forum software
      • Using anymatch in a forvalue loop to detect if eac...
      • standard error of 8280 in multinominal logit
      • Estimating adjusted means and 95% CI using regress...
      • Creating a local list from a variable
      • Running sum of observations by group for last 3 years
      • IV estimation with ordinal endogenous variable and...
      • ttest for time series
      • Delete records with missing valuables
      • Firm fixed effects
      • Standardized concentration indices with conindex
      • Multi-Logistics Regression on DHS data
      • CMP model for multnomial probit with varying choic...
      • Panel Data
      • Resolving "Initial values not feasible" error afte...
      • PPML multicolineality
      • Difference of a variable based on corresponding va...
      • georoute command and HERE API not working?
      • Mediation analysis with STATA and control variables?
      • 'End Duplicates' error in mata programing
      • Testing of adjusted Kaplan-Meier survival
      • Marginsplots for different values of x
      • Generating data according to a pattern
      • Comparing two probit models with clustered standar...
      • Panel Data Analysis: Growth rates or levels?
      • semi-parametric quantile model
      • issue with "svy: biprobit"
      • Append all .dta files in directory
      • Extracting a month/year variable from a date
      • How to keep whole group with a variable including ...
      • Define a binary variable using and / or
      • Can PPML coefficients be analyzed as elasticities?...
      • Plotting a likelihood surface
      • Rename many variables
      • create dummy variable based on condition of other ...
      • Generate sum of preceding values conditional on da...
      • How to omit one category of margins from marginsplot
      • Time-series regression loop (approximately 250 reg...
      • Loops within loops
      • Error r(900) - no room to add variables, up to 204...
      • dummy variable in the two-way fixed effect model
      • traffic accident analyze by logistic regression or...
      • Help with expanding a dataset and merging with a n...
      • Destring a variable
      • GAM download in stata
      • Portfolio analysis, measuring re-occurence and mak...
      • Local holding list of model specifications
      • Correlation between two matrices
      • Splitting sample by dependent variable
      • How to plot multilevel coefficients from mixed ? C...
      • Have any other users of Stata under Windows had pr...
      • graph
      • Weighting
      • -estimates use-, error message when reading stored...
      • Maximum CSV size in Stata SE and what to do about ...
      • Does -xtmixed- use the full data set ?
      • test equality of coefficients from different model...
      • Dealing with multiple or statements
      • "Data in memory have changed" warning
      • collinearity
      • Scatterplot only displaying means
      • Scatterplot only displaying means
      • Interaction terms between a dummy and continuous v...
      • drop/keep with multiple conditional statement
      • Chi-square for subsample
      • Alternative of Cronbach alpha (for single item mea...
      • trend and time
      • generating a new var and replacing its values with...
      • xtabond2 for a dynamic GMM
      • Generate new variable by levelsof
      • Extended Cox model (Cox model with time-varying co...
      • Looping through Import Delimited command using locals
      • ​​​​​Creating a graph with shared areas that cover...
      • How to run conditional indirect difference test wi...
      • How to run conditional indirect difference test in...
      • Plot count data with SE bars on Stata
      • Principal component analysis in panel data setting
      • Performing survival analysis under GSEM
      • How to incorporate exposure variable in Zero Trunc...
      • Forval
      • Creating variables from text
      • More examples with codes on Econometric model fore...
    • ►  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