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
Counting the number of significant coefficients in a linear regression

Counting the number of significant coefficients in a linear regression

Tuesday, August 31, 2021 Data Cleaning Data management Data Processing
Is there any simple way by which I can count the number of only significant coefficients in a regression? I have 1400 village dummies in a ...
Font for Tables and Figures

Font for Tables and Figures

10:29 PM Data Cleaning Data management Data Processing
I am using kpfonts in LaTeX and would like to have the same font in figures and tables that I produce in stata. I tried to change the font i...
compare variables in two years

compare variables in two years

10:29 PM Data Cleaning Data management Data Processing
Deat Statalist, I have a set of variables from 2010-2012, I want to compare which companies are new to the dataset (i.e., not in the data ...
egen rowmax produces additional decimals

egen rowmax produces additional decimals

8:24 PM Data Cleaning Data management Data Processing
Hello. I'm working with US Census data in Stata 15.1. Each observation is a geographic area and the variables are the percentage of the ...
Bayesian seemingly unrelated regression

Bayesian seemingly unrelated regression

8:24 PM Data Cleaning Data management Data Processing
Hi everyone, I intend to estimate a system of equations (input demand functions) using Bayesian seemingly unrelated regression (SUR) appro...
two way scatter plot, command is unrecognized

two way scatter plot, command is unrecognized

8:24 PM Data Cleaning Data management Data Processing
I tried to graph a two way scatter plot, here is my code: tw scatter or id, xlabel(1(1)`max', valuelabel angle(45) labsize(*0.5)) xtit...
Interaction multiple levels categoric variable

Interaction multiple levels categoric variable

8:24 PM Data Cleaning Data management Data Processing
Hello everybody. I'm trying to test if a variable can be considered an effect modification in a svy poisson model. I planned to evalu...
uselabel: how to also export values without a label

uselabel: how to also export values without a label

6:26 PM Data Cleaning Data management Data Processing
Hi Statalist, I was trying to output a file which showcase all values (regardless of whether that value has a label) of a variable. Here...
Hetprobit with factor variable

Hetprobit with factor variable

5:23 PM Data Cleaning Data management Data Processing
Heteroskedastic probit estimation with a factor variable gives (slightly) different results than with equivalent 0-1 indicator variables. Di...
qui being ignored in xtgcause

qui being ignored in xtgcause

4:23 PM Data Cleaning Data management Data Processing
When I run Code: qui xtgcause y z , lags(2) it does not run entirely quietly but displays yzyzid . I know that "as error" over...
Combining Graphs using distplot

Combining Graphs using distplot

4:23 PM Data Cleaning Data management Data Processing
Dear Statalist, I was hoping to get some help on graph output. So I am reading this paper that shows what looks like a semi outdated code ...
Help with labels on bar graph

Help with labels on bar graph

4:23 PM Data Cleaning Data management Data Processing
I am trying to create a horizontal bar graph grouped by categories. I wanted to add two labels to the bars, one with percentages and one wit...
How to print the help file in STATA with all the word retained?

How to print the help file in STATA with all the word retained?

4:23 PM Data Cleaning Data management Data Processing
Hi all, When I try to print from STATA help file, I faced the problem of the word at the right part of the page being cut due to the width...
restricted mean survival time with stpm2_standsurv

restricted mean survival time with stpm2_standsurv

4:23 PM Data Cleaning Data management Data Processing
Dear Paul Lambert, I have encountered the following error message after attempting to use the rmst option in stpm2_standsurv: . stpm2_st...
What does "command ms_get_version is unrecognized" mean and how I should deal with that?

What does "command ms_get_version is unrecognized" mean and how I should deal with that?

4:23 PM Data Cleaning Data management Data Processing
Today I am dealing with a did_imputation from Kirill, 2021 , and I found the error " command ms_get_version is unrecognized " afte...
Mathematical operations within a string variable

Mathematical operations within a string variable

8:23 AM Data Cleaning Data management Data Processing
Dears, I have a dataset with data on pharmaceutical supplies with around 7million observations. One of the variables is on the pharmaceuti...
Multiple response analysis

Multiple response analysis

7:23 AM Data Cleaning Data management Data Processing
Dear Experts I have been trying to analyse COVID-19 related data where each subject submits reports and measurements of vitals. I need to ...
Counting those in the same category as you, by group

Counting those in the same category as you, by group

7:23 AM Data Cleaning Data management Data Processing
Dear all, Please take a look at the attached screenshot of a dummy dataset. How do I generate a variable Relatives, which tells me for eve...
Identifying events within a future time window

Identifying events within a future time window

6:23 AM Data Cleaning Data management Data Processing
Dear Statalist users -- Assume that we have the following toy example: Code: input firm_id year event event_5y 1 1979 0 1 1 ...
putexcel problem with double replace and local macros

putexcel problem with double replace and local macros

6:23 AM Data Cleaning Data management Data Processing
I think this is probably a bug report, but I'll just show what happens and let others decide. Mostly tested with Stata/SE 15.1 under win...
Moderating impact

Moderating impact

6:23 AM Data Cleaning Data management Data Processing
Dear Statalist, Actually, I am bit confused between the joint effect and the moderating impact. I mean I saw some people doing the followin...
Model Specification with GSEM Stata including both multilevel and simple regression modelling?

Model Specification with GSEM Stata including both multilevel and simple regression modelling?

6:23 AM Data Cleaning Data management Data Processing
Hello everyone! My research model includes both Level 1 (individual) and Level 2 (team) variables. Initially, the goal is to explore the det...
Create year variable from yearly-monthly data.

Create year variable from yearly-monthly data.

6:23 AM Data Cleaning Data management Data Processing
Hi all, In the current dataset, I have yearly-monthly data and I would like to transform it into yearly data for each individual. I believ...
Creating variables with 500+ conditions

Creating variables with 500+ conditions

6:23 AM Data Cleaning Data management Data Processing
I am trying to map out school districts based on precinct numbers (which is present in both data sets that I am working with). The precinct ...
How to use Outreg2 with heckman twostep model

How to use Outreg2 with heckman twostep model

4:23 AM Data Cleaning Data management Data Processing
My heckman twostep equation is as follows. ------------------------------------------------------------------------------------------------...
Displaying Arabic text in Stata 15

Displaying Arabic text in Stata 15

4:23 AM Data Cleaning Data management Data Processing
Hello experts, here is a problem: When I import data from excel or SPSS in Stata 15, I see that all Arabic text in the files (in the variab...
nested loop for cycling over observations by group

nested loop for cycling over observations by group

4:23 AM Data Cleaning Data management Data Processing
Hi everyone, I have a dataset with 14 million observations and 22 variables. The variables of interest for this question are as follows: ...
Counting words but dependence on 2 Variables

Counting words but dependence on 2 Variables

4:23 AM Data Cleaning Data management Data Processing
Hello, I am new here and trying to open the topic the right way. I hope I implemented the code correctly and my lack of english is not a p...
Loop to summarize multiple variables in one

Loop to summarize multiple variables in one

2:23 AM Data Cleaning Data management Data Processing
Hello all, I am trying to create a variable that combines the school district identifiers listed below (I actually have to combine over 50...
logistic regression: outcome does not vary

logistic regression: outcome does not vary

12:23 AM Data Cleaning Data management Data Processing
My research topic is about child mortality and risk factors, including education, age, child with full vaccination or not and so on. so my ...
"Starting values invalid" message when using nlsur commands

"Starting values invalid" message when using nlsur commands

12:23 AM Data Cleaning Data management Data Processing
Dear Stata users, I am trying nlsur command using function evaluator program to estimate coefficients of QUAIDS model in Stata 14. The th...
Test constraint dropped

Test constraint dropped

Monday, August 30, 2021 Data Cleaning Data management Data Processing
Dear Statalist: *First, I run the following Modified Pearson Regression with interactions glm k6cat Cancer##caregiving i.sex_cat ib0.age...
Why the number of observation decrease when I increase the sample size?

Why the number of observation decrease when I increase the sample size?

6:23 PM Data Cleaning Data management Data Processing
Hi all, Today I face a strange situation that the number of observations shrinking when I expand the sample size In particular, the numb...
How to see the frequency of a veriables in each country in a dataset ?

How to see the frequency of a veriables in each country in a dataset ?

4:23 PM Data Cleaning Data management Data Processing
By the helps from others, I see that I can list the unique countries from a sample by using\ tab GEOGN where GEOGN is a character variab...
What is wrong with inlist2 in my code?

What is wrong with inlist2 in my code?

4:23 PM Data Cleaning Data management Data Processing
Hi all, Yesterday, as documented from this post ( https://www.statalist.org/forums/for...p-of-countries ) , I try to find a way to test my...
Dates from Excel/CSV not correctly displaying in Stata

Dates from Excel/CSV not correctly displaying in Stata

2:23 PM Data Cleaning Data management Data Processing
I imported several csv files with "birthdate" as one of the variables into Stata and then I appended the files to produce one data...
division of two-column using if function

division of two-column using if function

2:23 PM Data Cleaning Data management Data Processing
Hello, I have this dataset, and I want to divide CLMS18/CLMS17 if NPI17 is the same as NPI18 and the gnrc17 is the same as gnrc18. Is there...
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)
      • Counting the number of significant coefficients in...
      • Font for Tables and Figures
      • compare variables in two years
      • egen rowmax produces additional decimals
      • Bayesian seemingly unrelated regression
      • two way scatter plot, command is unrecognized
      • Interaction multiple levels categoric variable
      • uselabel: how to also export values without a label
      • Hetprobit with factor variable
      • qui being ignored in xtgcause
      • Combining Graphs using distplot
      • Help with labels on bar graph
      • How to print the help file in STATA with all the w...
      • restricted mean survival time with stpm2_standsurv
      • What does "command ms_get_version is unrecognized"...
      • Mathematical operations within a string variable
      • Multiple response analysis
      • Counting those in the same category as you, by group
      • Identifying events within a future time window
      • putexcel problem with double replace and local macros
      • Moderating impact
      • Model Specification with GSEM Stata including both...
      • Create year variable from yearly-monthly data.
      • Creating variables with 500+ conditions
      • How to use Outreg2 with heckman twostep model
      • Displaying Arabic text in Stata 15
      • nested loop for cycling over observations by group
      • Counting words but dependence on 2 Variables
      • Loop to summarize multiple variables in one
      • logistic regression: outcome does not vary
      • "Starting values invalid" message when using nlsur...
      • Test constraint dropped
      • Why the number of observation decrease when I incr...
      • How to see the frequency of a veriables in each co...
      • What is wrong with inlist2 in my code?
      • Dates from Excel/CSV not correctly displaying in S...
      • division of two-column using if function
      • Limiting panel data regression to groups with at l...
      • Block bootstrapping panel: Unable to generate new ...
      • Counting number of categories in a variable by group
      • Linking a personal identifier (ID) to specific cha...
      • 2sls regression with interaction between endogenou...
      • Linear-Log Cubic regression
      • Regression output
      • DID - specifying control cohort and treatment cohort
      • Conditional probabilities in Stata
      • Converting raster format data (5 arc-minute grid c...
      • Fixed effect
      • High R-square in ppml
      • How to show the unique value of a characteristic v...
      • Suest and r-squared?
      • Counting readmission rate from the index date
      • Outreg2 Not Working
      • How to create a panel to estimate Sectoral Gravity...
      • reghdfe and boottest
      • xtqreg and by sort command
      • Two questions on fixed effects in stata
      • Calculating the mean of categories of a variable c...
      • Deleting files from folder based on sting condition
      • How do I reference an estimate after lincom?
      • Dropping Observations and Creating Fertility Variable
      • Transform data from wide to long but then lots of ...
      • how can concat observation data by ID
      • IV regressions with interaction terms
      • Referring to a certain value when generating a new...
      • what should we do if after first differences the n...
      • Request syntax assistance with v17 [table] command...
      • Rearranging individual dates within a varlist
      • Unlimited loop of events tested when using eventst...
      • Making not to show the each results in the table
      • Statistical hypotheses test for independent count ...
      • question
      • New package srslogit on SSC
      • Coefplot: Line Plot
      • lnGSDP (the squared values of the variable GSDP) d...
      • Combining multiple Excel files with <xls2dta> command
      • How to perform multiple interpolation for missing ...
      • Complicated coding - female/male friends - same se...
      • MLE estimation from a given likelihood function
      • Multiple imputation confusion
      • foreach
      • Panel data graphs
      • Finding mean in a loop
      • Calculate the size of the board
      • Foreach Regression
      • Conditional logistic regression analysis.
      • Scatterplots or sepscatter
      • Plot predicted probability for dummies independent...
      • Insignificant direct effect and significant indire...
      • Generating the average of the last 3 observed valu...
      • Effect of small treatment size
      • Interpreting interaction term coefficient with PPML
      • Spatial Correlation in Standard Errors
      • Spell Check Do-File Editor
      • Estimates Return P-Value
      • Storing Bootstrapped P-values
      • How to change the color on the x, y axes labels
      • Deleting a category
      • matching equal observations spread across two diff...
      • General Lasso Confusion
    • ►  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