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
Bootstrapping in parallel

Bootstrapping in parallel

Monday, January 31, 2022 Data Cleaning Data management Data Processing
Using Stata, is there any convenient way to bootstrap in parallel? Although Stata/MP does some things in parallel, it seems it still bootstr...
Syntax Question

Syntax Question

6:23 PM Data Cleaning Data management Data Processing
Dear all, I have the following data merged (industry level data and trade at the industry level at the same level of disaggregation). I wa...
Repeated time values within panel when trying to create new variable

Repeated time values within panel when trying to create new variable

6:23 PM Data Cleaning Data management Data Processing
Hi, I am trying to create a variable called "fempstat" which measures an individual's employment status in the next month. I h...
Date format using month and year

Date format using month and year

5:23 PM Data Cleaning Data management Data Processing
Hi, I am trying to make a new variable called "date" using the month and year in my dataset. The variable "month" is a b...
Generalized Leontief variable cost function

Generalized Leontief variable cost function

3:23 PM Data Cleaning Data management Data Processing
Dear All, I am having difficulty to estimate in Stata a generalized Leontief variable cost function with 3 variable inputs and 4 quasi-fix...
Plotting heterogenous (interaction) effect in event study plot

Plotting heterogenous (interaction) effect in event study plot

3:23 PM Data Cleaning Data management Data Processing
I have the following dataset, Code: * Example generated by -dataex-. For more info, type help dataex clear input float(id monthly indepe...
nonest outside xtreg

nonest outside xtreg

2:23 PM Data Cleaning Data management Data Processing
The -xtreg- command has an undocumented -nonest- option which permits the use of cluster() when the cluster variable is not nested within th...
FRAPPLY: module to nondestructively apply command(s) to a frame

FRAPPLY: module to nondestructively apply command(s) to a frame

6:24 AM Data Cleaning Data management Data Processing
Dear Statalisters, Thanks to Kit Baum, a new command frapply is now available in SSC. Beginning with version 16, Stata can hold multipl...
Stata not directing to correct PDF section after -help topic-

Stata not directing to correct PDF section after -help topic-

4:23 AM Data Cleaning Data management Data Processing
Hello everyone, Anyone having trouble in accessing the *.pdf manuals from Stata after the -help topic- command? For example. After my comm...
First Stage Regression - Huge F-statistic

First Stage Regression - Huge F-statistic

3:23 AM Data Cleaning Data management Data Processing
Hello all, I use a stacked first differences model to estimate the impact of globalization on unemployment in Western Europe. • Panel da...
Including breakpoint dates in SVAR command

Including breakpoint dates in SVAR command

3:23 AM Data Cleaning Data management Data Processing
Dear Stata users, I would like to know how to specify the code for a SVAR model in a such way that includes breakpoint equations or time d...
Combining categories

Combining categories

3:23 AM Data Cleaning Data management Data Processing
I would like to combine two categories for one of my variables but I am not sure whether there is a test I could run to justify combining th...
issues with global macro windows code on mac

issues with global macro windows code on mac

Sunday, January 30, 2022 Data Cleaning Data management Data Processing
I am trying to use a Master do file that someone has sent me from their windows computer. I have a Mac and the project that was sent to me w...
Error: cannot compute an improvement -- discontinuous region encountered

Error: cannot compute an improvement -- discontinuous region encountered

2:24 PM Data Cleaning Data management Data Processing
Good night, I am trying to perform a probit ordered model with panel data and the following error appears: cannot compute an improvement -...
Survival analysis - data management query

Survival analysis - data management query

Saturday, January 29, 2022 Data Cleaning Data management Data Processing
Dear all, I have two variables in my dataset namely "date of birth" "date of death" and would like to do survival anal...
Stock volatility

Stock volatility

4:23 PM Data Cleaning Data management Data Processing
Hi, I need to calculate stock volatility using CRSP daily stock returns. According to the article, it is calculated using the square root ...
Regression with Interaction Terms and Post-Estimation Interpretation

Regression with Interaction Terms and Post-Estimation Interpretation

3:23 PM Data Cleaning Data management Data Processing
Dear Statalist community, I am running the following code to initially generate a regression output: Code: xtreg y c.a##c.b $controlvar...
Splitting An Instance into two existing attributes

Splitting An Instance into two existing attributes

2:23 PM Data Cleaning Data management Data Processing
I have a dataset that includes two variables called "NAME" and "TITLE". NAME should simply be an individual's birt...
Specific period Buy and Hold returns for every day

Specific period Buy and Hold returns for every day

1:23 PM Data Cleaning Data management Data Processing
Hello everyone, I have daily panel data with prices and returns for several companies. My question is, how do I calculate Buy and Hold re...
Getting regression results for my last dummy

Getting regression results for my last dummy

Friday, January 28, 2022 Data Cleaning Data management Data Processing
Hello everyone, I have 3 dummy variables where I have created 2 variables one is called low_dev and the other one is called high_dev. Now ...
regression coefficient calculation not correct

regression coefficient calculation not correct

4:23 PM Data Cleaning Data management Data Processing
Hello everyone, My coefficient for my Construction costs index is too high I have correct construction costs index by dividing it by the c...
Latitude and Longitude to perform geonear and the case of 90 to -90

Latitude and Longitude to perform geonear and the case of 90 to -90

3:23 PM Data Cleaning Data management Data Processing
To perform geo near, we require latitude and longitude. For this do we use the coordinates information from the shapefile or create the cent...
(ssc) esttab and stcrreg: option equations() invalid

(ssc) esttab and stcrreg: option equations() invalid

2:23 PM Data Cleaning Data management Data Processing
For some reason esttab (an ssc package) will not let me combine these two outputs: Code: . stcrreg contrib vx1adultHazRtHat, compete(dos...
lazy man's research

lazy man's research

1:23 PM Data Cleaning Data management Data Processing
I have some info culled from international registries of non-US rehab medicine clinical trials one of the questions of interest is whether...
spmap polygon sepearate graphs

spmap polygon sepearate graphs

Thursday, January 27, 2022 Data Cleaning Data management Data Processing
Dear all, I'm trying to overlay EU NUTS2 and NUTS3 using spmap, but the polygon option doesn't combine two graphs and is seperating...
Obtain which bin and corresponding density each observation in plotted histogram belongs to?

Obtain which bin and corresponding density each observation in plotted histogram belongs to?

5:23 PM Data Cleaning Data management Data Processing
Hello everyone, Suppose I plot a histogram: Code: clear set obs 10 g z = _n replace z = 5 if _n > 5 hist z Given the plotted his...
Same date or within 7 days, within two variables

Same date or within 7 days, within two variables

5:23 PM Data Cleaning Data management Data Processing
Dear statalist-members, I need to identify patients that got med1 and med2 on the same day, or within 7 days. I made a variable that identi...
Simple percentiles using wide dataset

Simple percentiles using wide dataset

4:23 PM Data Cleaning Data management Data Processing
Hello, I'm not sure why I am having such trouble creating a variable corresponding to percentiles. I have a dataset that looks like th...
Checking Duplications

Checking Duplications

3:23 PM Data Cleaning Data management Data Processing
I am trying to use xtset and I know how to remove any duplications. Is there a way to see if the non-id/time variables also repeat in value?...
Matching several observations via new variable

Matching several observations via new variable

2:23 PM Data Cleaning Data management Data Processing
Hello everyone, Currently I'm working with a dataset that contains several waves with various ID's (mothers) and their correspondi...
Getting the repeated-measures bse() error (again)

Getting the repeated-measures bse() error (again)

Wednesday, January 26, 2022 Data Cleaning Data management Data Processing
Hello, I'm new to the list so apologies for posting a basic question. Until the latest update of STATA, I've been able to figure o...
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)
      • Bootstrapping in parallel
      • Syntax Question
      • Repeated time values within panel when trying to c...
      • Date format using month and year
      • Generalized Leontief variable cost function
      • Plotting heterogenous (interaction) effect in even...
      • nonest outside xtreg
      • FRAPPLY: module to nondestructively apply command(...
      • Stata not directing to correct PDF section after -...
      • First Stage Regression - Huge F-statistic
      • Including breakpoint dates in SVAR command
      • Combining categories
      • issues with global macro windows code on mac
      • Error: cannot compute an improvement -- discontinu...
      • Survival analysis - data management query
      • Stock volatility
      • Regression with Interaction Terms and Post-Estimat...
      • Splitting An Instance into two existing attributes
      • Specific period Buy and Hold returns for every day
      • Getting regression results for my last dummy
      • regression coefficient calculation not correct
      • Latitude and Longitude to perform geonear and the ...
      • (ssc) esttab and stcrreg: option equations() invalid
      • lazy man's research
      • spmap polygon sepearate graphs
      • Obtain which bin and corresponding density each ob...
      • Same date or within 7 days, within two variables
      • Simple percentiles using wide dataset
      • Checking Duplications
      • Matching several observations via new variable
      • Getting the repeated-measures bse() error (again)
      • Regarding generating year-sum for each variable
      • Inconsistency between rdrobust and rdplot results
      • Combine the panel data with External Covariates.
      • Removing duplicate ID's by creating additional var...
      • IV estimates with low mean values of the outcome?
      • Which statistics should I use when analyzing the e...
      • coefplot and axis labels of different colors
      • Conducting system GMM using xtabond2
      • Testing for serial correlation in panel analysis w...
      • How to overcome the word limitation of 12 in Stata...
      • what does the size() option on bootstrap do?
      • xtmixed command combined with by() or bysort()
      • Fastest code for finding unique values
      • Global macro with adjusted logistic regression wit...
      • From SAS to Stata: sampling weight for nonlinear m...
      • Isolating highest value of a variable using collap...
      • tostring does not return correct values
      • Dealing with Product wise and Year wise firm data
      • Create several histograms same picture
      • Bootstrapping for logistic regression on imbalance...
      • error message when using Xtgraph
      • Counterfactual decomposition issue
      • Counting number of days between dates among differ...
      • ARDL with daily frequency and with a business cale...
      • Counting number of days between dates among differ...
      • How to write a double foreach loop
      • Model with interactions vs joint estimation
      • Stata insheet error:too many variables specified
      • Comparing non-nested models
      • Constructing a Time-to-Event Variable (days) with ...
      • Searching one dataset for a variable within anothe...
      • Interpolation inverted distance weight
      • Difference between Stir, Stmh and Stmc ?
      • Graphing by year?
      • Reshape long with multiple variables
      • dummy variable conditional not working for all pan...
      • Rolling regression with pooled time series data; p...
      • Approximating trend in time-series
      • Insufficient observations for bootstrap standard e...
      • Frequency spillover and connectedness?
      • Centering the origin of the Cartesian plane in –tw...
      • Estimating effect of lagged changes on wealth accu...
      • Grouping small communities to avoid small cell pro...
      • Loop with a condition
      • Grouping Households in Panel Data Based on Identif...
      • Generate date on condition
      • propensity score matching with ordered outcome var...
      • Applying weights to multilevel hazard analysis usi...
      • Model development support: Mixed effects on a quan...
      • Dropping data during while bootstrapping 95%CI usi...
      • Header/footer information with -putexcel-
      • Drop survey families where parents are not in spec...
      • converting unique string variables from two datase...
      • Endogeneity in Dynamic Tobit model
      • Data cleaning: Select all that apply
      • proportion of sales in each group accounted for by...
      • Hot to make Autocorrelation Test in STATA for Pane...
      • Interpreting Output of sts list Command
      • DYNARDL: Dynamic Autoregressif Detributed Lag
      • Odds ratio for more than two categorical variables
      • interaction term in regression
      • How to reproduce fracreg with gsem
      • Sensitivity Analysis for Causal Mediation with Int...
      • can we set history window and variable window appe...
      • Proportion test for multiple groups
      • dynamic probit fixed effects model using "probitfe...
      • Applying HCUP software on NIS data through STATA
      • Which test to use in Stata? Relationship Wage Gend...
      • calculate the number of share
  • ►  2021 (7379)
    • ►  December (327)
    • ►  November (645)
    • ►  October (646)
    • ►  September (639)
    • ►  August (557)
    • ►  July (649)
    • ►  June (656)
    • ►  May (697)
    • ►  April (683)
    • ►  March (697)
    • ►  February (518)
    • ►  January (665)
  • ►  2020 (7956)
    • ►  December (653)
    • ►  November (659)
    • ►  October (598)
    • ►  September (654)
    • ►  August (660)
    • ►  July (682)
    • ►  June (683)
    • ►  May (708)
    • ►  April (692)
    • ►  March (698)
    • ►  February (638)
    • ►  January (631)
  • ►  2019 (9458)
    • ►  December (601)
    • ►  November (643)
    • ►  October (650)
    • ►  September (637)
    • ►  August (645)
    • ►  July (681)
    • ►  June (654)
    • ►  May (1034)
    • ►  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