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
How does Stata plot the probability density function f (x) on the vertical axis and the quantile (0 to 1) on the horizontal axis?

How does Stata plot the probability density function f (x) on the vertical axis and the quantile (0 to 1) on the horizontal axis?

Sunday, February 28, 2021 Data Cleaning Data management Data Processing
How does Stata plot the probability density function f (x) on the vertical axis and the quantile (0 to 1) on the horizontal axis?
Time to event graph

Time to event graph

10:25 PM Data Cleaning Data management Data Processing
Hi, I am really appreciative of all the help that is provided here. Thank you very much. I am trying to build a bar graph with superimposed...
append error (r198)

append error (r198)

9:25 PM Data Cleaning Data management Data Processing
Dear Madam/Sir, I am a beginner for STATA. It will be highly appreciative if you can advise me how to fix this error potentially related t...
synth_runner package

synth_runner package

7:25 PM Data Cleaning Data management Data Processing
Hello, I am working on a comparative case-study using the synthetic control method (traditionally implemented by synth package). However, ...
Convert export values to USD

Convert export values to USD

6:25 PM Data Cleaning Data management Data Processing
Hello, I have a dataset that looks like with trade data from 1988-2017 Code: * Example generated by -dataex-. To install: ssc install d...
description of tsappend1 data set

description of tsappend1 data set

5:25 PM Data Cleaning Data management Data Processing
Hello, Does anybody have a quick description of the tsappend1 data set? Even if it was fictitious i guess it has description of the variable...
How to analyze Panel Survey Data (Likert scale questions)

How to analyze Panel Survey Data (Likert scale questions)

5:25 PM Data Cleaning Data management Data Processing
Hi all, I would like to analyze a two-period survey data with attrition, with both dependent and independent variables being Likert-scale ...
Lexis-diagram

Lexis-diagram

5:25 PM Data Cleaning Data management Data Processing
Lexis I have wondered why there isn't any good Lexis-plot command in Stata? Most of them are very old and do not use new commands stsp...
lincom calculation for a subset of data

lincom calculation for a subset of data

1:25 PM Data Cleaning Data management Data Processing
Hello, I'm trying to calculate the dfiference of certain Times on the basis of a mixed-effect linear regression model. The model outpu...
Function to give year of start

Function to give year of start

12:25 PM Data Cleaning Data management Data Processing
Dear all, I have a dataset with the US census for the 1970-1999 period combined with a dataset with information about different public pol...
Percentile based on age and year using loop

Percentile based on age and year using loop

12:25 PM Data Cleaning Data management Data Processing
Hi all, I have a dataset that includes total income, variable age ranges from 25 to 54, year from 1982 to 2018 and immigrant dummy variabl...
Calculating proportional effects with a GLM model

Calculating proportional effects with a GLM model

11:25 AM Data Cleaning Data management Data Processing
Dear Statalist Members When comparing the output of the margins [eydx] for semielasticity (proportional effects) of a GLM model with log ...
Invalid IVs with Fixed Effects XTIVREG2

Invalid IVs with Fixed Effects XTIVREG2

10:25 AM Data Cleaning Data management Data Processing
Hi, I am currently writing my thesis, using panel data to assess the relationship between financial development and economic growth. I wan...
Set https proxy

Set https proxy

10:25 AM Data Cleaning Data management Data Processing
Hi Statalisters, I have some problems at importing data directly from internet. I am using Stata in my company laptop, and I need to set ...
Sorting the order of bar graph values while using by

Sorting the order of bar graph values while using by

10:25 AM Data Cleaning Data management Data Processing
Hello! I want to order the results of a bar graph in descending order. I have two facets/panels as I want to disaggregate results by gende...
Sequential Treatment Effects

Sequential Treatment Effects

8:25 AM Data Cleaning Data management Data Processing
Hi, I have been struggling for a model to estimate related to sequential treatment effect and need a help desperately. I would greatly ap...
Stata - statistical graphing using "coefplot" by presenting odd ratio with 95%CI

Stata - statistical graphing using "coefplot" by presenting odd ratio with 95%CI

7:25 AM Data Cleaning Data management Data Processing
Dear colleagues, I wish this message find you well. I am wondering how to use "coefplot" by presenting odd ratio with 95%CI? If ...
Durbin Watson d-statistic

Durbin Watson d-statistic

6:25 AM Data Cleaning Data management Data Processing
Hi, I am running a regression with multiple lagged variables of the dependent variable Code: reg CSAD RtnMrktPort AbsRtnMrktPort SquRtnMrk...
Non-linear fixed effects regression

Non-linear fixed effects regression

5:25 AM Data Cleaning Data management Data Processing
Hi all! I am currently working on my University dissertation and would greatly appreciate any help, as I am completely new to Stata and my...
Predict Residuals in SQREG - DO File

Predict Residuals in SQREG - DO File

4:25 AM Data Cleaning Data management Data Processing
Hi there - I am using the following code to predict the residuals for SQREG and want some guidance if this is the right way to predict resid...
Merge 1:1 problem

Merge 1:1 problem

3:25 AM Data Cleaning Data management Data Processing
Hi, I am trying to merge two excel datasets which have unemployment and education data at the US county level (by FIPS code). Both dataset...
Neumark or Oaxaca-Ransom

Neumark or Oaxaca-Ransom

2:25 AM Data Cleaning Data management Data Processing
Quick question regarding decomposition methods and the use of omega with the Oaxaca command. https://core.ac.uk/download/pdf/6442665.pdf ...
Loop and Append .dta files

Loop and Append .dta files

1:25 AM Data Cleaning Data management Data Processing
Hello All, I am trying to import d.ta file and append them, what is wrong with this code? For some reason it only uses the first file from...
graph with many lines

graph with many lines

12:25 AM Data Cleaning Data management Data Processing
Dear All, Suppose that I have the following data Code: * Example generated by -dataex-. To install: ssc install dataex clear input long id...
How to Drop Duplicate ID Observations if There are Multiple Conditions I Want to Apply

How to Drop Duplicate ID Observations if There are Multiple Conditions I Want to Apply

Saturday, February 27, 2021 Data Cleaning Data management Data Processing
Hello Everyone, I hope that you could help me with the below. I have a cross-sectional dataset of 343 observations of students' scor...
Synthetic Control - minimum number of obs?

Synthetic Control - minimum number of obs?

11:25 PM Data Cleaning Data management Data Processing
Can I build a synthetic control with 6 pre-treatment observations and 4 post-treatment? Is it valid, or does it raise questions about suitab...
The intersection of two Chinese variables

The intersection of two Chinese variables

7:25 PM Data Cleaning Data management Data Processing
Dear All, I found this question here (in Chinese). The data set is Code: * Example generated by -dataex-. To install: ssc install dataex c...
Building cross-lagged panel models with categorical variables on Stata

Building cross-lagged panel models with categorical variables on Stata

7:25 PM Data Cleaning Data management Data Processing
Can someone here suggest to me a suitable way to build a cross-lagged panel model with categorical variables on Stata MP 15.1? I built a cro...
Seasonality in annual data? Problem or not?

Seasonality in annual data? Problem or not?

7:25 PM Data Cleaning Data management Data Processing
Hello, I have a panel data at an annual frequency. When I use the xtline command to get the linear plots, my data have obvious fluctuations ...
Ranking the most important predictor variables from a series of regression models.

Ranking the most important predictor variables from a series of regression models.

6:25 PM Data Cleaning Data management Data Processing
Hi, I came across an interesting study that did the following: ' number of births in the last 5 years and the number of household m...
reshape or transpose?

reshape or transpose?

6:25 PM Data Cleaning Data management Data Processing
Dear All, I was asked this question here ( https://bbs.pinggu.org/forum.php?mod...a=#pid74912031 ). The data set is Code: * Example genera...
using forvalues loop and postfile command

using forvalues loop and postfile command

2:25 PM Data Cleaning Data management Data Processing
Dear statalist i have a sample of only 3 observation, i having problem calculating outer product of the gradient , the gradient and updatin...
Differences between dates using panel data

Differences between dates using panel data

1:25 PM Data Cleaning Data management Data Processing
Hi there, I'm working with some panel data, whereby for each subject I have multiple events (lab tests) recorded in long form. Each ev...
Graph with conditioning

Graph with conditioning

1:25 PM Data Cleaning Data management Data Processing
Hi there, I would like to create a graph with two lines one for each condition. This is what I tried: graph twoway (line mean_BARTAdj week...
Continous-Continous Interaction when one of the variables has many zeros.

Continous-Continous Interaction when one of the variables has many zeros.

1:25 PM Data Cleaning Data management Data Processing
Hello, I am interested in measuring how previous purchases from a given platform and time spent on the platform impact the probability of ...
Using returned results in r() with -egen- is not working. Is that a bug?

Using returned results in r() with -egen- is not working. Is that a bug?

11:25 AM Data Cleaning Data management Data Processing
Why is this not working? Code: . sysuse auto, clear (1978 Automobile Data) . summ price Variable | Obs Mean Std. D...
Spearman correlation table export into Excel

Spearman correlation table export into Excel

10:25 AM Data Cleaning Data management Data Processing
Hi everyone, I have a problem trying to export my Spearman correlation results into Excel. I use: matrix A = r(Rho) esttab matrix(A, fm...
Interpretation Interactionterm in fixed effect regression

Interpretation Interactionterm in fixed effect regression

9:25 AM Data Cleaning Data management Data Processing
Dear all , I have performed a fixed effect regression with cluster(id) xreg y i.FFF i.young FFF#young + Controls, fe cluster(id) i use...
xtprobit margin problem

xtprobit margin problem

8:25 AM Data Cleaning Data management Data Processing
Hello to All Stata Users! HTML Code: xtoprobit y x z, vce(cluster id) is the model I run . However when I run the margin commands: HTM...
merging datasets with different dimensions

merging datasets with different dimensions

8:25 AM Data Cleaning Data management Data Processing
Hi all, I would like to merge together 16 datasets which are defined by country and are made as follows: AUS.dta is: var1 Mol1_a a1 Mo...
Impact of an average change on dependent variable over time

Impact of an average change on dependent variable over time

7:25 AM Data Cleaning Data management Data Processing
Hello! For my thesis I wanted to test a hypothesis which requires a model that I wouldn't know how to design myself. For a panel data (1...
Using reghdfe command with if-statements

Using reghdfe command with if-statements

6:25 AM Data Cleaning Data management Data Processing
Hello, bit of a complex one here: I’m currently working as a research assistant, using my supervisor’s code, which uses employee-level dat...
AR(1) is insignificant in difference GMM

AR(1) is insignificant in difference GMM

6:25 AM Data Cleaning Data management Data Processing
Hello ! I am trying to estimate the following model in both difference and system GMM. However, the results change significantly both in t...
doflist command in reghdfe

doflist command in reghdfe

5:25 AM Data Cleaning Data management Data Processing
Hi there, I am currently having issues with collinearity of fixed effects in my 'reghdfe- regression'. I read online that the ...
Using starting values to overcome convergence problem - always getting r(503)

Using starting values to overcome convergence problem - always getting r(503)

4:25 AM Data Cleaning Data management Data Processing
Dear all, I am trying to fix convergence problem of my model using starting values as suggested many times here on statalist. However, I a...
Pooled OLS Firm effect vs Industry Effect

Pooled OLS Firm effect vs Industry Effect

4:25 AM Data Cleaning Data management Data Processing
Hello I have explored this forum for the question of firm vs industry fixed effect. But they always talk about panel regression "xtre...
Quadratic term and concave relationship threshold

Quadratic term and concave relationship threshold

3:25 AM Data Cleaning Data management Data Processing
Hello everyone, I am exploring whether the hypothesis that above a certain threshold financial depth yields negative results for economic ...
Missing values in snapspan command @StephenJenkins

Missing values in snapspan command @StephenJenkins

3:25 AM Data Cleaning Data management Data Processing
Dear Stephen Jenkins, I'm following your Survival Analysis guideline ( https://www.iser.essex.ac.uk/resourc...sis-with-stata ) and An ...
Bar graph with multiple means of variables

Bar graph with multiple means of variables

3:25 AM Data Cleaning Data management Data Processing
Hello! I want to create a bar graph with the means of several variables on the x axis. Any idea how I would do something like that?
dtalink vs reclink2 vs matchit

dtalink vs reclink2 vs matchit

Friday, February 26, 2021 Data Cleaning Data management Data Processing
Hello, I've tried to tag this topic on an older thread, but haven't gotten any responses, so was trying to create a new conversation...
Business calender generates year 1967 dates

Business calender generates year 1967 dates

5:25 PM Data Cleaning Data management Data Processing
Hi Statlisters, I have succesfully loaded my business calender by using the below code, however when i generate my "bdate" varia...
Verification of logic behind IV approach

Verification of logic behind IV approach

4:25 PM Data Cleaning Data management Data Processing
I hope this is not too elementary a post for this forum. However, since I am not sure, I thought I would give it a shot. I would like to k...
Exporting frequency table using esttab

Exporting frequency table using esttab

6:25 AM Data Cleaning Data management Data Processing
Hi, I am trying to export the frequency table using esttab command. My observations are in the decimal point. When I use the following comma...
Encountering error r(198) while running a loop in stata

Encountering error r(198) while running a loop in stata

5:25 AM Data Cleaning Data management Data Processing
HI, I am encountering error while running a loop in stata. The following is my code HTML Code: forvalues i = 1/`MaxLPLags' { fo...
Kaplan Meier, Multi-survival analysis on one graph

Kaplan Meier, Multi-survival analysis on one graph

5:25 AM Data Cleaning Data management Data Processing
Hello, I am able to graph my trade spell duration survival over a 30year period using the Code: sts graph if export_CAD <=100000 to ...
Which method does xtlogit/clogit use to estimate a fixed effects model (i.e. mean difference/first difference/LSDV)?

Which method does xtlogit/clogit use to estimate a fixed effects model (i.e. mean difference/first difference/LSDV)?

4:25 AM Data Cleaning Data management Data Processing
In Asymmetric Fixed-effects Models for Panel Data (available here open access: https://journals.sagepub.com/doi/10....78023119826441 ) Paul ...
Making tables from data

Making tables from data

4:25 AM Data Cleaning Data management Data Processing
Hi, I've district-level migration data of India. Say- State no district no migration type 1 (percentage share) 1 1 39.7 ...
Missing values in Stata

Missing values in Stata

3:25 AM Data Cleaning Data management Data Processing
I am creating my own data set for my thesis, and have run into a problem with missing values. I am creating the data set in Excel, and i cod...
Interpretation of AMEs: CIs overlapping each other but not zero, can I conclude that there is an interaction?

Interpretation of AMEs: CIs overlapping each other but not zero, can I conclude that there is an interaction?

2:25 AM Data Cleaning Data management Data Processing
Hi all, I'm fitting a simple OLS-model including an interaction term. To interpret the interaction I compute AMEs: Code: reg ITL O...
Strange macro behaviour

Strange macro behaviour

2:25 AM Data Cleaning Data management Data Processing
Hi guys, I am trying, with the following loop to drop some of my observations, specifically the ones that have quarters below the molecule...
F-keys in profile.do

F-keys in profile.do

2:25 AM Data Cleaning Data management Data Processing
Dear all, I am generating my file profile.do: Code: /*=========================================================================== pro...
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)
      • How does Stata plot the probability density functi...
      • Time to event graph
      • append error (r198)
      • synth_runner package
      • Convert export values to USD
      • description of tsappend1 data set
      • How to analyze Panel Survey Data (Likert scale que...
      • Lexis-diagram
      • lincom calculation for a subset of data
      • Function to give year of start
      • Percentile based on age and year using loop
      • Calculating proportional effects with a GLM model
      • Invalid IVs with Fixed Effects XTIVREG2
      • Set https proxy
      • Sorting the order of bar graph values while using by
      • Sequential Treatment Effects
      • Stata - statistical graphing using "coefplot" by p...
      • Durbin Watson d-statistic
      • Non-linear fixed effects regression
      • Predict Residuals in SQREG - DO File
      • Merge 1:1 problem
      • Neumark or Oaxaca-Ransom
      • Loop and Append .dta files
      • graph with many lines
      • How to Drop Duplicate ID Observations if There are...
      • Synthetic Control - minimum number of obs?
      • The intersection of two Chinese variables
      • Building cross-lagged panel models with categorica...
      • Seasonality in annual data? Problem or not?
      • Ranking the most important predictor variables fro...
      • reshape or transpose?
      • using forvalues loop and postfile command
      • Differences between dates using panel data
      • Graph with conditioning
      • Continous-Continous Interaction when one of the va...
      • Using returned results in r() with -egen- is not w...
      • Spearman correlation table export into Excel
      • Interpretation Interactionterm in fixed effect reg...
      • xtprobit margin problem
      • merging datasets with different dimensions
      • Impact of an average change on dependent variable ...
      • Using reghdfe command with if-statements
      • AR(1) is insignificant in difference GMM
      • doflist command in reghdfe
      • Using starting values to overcome convergence prob...
      • Pooled OLS Firm effect vs Industry Effect
      • Quadratic term and concave relationship threshold
      • Missing values in snapspan command @StephenJenkins
      • Bar graph with multiple means of variables
      • dtalink vs reclink2 vs matchit
      • Business calender generates year 1967 dates
      • Verification of logic behind IV approach
      • Exporting frequency table using esttab
      • Encountering error r(198) while running a loop in ...
      • Kaplan Meier, Multi-survival analysis on one graph
      • Which method does xtlogit/clogit use to estimate a...
      • Making tables from data
      • Missing values in Stata
      • Interpretation of AMEs: CIs overlapping each other...
      • Strange macro behaviour
      • F-keys in profile.do
      • Export DTA file to sas7bdat file?
      • GMM Continuously Updating Estimator - convergence ...
      • Loop over different dependent and independent vari...
      • Adding symbol prefix to formatted table cell
      • Import 'dd.mm.yy' format date to Stata
      • Import Matlab dataset to Stata
      • Display Median for Paired t test
      • graph like this?
      • Does the drive Stata is installed on matter?
      • Regression with Weight
      • Create another observation type as an average of o...
      • Matwrite installed but unrecognized command
      • foreach with if condition
      • Defining Program Stata Help
      • Counting every pair combination on a dataset
      • Coefplot: Displaying each level of a factor variab...
      • Is there a way to use panel data rolling regressio...
      • xtlogit and excluding ineligible participants
      • Obtain same results with regress and rifhdreg
      • Dropping every ID when respondent go from "work" t...
      • how to categorize into categorical variables based...
      • Control time effects for quarterly data
      • Checking residuals and heteroskedasticity
      • Panel data mixed logit model
      • reshape wide to long, no existing j variable
      • new on SSC: mkproject create a new project folder ...
      • Oaxaca-RIF decomposition
      • RDD: multiscore to geographical setting- rdmulti
      • Industry fixed effects with the inrange command
      • xtpmg, mg or dfe maximum number of iterations exce...
      • legend position
      • Appending text files
      • Results from a loop with quarterly and weekly data...
      • how to use bysort with function total and tab
      • GMM estimation: when one of dependent variables mi...
      • Plotting Different Regression Values in One Graph ...
      • Comparing string values within the same variable
      • Weak instrument test for RE estimation
      • Difference in Difference Model: Refine the definit...
    • ►  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)
    • ►  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