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
Double Reshape With Excel File?

Double Reshape With Excel File?

Sunday, April 30, 2023 Data Cleaning Data management Data Processing
Hey everyone. I'm working with quite the interesting excel file. Let's load it, shall we? Code: clear * cls import excel "ht...
Cannot evaluate a nlcom ratio after an mlogit estimation

Cannot evaluate a nlcom ratio after an mlogit estimation

5:24 PM Data Cleaning Data management Data Processing
Hi all, I am trying to get a valuation of a nonlinear expression of my estimated parameters from a mlogit model . mlogit OS3 A1 North Ce...
Generating ith date of year variable from day/month/year date variable?

Generating ith date of year variable from day/month/year date variable?

2:25 PM Data Cleaning Data management Data Processing
Hi all, I am wondering if it is possible to generate a variable in the format of i th day of the year from a date variable. I have been re...
How to identify the minimum year of membership to the agreement between the pairs that are symmetric

How to identify the minimum year of membership to the agreement between the pairs that are symmetric

2:24 AM Data Cleaning Data management Data Processing
Dear All, I have data on trade agreements and membership to the WTO between country (i) and country (j). My data looks something like: C...
xtdidregress problem: not all my data is used

xtdidregress problem: not all my data is used

12:24 AM Data Cleaning Data management Data Processing
Hello, I am writing my master thesis and I have to find the causal relationship between the Belgian gender quotum in board of directors of...
Understanding and interpreting the large coefficients of control variables in my results table

Understanding and interpreting the large coefficients of control variables in my results table

Saturday, April 29, 2023 Data Cleaning Data management Data Processing
Hi, I am running a panel regression with a DiD setup and fixed-effects. I have obtained significant results for the years that I am intere...
Standard errors with new -xthdidregress- command in Stata 18

Standard errors with new -xthdidregress- command in Stata 18

5:25 PM Data Cleaning Data management Data Processing
I am trying to understand how -xthdidregress- estimates standard errors for difference-in-differences with two-way fixed effects (TWFE). The...
Choosing the Correct Panel Data Model

Choosing the Correct Panel Data Model

5:25 PM Data Cleaning Data management Data Processing
Hi there, I am estimating a fiscal reaction function in dynamic form (lagged dependent variable) and trying to choose the right model. My da...
Baseline Balance - T-Test - Missing Values

Baseline Balance - T-Test - Missing Values

3:25 PM Data Cleaning Data management Data Processing
I want to create a balance table on STATA. It is a baseline dataset conducted as a part of an RCT. However, some of the variables have missi...
Help with stcrreg / competing regression

Help with stcrreg / competing regression

6:24 AM Data Cleaning Data management Data Processing
Dear All, I am trying to perform a competing regression analysis but receiving the following error. 'option compete(): competing ris...
bar chart multiple global ifs

bar chart multiple global ifs

5:23 AM Data Cleaning Data management Data Processing
Hello, I am working on my masters thesis and am having some troubles visualizing the data as I would like. I have 15 variable cat_1 to cat...
freduse not working in Stata 18

freduse not working in Stata 18

5:23 AM Data Cleaning Data management Data Processing
I just installed Stata 18 and when I use freduse I get this error: . freduse CTNA, clear note: https://research.stlouisfed.org/fred...dda...
Does CSDID store weight (dripw)?

Does CSDID store weight (dripw)?

12:23 AM Data Cleaning Data management Data Processing
Hi everyone, As we know that it's a tradition to show covariates balance before and after weighting. I am using CSDID with dripw o...
Dr

Dr

Friday, April 28, 2023 Data Cleaning Data management Data Processing
I try to import a Excel file but it shows "<istmt>: 3499 import_excel_import_file() not found". How can I import the file
Importing jason files.

Importing jason files.

6:24 PM Data Cleaning Data management Data Processing
I need to import thousands of JSON files saved on my local hard drive and read in all the variables as string. The JSON files are of very si...
dealing with a time varying variable in stcox

dealing with a time varying variable in stcox

3:24 PM Data Cleaning Data management Data Processing
I am analyzing survival in a group of respiratory patients it turns out that one of my variables (FVC, a measure of respiratory function ex...
Forcing Stata to Post a Singular Variance-Covariance Matrix ("variance matrix is nonsymmetric or highly singular")

Forcing Stata to Post a Singular Variance-Covariance Matrix ("variance matrix is nonsymmetric or highly singular")

3:24 PM Data Cleaning Data management Data Processing
Hello all, I am trying to get around the "variance matrix is nonsymmetric or highly singular" error and force Stata to give me ...
Margins plots  curve lines other than straight line

Margins plots curve lines other than straight line

Thursday, April 27, 2023 Data Cleaning Data management Data Processing
After using "margins" command, I use "marginsplot" command to graph the margins plots. I get straight line while I find ...
How to find lag and lead time

How to find lag and lead time

7:24 PM Data Cleaning Data management Data Processing
Hello, I have this time series data looking at whether food contamination in a school district led to incidence of hospitalizations. I hav...
Inference from initial statistics to get a hang of coefficient of interests

Inference from initial statistics to get a hang of coefficient of interests

7:24 PM Data Cleaning Data management Data Processing
Code: Earning employment Establishment Treat 27,425.41 19,458.09 3,829.57 (10,636.87) (35,378.12) (4,147.39) ...
Calculate average of the (pairwise) sample cross-correlations

Calculate average of the (pairwise) sample cross-correlations

3:24 PM Data Cleaning Data management Data Processing
Dear forum, since this is my first post here and since I am new to Stata, I hope my post fulfills the forum requirements. I want to calcula...
urlencoding() usage

urlencoding() usage

2:24 PM Data Cleaning Data management Data Processing
Hi all, Anyone understand the usage of urlencoding()? string scalar urlencode(string scalar s , real scalar useplus ) string scalar...
required the sampled required the sampled firms to have at least five observations in the data set

required the sampled required the sampled firms to have at least five observations in the data set

2:24 PM Data Cleaning Data management Data Processing
please i required the sampled required the sampled firms to have at least five observations in the data set WHAT The code i need to add to m...
What should I do to achieve the following result.?

What should I do to achieve the following result.?

1:25 AM Data Cleaning Data management Data Processing
Code: * Example generated by -dataex-. For more info, type help dataex clear input str3 code str29 value "A " "test1test1te...
Create new variables using two categorical variables

Create new variables using two categorical variables

Wednesday, April 26, 2023 Data Cleaning Data management Data Processing
I have three variables gender sector and wf. Gender and sector are categorical variables, where gender takes values between male and female ...
assign variable label to variable name

assign variable label to variable name

9:25 PM Data Cleaning Data management Data Processing
Hi I have a dataset that has some variables, say, X1-X10. The corresponding variable labels are 2018:q1, 2018q2, and so on. i want to renam...
how to calculate output of r(alpha) (short example included)?

how to calculate output of r(alpha) (short example included)?

8:23 PM Data Cleaning Data management Data Processing
My deepest apologies if this is difficult to work with. I'm not a stata user, i'm just trying to decipher existing code Input ...
Creating an Abortion scale

Creating an Abortion scale

6:24 PM Data Cleaning Data management Data Processing
Hello Everyone, I am trying to create a 7-point scale for attitudes towards abortion for every decade using GSS from 1980 to 2021. So, th...
Stata 18 and Statalist

Stata 18 and Statalist

3:25 PM Data Cleaning Data management Data Processing
With the most welcome release of Stata 18, the FAQ Advice has as is customary been tweaked slightly. Members are please asked to take specia...
Interpret log-linear coefficient of a percentage type

Interpret log-linear coefficient of a percentage type

4:24 AM Data Cleaning Data management Data Processing
Extremely trivial question but I just want to ensure I have the right interpretation. I have the following model: ln(y) = b0 + b1 X1 whe...
continuous interaction variable and margins

continuous interaction variable and margins

2:24 AM Data Cleaning Data management Data Processing
aa
Solving a system of nonlinear equations with summations

Solving a system of nonlinear equations with summations

Tuesday, April 25, 2023 Data Cleaning Data management Data Processing
This is my first time posting in the forum, so my apologies if this question isn't clear enough or doesn't meet all the standards. I...
Newey West SE for a sample with same date in different quintiles

Newey West SE for a sample with same date in different quintiles

6:24 PM Data Cleaning Data management Data Processing
Here is my data example. For one date , I have different values of term in different quintile ( quint ). Code: * Example generated by -d...
Problem with prediction after mlogit

Problem with prediction after mlogit

4:25 PM Data Cleaning Data management Data Processing
Hi, I am working with a Household survey for 2022, where each row is an individual. I have information on demographics as well as employme...
using coefplot with xtreg

using coefplot with xtreg

2:23 PM Data Cleaning Data management Data Processing
I am using HTML Code: xtreg to run an event study model and would like to use coefplot with it. I have used regress command to generate p...
IBES Analyst Mean Forecast (EPS) for Year 1-3

IBES Analyst Mean Forecast (EPS) for Year 1-3

Monday, April 24, 2023 Data Cleaning Data management Data Processing
Dear all, I have downloaded the analyst forecast data from IBES and now want to create panel data (Using CUSIP and firm year). Particularly...
Problem with xtunitroot llc: throws error r(2000) with strongy balanced panel

Problem with xtunitroot llc: throws error r(2000) with strongy balanced panel

4:23 PM Data Cleaning Data management Data Processing
I am using the Levin Lin Chiu test in Stata 17 to test for stationarity in a panel of 115 countries, from 1995 to 2015 with a delta of five ...
Twoway line graph with non-integer intervals

Twoway line graph with non-integer intervals

3:23 PM Data Cleaning Data management Data Processing
Hi, I want to create a two-way line graph with the line restricted between two years value. The problem is the subcommand "if" do...
Error in post command: unknown function () post:  above message corresponds to expression 1, variable

Error in post command: unknown function () post: above message corresponds to expression 1, variable

3:23 PM Data Cleaning Data management Data Processing
I´m getting an error in my code when using post command but I don´t know why. The code is reproducible with auto dataset: Code: clea...
unable to export mean and sd using tabstat

unable to export mean and sd using tabstat

6:27 AM Data Cleaning Data management Data Processing
Hello, I am using the below code to export my descriptive statistics. All is good except that I get an empty column for mean and sd. Can a...
Different kinds of missings

Different kinds of missings

6:27 AM Data Cleaning Data management Data Processing
Dear stata-community, I collected data on about 2000 participants via an online survey. I am now in the process of cleaning that data (wit...
Specification of triple difference-in-differences with 2 treatment groups and 1 control group

Specification of triple difference-in-differences with 2 treatment groups and 1 control group

6:27 AM Data Cleaning Data management Data Processing
Hello everyone, I have an outcome which I measure between two dates for three different cohorts. The treatment whose effect I want to meas...
Ivreg2

Ivreg2

4:27 AM Data Cleaning Data management Data Processing
Array Hi, I am writing a thesis on the effect of higher stringency on Covid-19 mortality in US counties. I am comparing all counties that...
stset+sttocc matching - nested case-control study

stset+sttocc matching - nested case-control study

Sunday, April 23, 2023 Data Cleaning Data management Data Processing
Hi all, I am designing a nested case-control study using cohort data and would like some help with matching using the stset + sttocc com...
Creating a gamma distribution function to estimate likelihoods

Creating a gamma distribution function to estimate likelihoods

7:24 PM Data Cleaning Data management Data Processing
I have created a dataset from the following: set obs 10 gen goals=_n-1 gen alpha=1.4 gen beta=1 I want to use a gamma distribution fu...
Ordered Probit: discontinuous region with missing values encountered when estimating Marginal effect

Ordered Probit: discontinuous region with missing values encountered when estimating Marginal effect

4:25 PM Data Cleaning Data management Data Processing
Dear Statalist I am using ordered probit model. While calculating the marginal effect it showing the error discontinuous region with missi...
Ordered logistic regression with panel data and an interaction term between two binary independent variables

Ordered logistic regression with panel data and an interaction term between two binary independent variables

2:25 PM Data Cleaning Data management Data Processing
Hi Users, I have a panel data set covering the years 2011-18 but mainly focusing on 2015-16. I am attempting to use the xtologit command i...
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)
      • Double Reshape With Excel File?
      • Cannot evaluate a nlcom ratio after an mlogit esti...
      • Generating ith date of year variable from day/mont...
      • How to identify the minimum year of membership to ...
      • xtdidregress problem: not all my data is used
      • Understanding and interpreting the large coefficie...
      • Standard errors with new -xthdidregress- command i...
      • Choosing the Correct Panel Data Model
      • Baseline Balance - T-Test - Missing Values
      • Help with stcrreg / competing regression
      • bar chart multiple global ifs
      • freduse not working in Stata 18
      • Does CSDID store weight (dripw)?
      • Dr
      • Importing jason files.
      • dealing with a time varying variable in stcox
      • Forcing Stata to Post a Singular Variance-Covarian...
      • Margins plots curve lines other than straight line
      • How to find lag and lead time
      • Inference from initial statistics to get a hang of...
      • Calculate average of the (pairwise) sample cross-c...
      • urlencoding() usage
      • required the sampled required the sampled firms to...
      • What should I do to achieve the following result.?
      • Create new variables using two categorical variables
      • assign variable label to variable name
      • how to calculate output of r(alpha) (short example...
      • Creating an Abortion scale
      • Stata 18 and Statalist
      • Interpret log-linear coefficient of a percentage type
      • continuous interaction variable and margins
      • Solving a system of nonlinear equations with summa...
      • Newey West SE for a sample with same date in diffe...
      • Problem with prediction after mlogit
      • using coefplot with xtreg
      • IBES Analyst Mean Forecast (EPS) for Year 1-3
      • Problem with xtunitroot llc: throws error r(2000) ...
      • Twoway line graph with non-integer intervals
      • Error in post command: unknown function () post: ...
      • unable to export mean and sd using tabstat
      • Different kinds of missings
      • Specification of triple difference-in-differences ...
      • Ivreg2
      • stset+sttocc matching - nested case-control study
      • Creating a gamma distribution function to estimate...
      • Ordered Probit: discontinuous region with missing ...
      • Ordered logistic regression with panel data and an...
      • Why are my variables being omitted by Stata?
      • Generating a variable based on other variable
      • Repeated measures with informative censoring time ...
      • Fixed Effects on countries and dummy omitted
      • Not concave message on my IRT models
      • Same observations across all models without using ...
      • Changing axes font in graph
      • Create variable - mean per age
      • The Null hypothesis of t-test in non-linear least-...
      • The Null hypothesis of t-test in non-linear least-...
      • Replacing values with exisiting ones
      • -codebook, problems- with problems indicating inco...
      • SEM builder with Random Intercepts
      • Identifying and flagging matches
      • Issue with converting date in dd.mm.yy format to d...
      • Moving average invalid syntax
      • Importing descriptive tables with outreg2
      • Bioequivalence for Dichotomous outcomes, and also ...
      • spmap: Horizontal legend with specified legend tex...
      • Help in Reshaping the Data
      • dpplot command, use xline() option but not showing...
      • Is it possible to tag duplicates sequentially?
      • Using -xtologit- postestimation tools (particularl...
      • Tabulating (counting) within many groups in a data...
      • Merging two datasets
      • estadd local not working in Stata 17
      • Issues with regression on Asset pricing Models (Pa...
      • xttobit or fracreg for panel data? My dependent va...
      • ANCOVA or MANCOVA? Help is MUCH appreciated
      • Estimating adjusted mean difference by treatment g...
      • How do I check goodness of fit when using "xtmlogit"?
      • Predicting values using Simple Linear Regression o...
      • How to remove last 3 digits from a numerical varia...
      • Absent confidence intervals when using twoway lfitci
      • Replacing string values with numerical values
      • Asdoc mixed regression || inclusion not working
      • How to Use Stata Code to Count How Many Students e...
      • Matrix of sums of submatrices
      • Asdoc
      • How can I install meta analysis package in my stat...
      • syntax: add a minus before a list of variables
      • How to convert a scalar value into a large matrix
      • Outreg2 and other issues with xtprobit
      • xtivreg2 with time fixed effects
      • Splitting Multiple Response Variable
      • How to incorporate cointegrating equations into th...
      • Weak Instrument Test
      • Testing whether marginal effects are statistically...
      • Dummy variable coefficients are getting automatica...
      • How do I calculate specific time lapses?
      • Hello ! Problems in setting up Maximum Likelihood ...
      • Non-staggered treatment and no control group: DID2S
      • flipping sign when adding different fixed effects
    • ►  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)
    • ►  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