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
replicating an instrumented model in eregress and ivreg2 (or ivregress)

replicating an instrumented model in eregress and ivreg2 (or ivregress)

Wednesday, June 30, 2021 Data Cleaning Data management Data Processing
Hi Stata people, I would like to replicate a model I am using in eregress (Stata 15 and up) with ivreg2 (Baum et al user-written command...
replicating an instrumented model in eregress and ivreg2 (or ivregress)

replicating an instrumented model in eregress and ivreg2 (or ivregress)

10:25 PM Data Cleaning Data management Data Processing
Hi Stata people, I would like to replicate a model I am using in eregress (Stata 15 and up) and ivreg2 (Baum et al user-written command ...
Stata 17 ptrends

Stata 17 ptrends

7:25 PM Data Cleaning Data management Data Processing
Hi, I'm a student working on a diff in diff using Stata 17's new didregress. I used the postestimation command estat ptrends and it ...
How to create a two-axis graph by using coefficient plotting?

How to create a two-axis graph by using coefficient plotting?

5:25 PM Data Cleaning Data management Data Processing
When I run this regression for coefficient plotting purposes Code: reghdfe wNET_PRO_MAR dkt_4 dkt_3 dkt_2 dkt_1 dkt_0 dkt1 dkt2 dkt3 dkt...
Outfile to raw without aproximating values of data

Outfile to raw without aproximating values of data

4:25 PM Data Cleaning Data management Data Processing
Hi, how can I export data into a raw file preserving the original values of large numbers? I am using outfile with "comma wide" ...
How to copy the output table in Stata to excel with the cell-by-cell format?

How to copy the output table in Stata to excel with the cell-by-cell format?

3:25 PM Data Cleaning Data management Data Processing
When running this code, Code: esttab m1 m2 m3 m4 m5 m6,star(* 0.1 ** 0.05 *** 0.01) ar2 title(" dependent variable ") mtitle(...
Neighboring States

Neighboring States

3:25 PM Data Cleaning Data management Data Processing
Hello Statalisters, I am running into a problem with some code. I am writing a policy diffusion paper and need to create a variable that c...
Curiousity about the default symbols of Stata?

Curiousity about the default symbols of Stata?

3:25 PM Data Cleaning Data management Data Processing
Today when I read the esttab command of Stata ( http://repec.org/bocode/e/estout/hlp_esttab.html ), I saw the star options Array I know...
Testing Differences in Pearson's Correlations in Survey Data

Testing Differences in Pearson's Correlations in Survey Data

2:25 PM Data Cleaning Data management Data Processing
Hello everyone: I am trying to compare the correlation among the same two numerical variables (x1 and x2) in two different populations (n1...
Subsetting a single CSV file into multiple CSV files

Subsetting a single CSV file into multiple CSV files

2:25 PM Data Cleaning Data management Data Processing
Hello, I am trying to subset one CSV file into multiple CSV files. I wrote the codes below utilizing preserve and restore, and it's fo...
Lags in Bayesian vars

Lags in Bayesian vars

2:25 PM Data Cleaning Data management Data Processing
I am on state 17 trying to run a Bayesian var.. Does anyone here know how lags are determined in Bayesian vars? I mean, how to find the leng...
Combining tables with identical variables, long format

Combining tables with identical variables, long format

7:25 AM Data Cleaning Data management Data Processing
Hey guys, Is there an easy way how to combine two tables with identical variables in a long format? I know the way to do it in R, but I...
Improving performance of large excel tables with tabout, append - suggestions?

Improving performance of large excel tables with tabout, append - suggestions?

6:25 AM Data Cleaning Data management Data Processing
Dear Statalist, I have been an avid reader of the list for years and it has helped me tremendously in so many situations. I know that peop...
Smith et al (2004) Panel Unit Root Test

Smith et al (2004) Panel Unit Root Test

6:25 AM Data Cleaning Data management Data Processing
Hello everyone, I would like to compare first and second generation unit root test results by applying Smith et al. (2004) (MİN, MAX, WS) ...
Need help generating new variable to capture 18th observation onwards for each data group

Need help generating new variable to capture 18th observation onwards for each data group

6:25 AM Data Cleaning Data management Data Processing
Dear all, I have generated a new variable (Ambtemp2oC_01) to capture temperature readings above two degrees Celsius for different sensors. ...
Tsfill with multiple observations per id & per year

Tsfill with multiple observations per id & per year

5:25 AM Data Cleaning Data management Data Processing
Hi dear statalist, I have an unbalanced panel with gaps in years, with worker level information about occupation (code) and firm for sever...
xtdpdsys and xtabond2 GMM results

xtdpdsys and xtabond2 GMM results

4:25 AM Data Cleaning Data management Data Processing
Dear Stata community, I read a number of posts regarding gmm xtdpdsys and xtabond2 but unfortunately I am not achieving the expected outco...
Repeated cross sections

Repeated cross sections

4:25 AM Data Cleaning Data management Data Processing
Hi everybody, I have a dataset where each year parties (from different countries) running for elections are evaluated and assigned a score ...
ROC curves in Stata

ROC curves in Stata

3:25 AM Data Cleaning Data management Data Processing
Hi guys, I am quite new to the topic. However I constructed the toy-example ROC curve displayed in the figure below. ROC curves determine ...
omitted because of collinearity

omitted because of collinearity

3:25 AM Data Cleaning Data management Data Processing
Dear Stata friends I wanted to run the following regression with fixed effects: Code: reg Arbeitslosenrate_ln avg i.numvar if num<=...
Change in the sign of a variable in a regression output

Change in the sign of a variable in a regression output

2:25 AM Data Cleaning Data management Data Processing
Dear all, I am currently working on a regression. My aim is to assess whether ESG scores affect the cost of bank loans (variable "All...
How to create a dummy variable that tracks the repetition of other variables

How to create a dummy variable that tracks the repetition of other variables

1:25 AM Data Cleaning Data management Data Processing
Hello all, I have a dataset on user ratings of golf courses and I am trying to create a dummy variable called "compared_rating"....
How to flag observations that are repeated after a pre-specified length of time?

How to flag observations that are repeated after a pre-specified length of time?

1:25 AM Data Cleaning Data management Data Processing
Hi, Please consider this example data: Code: * Example generated by -dataex-. To install: ssc install dataex clear input str11 id float...
Using Reshape to sort wide into long

Using Reshape to sort wide into long

Tuesday, June 29, 2021 Data Cleaning Data management Data Processing
Hello Everyone, I want to convert my wide data into a long panel data for currency data. Currently the data looks like : Type Date Aus...
Is adoupdate, update stallig for anyone else? Advice/

Is adoupdate, update stallig for anyone else? Advice/

10:25 PM Data Cleaning Data management Data Processing
For the first time, I'm having trouble with adoupdate, update today. It goes through identifying what needs to be updated just fine, but...
How to Clean String variable with errors in data entry

How to Clean String variable with errors in data entry

10:25 PM Data Cleaning Data management Data Processing
Hi Stata Forum, I am a relatively new user to STATA. I am working on a project that uses data scraped off a website that people have manua...
Using loop to replace values in a variable

Using loop to replace values in a variable

9:25 PM Data Cleaning Data management Data Processing
Dear All, I am new to loop. Is there a way I can replace the missing values with the number 1 each time they are selected in a random sele...
Whether can I do two mean difference tests simultanuously?

Whether can I do two mean difference tests simultanuously?

8:25 PM Data Cleaning Data management Data Processing
Dear Statalists, My dataset has 4 variables A, B, C and D. I would like to test mean difference of A and B simultaneously with mean differ...
Why the variables'name from esttab presentation is different from that of presented table by using esttab

Why the variables'name from esttab presentation is different from that of presented table by using esttab

6:25 PM Data Cleaning Data management Data Processing
My code is as below Code: reghdfe wNET_PRO_MAR pt , a(TYPE2 yr) est sto m1 reghdfe wNET_PRO_MAR pt wFIRM_SIZE LNGDP UNEMPLOYMENT IMP_O...
Generating Variables Acc. to Multiple Conditions And Earliest Occurrence

Generating Variables Acc. to Multiple Conditions And Earliest Occurrence

4:25 PM Data Cleaning Data management Data Processing
I am working with a dataset that contains names, the frequency of a name according to gender, and the year in which this data was recorded. ...
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)
      • replicating an instrumented model in eregress and ...
      • replicating an instrumented model in eregress and ...
      • Stata 17 ptrends
      • How to create a two-axis graph by using coefficien...
      • Outfile to raw without aproximating values of data
      • How to copy the output table in Stata to excel wit...
      • Neighboring States
      • Curiousity about the default symbols of Stata?
      • Testing Differences in Pearson's Correlations in S...
      • Subsetting a single CSV file into multiple CSV files
      • Lags in Bayesian vars
      • Combining tables with identical variables, long fo...
      • Improving performance of large excel tables with t...
      • Smith et al (2004) Panel Unit Root Test
      • Need help generating new variable to capture 18th ...
      • Tsfill with multiple observations per id & per year
      • xtdpdsys and xtabond2 GMM results
      • Repeated cross sections
      • ROC curves in Stata
      • omitted because of collinearity
      • Change in the sign of a variable in a regression o...
      • How to create a dummy variable that tracks the rep...
      • How to flag observations that are repeated after a...
      • Using Reshape to sort wide into long
      • Is adoupdate, update stallig for anyone else? Advice/
      • How to Clean String variable with errors in data e...
      • Using loop to replace values in a variable
      • Whether can I do two mean difference tests simulta...
      • Why the variables'name from esttab presentation is...
      • Generating Variables Acc. to Multiple Conditions A...
      • Distance between observations in different data bases
      • Combining bar graphs from different binary variables
      • Changing variable value across cross-sectional uni...
      • Chi Square Test for Suvery Weighted Data
      • Geometric means - gmci
      • Multiple color forest plot
      • discrete-time survival analysis (xtcloglog) the ou...
      • Creating 5th lags for list of variables in wide range
      • Loop not identifying the local of variable suffixes
      • Welch's F-test as an alternative to Fisher's F.
      • How to combine descriptive statistics and ttest re...
      • twoway histogram gen with 0 frequency
      • dsregress displays undefined error when Estimating...
      • Stata Probit Model Interaction Term Interpretation
      • generalised DID with two-way fixed model
      • Estimation window for multiple events per company
      • Oprobit dependent variables only categorical?
      • Latent Class Model: problem with choosing the numb...
      • categorize a variable if certain words are found i...
      • How to create a identifiers in Stata?
      • How to make a binary outcome variable of 3 other v...
      • Difference-in-Difference with continuous variables...
      • discrete-time survival analysis (xtcloglog)
      • How to count each binary variables and only genera...
      • Double loops in Stata?
      • interaction variable with i. operator
      • Creating a day variable
      • Loop to create new variables
      • output from outreg2.
      • Replacing dummy variable value to one for the foll...
      • 2 way clustering in fixed effects panel data regre...
      • Can I run GMM (and OLS, 2SLS, IV) with very unbala...
      • Loop results creating random groups are not reprod...
      • 28 June, or 6/28: Tau Day 2021
      • Convert numeric to string, and vice verse.
      • Unbalanced Panel Regression technique
      • Italics in part of string variable / y-axis labels
      • Putexcel modfiy dont work as intended
      • Different results for odds ratios: Logit coefficie...
      • Stata not detecting the Latin Modern 'LaTeX' font
      • Create new variables based on condition and other ...
      • tab year, gen(year_dummy)
      • How to count the values of a set of binary variables
      • reshape wide to long
      • Creation of panel of 16 months by linking monthly ...
      • Print excel after calculating Shannon entropy
      • LATE Difference-in-Differences
      • Merging datasets with same variable but different ...
      • Mata find minimum distance across matrices
      • Stata EGI module issue
      • Regression results interpretation
      • Gen event variable for recurrent survival analysis
      • Merging with dates, ignoring missing values.
      • Multilevel regression - problem lrtest and standar...
      • marginal effects after gsem
      • Merging datasets by coordinates of objects and areas
      • Variable in regression model
      • Variable in regression model
      • Bootstrapping panel data using avy prefix
      • How can I test p for trend of Odds ratio of qauart...
      • "Panel must be strongly balanced" in bacondecomp c...
      • Graph coeffcients of a foreach regression
      • tagging different groups when the number of observ...
      • mi xtset errors not correcting
      • First Diffrence and Lag of First Difference Regres...
      • Spatial regression results sensitive to normalizat...
      • Using SMCL in Stata Graphs
      • stata doesn't recognises the values of variables
      • Generating Count of Recurring names in Successive ...
      • Same datapoint across different date formats
    • ►  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)
    • ►  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