This article goes over what scalars and matrices are and how to work with them in Stata. To illustrate the concepts, we will use Stata’s built in automobile dataset which can be loaded by using the following command: Download Example File sysuse auto.dta, clear What Are Scalars and Matrices Scalars can be defined as placeholders […]
Whenever you are working with more than one dataset, it is highly likely that you will need to combine them together to perform any analysis. In Stata, this is referred to as merging. There are different types of merges depending on the situation. Each type of merge is explained in its relevant sections. The topic
How to merge data in Stata | Combining datasets in Stata Read More »
In this article, we will learn how to convert categorical variables into numerical variables (Also look at destring and encode). Suppose we have a dataset on patients and the drugs they have been administered. If drugA is administered to a patient, the variable shows ‘yes’, if not, it shows a ‘no’. The following image depicts
This article is going to discuss how to combine multiple Excel data files into one Stata file. Let’s suppose we have 15 Excel files, each file with daily stock market data of one company. In order to combine data for all 15 companies in one file, we follow three steps: Download Example File Step 1:
How to Combine Multiple CSV/Excel Files in Stata Read More »
This article will delve into what outliers are, how we can identify outliers in Stata, and finally, how they can be treated in Stata. Defining Outliers Put simply, an outlier is a value/observation in a dataset that is either extremely high or extremely low as compared to other values/observations in a given dataset. The meaning
