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
Firm and Industry Effects Together?

Firm and Industry Effects Together?

Monday, December 31, 2018 Data Cleaning Data management Data Processing
Hi, In the context of corporate finance, some studies claim to use firm and industry fixed effects together in panel data regressions. How...
stata

stata

9:14 AM Data Cleaning Data management Data Processing
Hello . I selecting the excell file. then import the following code in stata gen area=substr( ADDRESS, 1, 1) It is correct for all my file...
variable names as elements?

variable names as elements?

2:04 AM Data Cleaning Data management Data Processing
Dear All, I find this question here . The data is Code: * Example generated by -dataex-. To install: ssc install dataex clear input int E...
Variable not found in nlcom

Variable not found in nlcom

1:24 AM Data Cleaning Data management Data Processing
Dear Everyone, I'm new here and I would like to measure willingness to pay by using double bounded method analysis. I have found the c...
Insufficient observations to compute bootstrap standard errors

Insufficient observations to compute bootstrap standard errors

Sunday, December 30, 2018 Data Cleaning Data management Data Processing
I am trying to perform mi imputation with bootstrap using following syntax: 1.mi set wide 2. program define myboot, rclass 3.mi register ...
Problem with a big database

Problem with a big database

10:39 PM Data Cleaning Data management Data Processing
Hello, I want to open an excel file, import it, but it does not leave stata 14, this excel file has 53.6 mb and the pop-up window tells me t...
area specific linear time trend

area specific linear time trend

2:09 PM Data Cleaning Data management Data Processing
Hi All, Question 1: I'm running a difference-in-differences analysis on yearly repeated cross-sectional data. I'd like to incl...
new command -rdcont- on SSC: test of running variable continuity in RDD

new command -rdcont- on SSC: test of running variable continuity in RDD

11:14 AM Data Cleaning Data management Data Processing
Hello all! Thanks to Kit Baum, a new package rdcont is now downloadable from SSC! This program can be installed from SSC by typing ssc inst...
Changing many values at once

Changing many values at once

10:54 AM Data Cleaning Data management Data Processing
Hi all, I am working with panel data from a household survey. For each household (nohhold), multiple observations have been made in each y...
Fairlie decomposition

Fairlie decomposition

7:44 AM Data Cleaning Data management Data Processing
Hello, I am using the fairlie STATA module for decomposition ( https://ideas.repec.org/c/boc/bocode/s456727.html ) to analyze the followin...
Issue with three-dimensional panel data analysis

Issue with three-dimensional panel data analysis

5:14 AM Data Cleaning Data management Data Processing
Hi, I am new with STATA and I would like some advice for the following problem: I am dealing with panel count data model.My dependent vari...
Questions about Data Setting

Questions about Data Setting

3:54 AM Data Cleaning Data management Data Processing
Dear Statalist, I am now setting the data to write the DID. However, there is a problem with the arrangement of my data to use DID. My ...
Marginsplot, addplot - adjustment

Marginsplot, addplot - adjustment

3:39 AM Data Cleaning Data management Data Processing
Hello, using the command: - marginsplot, addplot(hist...)-, I got this graph: Array I would like to move the histogram at the bottom of...
Twoway line by county

Twoway line by county

1:09 AM Data Cleaning Data management Data Processing
Hi everyone, For my Panel Data descriptive Analysis I am trying to graph the development of Charging stations per Km for my 18 counties. ...
Merging 3 data sets

Merging 3 data sets

Saturday, December 29, 2018 Data Cleaning Data management Data Processing
Good evening all. I am looking for some help merging 3 data sets. All 3 data sets are sorted by patient ID (ptid) and I would like to merge...
Different resutls between xtreg and xtivreg2

Different resutls between xtreg and xtivreg2

8:04 PM Data Cleaning Data management Data Processing
I recently ran into an issue with xtivreg2. I find that the coefficient estimates are so much different between xtivreg2 and xtreg estimati...
Reshape Long Missing Values Error

Reshape Long Missing Values Error

7:19 PM Data Cleaning Data management Data Processing
My dataset is in time series format. I am converting it to a panel using the following code: Code: reshape long var, i(date) But kee...
Doubt with power calculations

Doubt with power calculations

6:59 PM Data Cleaning Data management Data Processing
Greetings I am new to the forum., I am working with a categorical data set, I am trying to calculate the sample size for one variable in my ...
Parallel loop with numlist and varlist

Parallel loop with numlist and varlist

6:24 PM Data Cleaning Data management Data Processing
I built a for loop with locals in it so that I can have parallel loops of a varlist and a numlist. I want to generate a new variable in each...
kdensity for 10,000 variables

kdensity for 10,000 variables

5:04 PM Data Cleaning Data management Data Processing
Hello, I plan to make an illustrative graph to show kdensity graphs for about 10,000. I use the below coding [QUOTE] forvalues j = 1(1)100...
Importing data from Excel

Importing data from Excel

4:34 PM Data Cleaning Data management Data Processing
Dear All, I've got an Excel file with about 37 sheets. The sheets identical (e.g. in terms of number of columns, rows, etc). How can I ...
Reporting results ordered logit regression: individual predictors or entire model?

Reporting results ordered logit regression: individual predictors or entire model?

4:09 PM Data Cleaning Data management Data Processing
Hello, I am running the ordered logit regression to predict eh041, by regression on the variables aa001, aa004, ba016, ca001, ea104, eb001...
Wald chi2 disappears after I apply the robust variance estimate

Wald chi2 disappears after I apply the robust variance estimate

9:59 AM Data Cleaning Data management Data Processing
Dear Stata users and experts, I am running an analysis where I have a time invariant variable, cross-section variables, and longitudinal va...
New command -oaxaca_rif-

New command -oaxaca_rif-

9:24 AM Data Cleaning Data management Data Processing
Dear all, Thanks to Prof. Baum a new command named oaxaca_rif is now available in the SSC archive. This command is a wrapper for the -oaxa...
Quicker way to export correlation coefficients into Excel?

Quicker way to export correlation coefficients into Excel?

8:14 AM Data Cleaning Data management Data Processing
Hello, I am running correlations over hundreds of variables and storing the output of the correlation coefficients, the variable names, numb...
Help with output/results window cutting off variable names

Help with output/results window cutting off variable names

8:09 AM Data Cleaning Data management Data Processing
My variable names are not shown in full, is there any way of getting Stata to tabulate so the output shows the full variable name? There is ...
De trending// De seasonalising data - find weekly mean

De trending// De seasonalising data - find weekly mean

7:39 AM Data Cleaning Data management Data Processing
Hiya, for my project i have daily stock market data (returns and volatility) and daily weather (cloud cover, rain, temp). How do i get s...
IDs in different categories : how to count ?

IDs in different categories : how to count ?

6:12 AM Data Cleaning Data management Data Processing
Dear statalist members, I have a sample of about 1 million people (id) with one or more records in one or more categories (cat), 15 catego...
Cox regression with enourmous Hazard Ratio (logarithmic)

Cox regression with enourmous Hazard Ratio (logarithmic)

6:02 AM Data Cleaning Data management Data Processing
Dear forum, I have encountered a problem in that for my Cox regression my output gives enourmous Hazard Ratios for my outcome (disease rec...
Complex dummy variable

Complex dummy variable

1:57 AM Data Cleaning Data management Data Processing
Hi STATLIST, Merry Christmas to those celebrating it and happy new Year. I have a question about the creation of a dummy variable. In par...
Simple Time Series Regression

Simple Time Series Regression

Friday, December 28, 2018 Data Cleaning Data management Data Processing
Hello everyone, I have a fairly simple question and hope you guys can help me out. I already studied quiet a lot questions/answers here in...
FMM lcprob variables

FMM lcprob variables

3:37 PM Data Cleaning Data management Data Processing
Hello experts, In FMM (finite mixture models), our main models(s) could have certain IVs. Then, I can add some variables to lcprob to spe...
calculating and graphing marginal effects from logit with interaction effect of two categorical variables

calculating and graphing marginal effects from logit with interaction effect of two categorical variables

3:27 PM Data Cleaning Data management Data Processing
Code: * Example generated by -dataex-. To install: ssc install dataex clear input byte(owndecision treat gender) 1 1 1 1 1 1 1 1 1 1 1 1 ...
Writing loop for multiple regressions

Writing loop for multiple regressions

2:12 PM Data Cleaning Data management Data Processing
I have 10 dependant variables, y1-y30, and its respective lagged variables, lagy1-lagy30. I would like to regress one dependant variable on ...
using "spmap"

using "spmap"

1:47 PM Data Cleaning Data management Data Processing
Hi guys, I am trying to map the result by using " spmap " command, yet keep having troubles with the error saying "master ...
How to present vignettes in a tabular format

How to present vignettes in a tabular format

1:27 PM Data Cleaning Data management Data Processing
Hello everyone, Could you please help me to present vignettes in a tabular format rather than a running text? Code: use setup, clear ...
The base year for finding yearly effects of the shock in DID

The base year for finding yearly effects of the shock in DID

1:17 PM Data Cleaning Data management Data Processing
I wanted to estimate a difference-in-differences model using Stata looking at the effects of a trade shock (in 2007) on households' inco...
GEE and distributional assumptions

GEE and distributional assumptions

12:02 PM Data Cleaning Data management Data Processing
Hello all, I am using GEE to estimate my dependent variable. The dependent variable has a lower bound of 0 (its observed value, not censor...
repeated time values within panel

repeated time values within panel

11:42 AM Data Cleaning Data management Data Processing
Dear Statalisters! I have problems with my time variable. I tried to use this commando: xtset importer1 Year But I get this error messa...
discrepancy between mixed results and contrast command

discrepancy between mixed results and contrast command

9:22 AM Data Cleaning Data management Data Processing
Hi, I'm running a mixed model for longitudinal data with a two by two categorical interaction (all other variables being continuous). gr...
How to remove observations with no change in the dependent variable in a regression ?

How to remove observations with no change in the dependent variable in a regression ?

8:37 AM Data Cleaning Data management Data Processing
I have a panel data set that is of the form shpro date price 1 1 100 1 2 100 1 3 100 1 4 100 2 1 98 2 2 ...
Panel Regression - Top 10% of income of each industry each year

Panel Regression - Top 10% of income of each industry each year

4:17 AM Data Cleaning Data management Data Processing
Dear all, unfortunately I am new to Stata and I dont really know how to go ahead. I want to perform a regression with the top 10% of incom...
Three way tables using svyset

Three way tables using svyset

3:47 AM Data Cleaning Data management Data Processing
Hello, I am using Stata 13 and I have a question regarding three way tables while using complex survey data. My dataset is weighted and st...
factor variables and time-series operators not allowed

factor variables and time-series operators not allowed

3:22 AM Data Cleaning Data management Data Processing
Hi, I am trying to run the following the codes, but get the error message "factor variables and time-series operators not allowed...
Is it possible to divide a variable by the mean across individuals for a regression???

Is it possible to divide a variable by the mean across individuals for a regression???

Thursday, December 27, 2018 Data Cleaning Data management Data Processing
Hello, is it okay to divide each individual's value of a variable by the mean of the sample and then use this transformed variable for...
Assigning variable values to observations based common values of other variables...

Assigning variable values to observations based common values of other variables...

6:57 PM Data Cleaning Data management Data Processing
I have a data set with 3 variables: one identifies the contract number; one identifies the type of contract (two values (prime or sub); and ...
Merging dates

Merging dates

6:07 PM Data Cleaning Data management Data Processing
Hi, I'm trying to merge two dates variables from the same dataset, but I would like to prioritize one on the other: considering date1...
getting estimates when using bayes prefix for melogit

getting estimates when using bayes prefix for melogit

4:12 PM Data Cleaning Data management Data Processing
Hi Stata forum members, I need some advice on how to get estimates after fitting melogit using bayesian framework. I have tried using the ...
1-to-(n) Propensity score matching without replacement

1-to-(n) Propensity score matching without replacement

2:37 PM Data Cleaning Data management Data Processing
Hi, I was hoping if someone can help me with this. I have a data set with about 100 cases and 6000 controls. I want to create a propensity...
Concatenate of a string and a number

Concatenate of a string and a number

1:22 PM Data Cleaning Data management Data Processing
Dear statalister, I am trying to merge to database, I would like to try using a concatenate of country and year, first is a string and the...
Convert string to time including milliseconds

Convert string to time including milliseconds

1:22 PM Data Cleaning Data management Data Processing
I have a variable containing strings in the following format StringVar "2018-12-27 14:28:41.4861930" I would like to convert ...
Joinby two variables

Joinby two variables

12:57 PM Data Cleaning Data management Data Processing
Dear statalisters, I am trying to merge two datasets and I have some problems. I started yesterday merging using Code: joinby firm and...
Generate multiple variables from a variable containing symbols and numbers

Generate multiple variables from a variable containing symbols and numbers

12:37 PM Data Cleaning Data management Data Processing
Code: * Example generated by -dataex-. To install: ssc install dataex clear input str29 salary_today "243,250 (307,840) (253,454)...
margins not estimable

margins not estimable

8:42 AM Data Cleaning Data management Data Processing
Hi all, I run a panel data fixed effect regression. There is an interaction term in the model. Through the reults, I can see the marginal ...
Foreach vs. Forvalues when using char() function to remove special characters in a string variable

Foreach vs. Forvalues when using char() function to remove special characters in a string variable

8:12 AM Data Cleaning Data management Data Processing
Hello all, Using Stata 15.1/IC I need to submit a bulk file with a string variable ("NAME" variable in this example) that is r...
Using -cmp- to estimate and interpret a three-stage Heckman model

Using -cmp- to estimate and interpret a three-stage Heckman model

7:57 AM Data Cleaning Data management Data Processing
Good morning all, I am using the -cmp- package developed by Roodman to estimate a three-stage Heckman selection model. I am using the foll...
Hyperlink to the file generated/modified by putexcel

Hyperlink to the file generated/modified by putexcel

7:37 AM Data Cleaning Data management Data Processing
This is a very minor request/question. Several of the user-made commands I use (e.g. estout, and iebaltab) have a nifty feature where they p...
grouped variables

grouped variables

7:02 AM Data Cleaning Data management Data Processing
Hi I currently have a variables for income following this structure: Therefore when I run summary statistics it comes up with a mean of th...
Standard errors using Frisch-Waugh-Lovell theorem

Standard errors using Frisch-Waugh-Lovell theorem

5:57 AM Data Cleaning Data management Data Processing
Hi, I need to implement the Frisch Waugh-Lovell-theorem in Stata 15 MP (64-bit) in the context of a research project. To illustrate my prob...
questions about model selection with lassopack

questions about model selection with lassopack

Wednesday, December 26, 2018 Data Cleaning Data management Data Processing
Dear STATA users, Sorry to ask you 3 simple questions. 1.When we used lassopack for selecting predictors, if the predictor is a categoric...
Is there a way to rename large number of variables with a single command? (Details)

Is there a way to rename large number of variables with a single command? (Details)

6:37 PM Data Cleaning Data management Data Processing
I have a ton of variables, for example, var1_m, var2_m, var3_m, etc. I want to turn them into var1_2016, var2_2016, var3_2016, etc. Basicall...
Generate with tempfiles

Generate with tempfiles

6:17 PM Data Cleaning Data management Data Processing
I used Stata tempfile code from one of the earlier posts to append multiple years of NHIS mortality data. The code worked perfectly. Howeve...
Looking for examples of OSIRIS dictionaries and data

Looking for examples of OSIRIS dictionaries and data

5:47 PM Data Cleaning Data management Data Processing
Dear Statalisters, I am writing a custom converter of data from OSIRIS dictionaries and need examples for testing. I know ICPSR has a bun...
Strategy to choose the right controls? Conceptual questions

Strategy to choose the right controls? Conceptual questions

5:27 PM Data Cleaning Data management Data Processing
Hello, I have a problem with chosing the right controls for my model and hope someone can help me along . With the model I want to expla...
Generate a new variable by deleting everything after certain character ("/")

Generate a new variable by deleting everything after certain character ("/")

2:32 PM Data Cleaning Data management Data Processing
Code: * Example generated by -dataex-. To install: ssc install dataex clear input str28 country "UK" ...
Non-linear hypotheses testing with a GSEM

Non-linear hypotheses testing with a GSEM

1:47 PM Data Cleaning Data management Data Processing
Hello, I'm having trouble with the testnl command after a GSEM model. Specifically, my problem is that I can't refer to the covarian...
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)
    • ►  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)
      • Firm and Industry Effects Together?
      • stata
      • variable names as elements?
      • Variable not found in nlcom
      • Insufficient observations to compute bootstrap sta...
      • Problem with a big database
      • area specific linear time trend
      • new command -rdcont- on SSC: test of running varia...
      • Changing many values at once
      • Fairlie decomposition
      • Issue with three-dimensional panel data analysis
      • Questions about Data Setting
      • Marginsplot, addplot - adjustment
      • Twoway line by county
      • Merging 3 data sets
      • Different resutls between xtreg and xtivreg2
      • Reshape Long Missing Values Error
      • Doubt with power calculations
      • Parallel loop with numlist and varlist
      • kdensity for 10,000 variables
      • Importing data from Excel
      • Reporting results ordered logit regression: indivi...
      • Wald chi2 disappears after I apply the robust vari...
      • New command -oaxaca_rif-
      • Quicker way to export correlation coefficients int...
      • Help with output/results window cutting off variab...
      • De trending// De seasonalising data - find weekly ...
      • IDs in different categories : how to count ?
      • Cox regression with enourmous Hazard Ratio (logari...
      • Complex dummy variable
      • Simple Time Series Regression
      • FMM lcprob variables
      • calculating and graphing marginal effects from log...
      • Writing loop for multiple regressions
      • using "spmap"
      • How to present vignettes in a tabular format
      • The base year for finding yearly effects of the sh...
      • GEE and distributional assumptions
      • repeated time values within panel
      • discrepancy between mixed results and contrast com...
      • How to remove observations with no change in the d...
      • Panel Regression - Top 10% of income of each indus...
      • Three way tables using svyset
      • factor variables and time-series operators not all...
      • Is it possible to divide a variable by the mean ac...
      • Assigning variable values to observations based co...
      • Merging dates
      • getting estimates when using bayes prefix for melogit
      • 1-to-(n) Propensity score matching without replace...
      • Concatenate of a string and a number
      • Convert string to time including milliseconds
      • Joinby two variables
      • Generate multiple variables from a variable contai...
      • margins not estimable
      • Foreach vs. Forvalues when using char() function t...
      • Using -cmp- to estimate and interpret a three-stag...
      • Hyperlink to the file generated/modified by putexcel
      • grouped variables
      • Standard errors using Frisch-Waugh-Lovell theorem
      • questions about model selection with lassopack
      • Is there a way to rename large number of variables...
      • Generate with tempfiles
      • Looking for examples of OSIRIS dictionaries and data
      • Strategy to choose the right controls? Conceptual ...
      • Generate a new variable by deleting everything aft...
      • Non-linear hypotheses testing with a GSEM
      • Merging two data sets using joinby but with capito...
      • Statistical Significance using Burgstahler & Diche...
      • Merging two data sets
      • Generating predicted probabilities of random effec...
      • foreach num in numlist - reports error (numlist no...
      • Exporting Mlogit Marginal Effects to Excel
      • Generating variables in migration panels
      • tabout command generating an easy cross table in word
      • Sum by ID in one data file
      • Calculating duration of follow-up time
      • Calculating person years
      • Change ID codes to a corresponding different ID co...
      • A little help with summary statistics
      • New version of cprdhesutil on SSC
      • New version of htmlutil on SSC
      • how to multiply 100 times in bootstrapping
      • Interpretation of mitesttransform
      • Unable to automate importing files from the Depart...
      • Averaging for a subset of observations
      • bootstrap for internal validation: how can we calc...
      • Gini coefficient
      • Analyzing Blinder-Oaxaca decomposition
      • multiple rows loop
      • How to expand results window?
      • Nearest Neighbor Matching without Treatment Effects?
      • Functional Forms of Independent Variables
      • Standard Errors in the Frankel and Romer type stud...
      • Displaying interaction terms in separate column in...
      • Keep rows if two consecutive columns have the same...
      • The most and least advantaged child analysis
      • December Delhi useR Meetup at SocialCops
      • Hausman Test in FE and RE linear regression at mul...
      • Outreg - varlist not allowed
      • First effects vs first difference
    • ►  November (239)

© BJ Data Tech Solution | Theme by Rifki.id | Premium Blogger Templates | PBT | Powered by Blogger |-| About | Privacy Policy | Sitemap | Contact | Disclaimer