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
Exporting Stata Graph

Exporting Stata Graph

Saturday, October 31, 2020 Data Cleaning Data management Data Processing
I sent Stata graph as tiff to the editors of a journal but the insist they would like them in a Microsft word formattable version. Does anyo...
How to calculate birth year effects?

How to calculate birth year effects?

7:25 PM Data Cleaning Data management Data Processing
Dear friends, I hope to calculate the birthyear effects. My code is similar as below, Code: reg income i.birthyear i.cohort, noconst ...
Convert Data in Matrix Form to Long Format

Convert Data in Matrix Form to Long Format

7:25 PM Data Cleaning Data management Data Processing
Hello every one, I have data in matrix form, where there are several rows that should ideally be independent columns. For example, I have ...
store coefficients from different data set

store coefficients from different data set

7:25 PM Data Cleaning Data management Data Processing
Hi Statalist, Could anyone help me, please? I want to do a plot with coefficients from regressions from different data set. For example, i...
[Panel Data] How can I study the way a variable in the past affected the drop in a different variable in the future.

[Panel Data] How can I study the way a variable in the past affected the drop in a different variable in the future.

7:25 PM Data Cleaning Data management Data Processing
All the values that I have for the variable bondratio (amount of company debt that is in the form of bonds) are for the years 2017-2019, but...
r(608) error in loop

r(608) error in loop

5:25 PM Data Cleaning Data management Data Processing
Hi! I'm trying to create groups in my data: for every year and district I create a group that includes everyone 2.5 years more or less...
Importing/Reformatting Data by ID

Importing/Reformatting Data by ID

5:25 PM Data Cleaning Data management Data Processing
Hi Everyone, I'm trying to merge about a dozen different lists that use the same ID scheme but are missing different subsets of entrie...
Comparing IV Coefficients for Two Groups

Comparing IV Coefficients for Two Groups

1:25 PM Data Cleaning Data management Data Processing
Hi, I am trying to determine whether there is a statistically significant difference between a single IV estimate computed for two separate...
how to custom plot axis with different scaling?

how to custom plot axis with different scaling?

12:25 PM Data Cleaning Data management Data Processing
Is there any option with Stata that can achieve the same goal as this in R: labels = function(y) {paste0(y/1000000,'million')}? Ba...
Stata is turning out results very slowly. What can i do?

Stata is turning out results very slowly. What can i do?

12:25 PM Data Cleaning Data management Data Processing
I have a dataset comprising about 30 million observations. When i try to execute even basic commands like save or use stata takes a lot of t...
Using the foreach-command to find a spesific part among hundreds of observations in a string variable.

Using the foreach-command to find a spesific part among hundreds of observations in a string variable.

12:25 PM Data Cleaning Data management Data Processing
Dear members of Statalist, I am fairly new to Stata and I have been struggling with an issue I believe is related to the "foreach...
How to draw a smaller sample from a larger dataset with different mean/ distribution than that of larger/ parent dataset?

How to draw a smaller sample from a larger dataset with different mean/ distribution than that of larger/ parent dataset?

12:25 PM Data Cleaning Data management Data Processing
Hello, I want to draw a ssample (with certain mean/ distribution) from a larger dataset that has different mean/ distribution. For example...
Problems of setting intial values in sem

Problems of setting intial values in sem

11:25 AM Data Cleaning Data management Data Processing
Dear all, I am running a sem on the following data. My command is sem trust->std_retweet std_favorite std_quote,latent(trust) nocapsl...
Removing specific observations

Removing specific observations

11:25 AM Data Cleaning Data management Data Processing
Hello everyone, Based on my title post it seems the question is repeated but no it’s different. my question is: I have dataset file consi...
I need to transpose every row of data, not including the first column, into each corresponding value of the first column.

I need to transpose every row of data, not including the first column, into each corresponding value of the first column.

11:25 AM Data Cleaning Data management Data Processing
Here is an example of my data: Code: * Example generated by -dataex-. To install: ssc install dataex clear input str15 Equity double(B C...
I use qreg, then margins, then mplotoffset: how do I change the spacing for my y-axis?

I use qreg, then margins, then mplotoffset: how do I change the spacing for my y-axis?

11:25 AM Data Cleaning Data management Data Processing
Hi Stata community, I want to change the spacing for my y-axis. Currently I have 0.5 cm between one outcome value of y and another outcome...
Probit Question

Probit Question

9:25 AM Data Cleaning Data management Data Processing
Hi all, If I have a panel of people from ages 25-30, who I may observe more than once in these ages, and I want to look at an independent ...
Stata tables to word format by writing matrix command

Stata tables to word format by writing matrix command

8:25 AM Data Cleaning Data management Data Processing
Hi. I am using a dataset that has 3 years. I am using the command tabulate to do analysis. So I am writing, say, tabulate work_availability...
Custom STS graph axis with spacing

Custom STS graph axis with spacing

8:25 AM Data Cleaning Data management Data Processing
Hi, This is my first post on STATALIST I am trying to create a custom y axis scale using Sts graph for a Kaplein Meir. Essentially on ...
RDRobust Question

RDRobust Question

8:25 AM Data Cleaning Data management Data Processing
Hi all, I am trying to use a fuzzy regression discontinuity strategy in some data work of mine. I have a binary dependent variable that ta...
Table from string and numeric variables

Table from string and numeric variables

7:25 AM Data Cleaning Data management Data Processing
Hello, this is a general question about the best approach. I am using stata 16.1 I want to make a table from one string variable and seve...
Is there a command for Black Scholes model for American options?

Is there a command for Black Scholes model for American options?

5:25 AM Data Cleaning Data management Data Processing
I realise there is Code: bsopm for European Option, but I wonder, is there a command for American dividend-paying option?
Cox-regression:proportional hazard test by Schoenfeld residuals

Cox-regression:proportional hazard test by Schoenfeld residuals

4:25 AM Data Cleaning Data management Data Processing
Hi! I have performed cox-regression on a data set with both continuous and categorical variables. In the cox-regr. command I specified cate...
Create new variable with sums of occurrences

Create new variable with sums of occurrences

1:25 AM Data Cleaning Data management Data Processing
Hi Statalist Community It is my first post here and I hope it is not a question that is too trivial. Unfortunately I have not found any ol...
Adjustments to Esttab Code to Suppress Superfluous Statistics and Display Labels

Adjustments to Esttab Code to Suppress Superfluous Statistics and Display Labels

12:25 AM Data Cleaning Data management Data Processing
Hello --- I'm hoping to get some assistance adjusting my esttab code (pasted at bottom) to make the following adjustments to my regressi...
Problems converting string variable to date/time format

Problems converting string variable to date/time format

Friday, October 30, 2020 Data Cleaning Data management Data Processing
Hi, I have a date/time variable that is a string and looks as follows: hh.mm.ss DD.MM.YYYY. I'd like to convert this variable to time...
Convert 1K to 1000 and 1M to 1000000

Convert 1K to 1000 and 1M to 1000000

9:25 PM Data Cleaning Data management Data Processing
Hello everyone, I need help with converting a particular variable to numbers. The variable in question is the amount of damage done by diffe...
Mixed logit and ordered outcome models (help please)

Mixed logit and ordered outcome models (help please)

7:25 PM Data Cleaning Data management Data Processing
Good evening. My name is Sean and I am a current graduate student, in an advanced econometrics class. I am having trouble with formatting my...
Syntax to know the menu path of the commands that we use in the do file

Syntax to know the menu path of the commands that we use in the do file

6:25 PM Data Cleaning Data management Data Processing
Good night I would like to know if there is a syntax to know the menu path of the commands that we use in the do file Thank You
Combining observations with the same year and id in a single dataset

Combining observations with the same year and id in a single dataset

5:25 PM Data Cleaning Data management Data Processing
I have some data that looks like this: no. id year var1 var2 var3 1 1 2000 50 . . 2 1 2000 . . 10 3 2 2001 . ...
generating variables with "or"

generating variables with "or"

3:25 PM Data Cleaning Data management Data Processing
Hi, I wish to create a new variable given certain parameters of 3 other variables. I have tried the basic creation of a new variable comman...
Histogram with density of 15??

Histogram with density of 15??

3:25 PM Data Cleaning Data management Data Processing
Hi everyone, I would like to know if I'm doing something wrong. I am running almost 200 regressions basically and collecting the coe...
First Differencing Error

First Differencing Error

2:25 PM Data Cleaning Data management Data Processing
Hi there, I'm trying to first difference my variable on industrial production, but all I get are missing values. What am I doing wrong...
Help regarding creating variables for line + bar graph.

Help regarding creating variables for line + bar graph.

1:25 PM Data Cleaning Data management Data Processing
HI, I know that this has been discussed earlier in numerous fora, but, somehow I am unable to figure out if a) this is right and b) is the...
Standarization

Standarization

1:25 PM Data Cleaning Data management Data Processing
Hello everyone. I have this dataset that looks like this. I want to create a variable that standarizes the variable "promp08" usin...
Extracting matrix rownames for svy mean with multiple groups

Extracting matrix rownames for svy mean with multiple groups

1:25 PM Data Cleaning Data management Data Processing
Hi everyone! I’m trying to estimate the difference in blood pressure between hypertensive and non-hypertensive individuals using a complex...
Margins after anova

Margins after anova

1:25 PM Data Cleaning Data management Data Processing
I am requesting marginal means after running anova on StataSE 14, and am wondering why I am getting different values from the seemingly sim...
Import file with .file file extension

Import file with .file file extension

12:25 PM Data Cleaning Data management Data Processing
Hello, I am trying to import data with a .file file extension and can't seem to figure out how. If it helps, I am trying to import the...
Heteroscedasticity test for large panel dataset using XSMLE

Heteroscedasticity test for large panel dataset using XSMLE

11:25 AM Data Cleaning Data management Data Processing
Does XSMLE package have any command to check the Heteroscedasticity for large panel data set? My matrix size 2952 * 2952 which is too large ...
loops

loops

10:25 AM Data Cleaning Data management Data Processing
hello, As part of a Monte Carlo study I have the following population regression model: Y= 262 -0.006X2-2.4X3+u I was told to assume t...
margins- marginal effect of time-variant variables in mixed effects models

margins- marginal effect of time-variant variables in mixed effects models

9:25 AM Data Cleaning Data management Data Processing
Dear Statalist users, I am using Stata 14 SE, and have a question about using margins for a time-variant variable in a mixed-effects model....
how to calculate marginal effect?

how to calculate marginal effect?

9:25 AM Data Cleaning Data management Data Processing
Hi there, Need some help calculating marginal effect. Variable Description sid Subject ID age Age famsze Size of the family...
Calculating percentiles in STATA

Calculating percentiles in STATA

8:25 AM Data Cleaning Data management Data Processing
Hi, I am using the following loop to get the 0.5%, 1%, 2%, 5%, 95%, 98%, 99% and 99.5% percentiles for the variable "Return". Howe...
using DHS DATA SET for cluster fixed effect

using DHS DATA SET for cluster fixed effect

6:25 AM Data Cleaning Data management Data Processing
Hello every one, Please I am new in stata, I am trying to construct a cross sectional data set from a survey stata file and climate recor...
estat vce, corr and vif

estat vce, corr and vif

5:25 AM Data Cleaning Data management Data Processing
I apologise in advance if this has been posted before. Though I couldn't seem to find a discussion when I searched the forum. I am usin...
After splitting a variable that had options seperated by commas, how to find out which is the highest and the lowest frequency of values?

After splitting a variable that had options seperated by commas, how to find out which is the highest and the lowest frequency of values?

4:25 AM Data Cleaning Data management Data Processing
My data looks like this fruit_variable has values 1. Mango 2. Mango, pineapple 3. Mango, grapes 4. Banana, grapes, chickoo 5. strawbe...
Renaming variables using the 'foreach' command

Renaming variables using the 'foreach' command

3:25 AM Data Cleaning Data management Data Processing
I am trying to rename multiple variables corresponding to baseline characteristics, endline characteristics and endline2 characertistics int...
Poisson-CRE and over identification test

Poisson-CRE and over identification test

3:25 AM Data Cleaning Data management Data Processing
Hi all, I am trying to perform an over identification test on the following theoretic scenario. Say that I have a balanced panel where N =...
xtivreg2: interacting two instumented variables (gmm)

xtivreg2: interacting two instumented variables (gmm)

2:25 AM Data Cleaning Data management Data Processing
Hello, my baseline model is the following: Code: xtivreg2 y l.y $controls trend (x1= z1 z2),fe gmm robust bw(1) // Where x1 is my vari...
Control Function Approach and looking for a method to do robustness check of fixed effect

Control Function Approach and looking for a method to do robustness check of fixed effect

1:25 AM Data Cleaning Data management Data Processing
I'm applying the control function (CF) approach in a nonlinear model using a panel dataset of five waves (wave 1 - 5). I have run a fixe...
How will I be able to have a count of certain string variable when using collapse command ??

How will I be able to have a count of certain string variable when using collapse command ??

Thursday, October 29, 2020 Data Cleaning Data management Data Processing
This is how my data looks like..... Student Name SchoolName Location NScore EScore MScore A X 5 1 2 1 B X 5 1 2 2 ...
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)
      • Exporting Stata Graph
      • How to calculate birth year effects?
      • Convert Data in Matrix Form to Long Format
      • store coefficients from different data set
      • [Panel Data] How can I study the way a variable in...
      • r(608) error in loop
      • Importing/Reformatting Data by ID
      • Comparing IV Coefficients for Two Groups
      • how to custom plot axis with different scaling?
      • Stata is turning out results very slowly. What can...
      • Using the foreach-command to find a spesific part ...
      • How to draw a smaller sample from a larger dataset...
      • Problems of setting intial values in sem
      • Removing specific observations
      • I need to transpose every row of data, not includi...
      • I use qreg, then margins, then mplotoffset: how do...
      • Probit Question
      • Stata tables to word format by writing matrix command
      • Custom STS graph axis with spacing
      • RDRobust Question
      • Table from string and numeric variables
      • Is there a command for Black Scholes model for Ame...
      • Cox-regression:proportional hazard test by Schoenf...
      • Create new variable with sums of occurrences
      • Adjustments to Esttab Code to Suppress Superfluous...
      • Problems converting string variable to date/time f...
      • Convert 1K to 1000 and 1M to 1000000
      • Mixed logit and ordered outcome models (help please)
      • Syntax to know the menu path of the commands that ...
      • Combining observations with the same year and id i...
      • generating variables with "or"
      • Histogram with density of 15??
      • First Differencing Error
      • Help regarding creating variables for line + bar g...
      • Standarization
      • Extracting matrix rownames for svy mean with multi...
      • Margins after anova
      • Import file with .file file extension
      • Heteroscedasticity test for large panel dataset us...
      • loops
      • margins- marginal effect of time-variant variables...
      • how to calculate marginal effect?
      • Calculating percentiles in STATA
      • using DHS DATA SET for cluster fixed effect
      • estat vce, corr and vif
      • After splitting a variable that had options sepera...
      • Renaming variables using the 'foreach' command
      • Poisson-CRE and over identification test
      • xtivreg2: interacting two instumented variables (gmm)
      • Control Function Approach and looking for a method...
      • How will I be able to have a count of certain stri...
      • Calculating the percentage changes with longitudin...
      • Least Square Method for parametric survival curve ...
      • Issues with the dependent variable being too commo...
      • VAR models on raw or filtered/smoothed data?
      • You can now play Oregon Trail on Stata
      • Marginsplot with two regression equations
      • Xtabond postestimation - export results to Excel
      • option lc() not allowed \ option lcolor() not allowed
      • Help! Unexpected impact of controlling an omitted ...
      • generating variable with logical operators
      • Problem with a dummy
      • Dropping group with missing waves for panel data
      • Macros with strings and ampersands
      • Tempfile
      • Comparing Means Between Two Groups
      • predict fit, xb
      • Error: Master Data not sorted by applying -glmdose-
      • Rename variable in tab
      • Identifying ICD-codes in 30 different variables
      • Chow test
      • Invalid Syntax when calling for local variable
      • Looking for a way to save sums and load into a tab...
      • Hypothesis Test on Goodman-Kruskal Gamma Statistic
      • Tabulate With Weights In Stata
      • Fuzzy match across multiple variables within a dat...
      • Creating a graph with counts of IDs using 2 differ...
      • For loop
      • Postdoctoral Employment opportunity
      • Sum of squared deviation
      • nested loops
      • Creating loop on date variable
      • Generating new variable using hospital codes of mu...
      • computing skewness and kurtosis of a binary variab...
      • Problem with highly skewed independent variables a...
      • Excluding samples
      • Problems Stating a simultaneous GMM 3sls Model usi...
      • Merging two datasets
      • how can I obtain survival ratio?
      • Reshaping data to SUR form
      • Identify All Values in One Variable that Satisfies...
      • Interpreting psgraph ftaer psmatch2
      • How do I replace a certain value across a dataset ...
      • Saving file name as local value
      • besoin d'aide pour l'interprétation de résultats i...
      • Convert clock data type to daily
      • Calculating difference in differences, percentages...
      • Finding the number of firms for which a given work...
      • Count dates within previous 31 day range for each ...
      • Confidence Intervals / Errr plots with binscatter
    • ►  September (654)
    • ►  August (660)
    • ►  July (682)
    • ►  June (683)
    • ►  May (708)
    • ►  April (692)
    • ►  March (698)
    • ►  February (638)
    • ►  January (631)
  • ►  2019 (9458)
    • ►  December (601)
    • ►  November (643)
    • ►  October (650)
    • ►  September (637)
    • ►  August (645)
    • ►  July (681)
    • ►  June (654)
    • ►  May (1034)
    • ►  April (1079)
    • ►  March (1122)
    • ►  February (876)
    • ►  January (836)
  • ►  2018 (931)
    • ►  December (692)
    • ►  November (239)

© BJ Data Tech Solution | Theme by Rifki.id | Premium Blogger Templates | PBT | Powered by Blogger |-| About | Privacy Policy | Sitemap | Contact | Disclaimer