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
In the field of finance, we are mostly interested in analyzing stock returns and for that, we need to understand how to calculate stock returns in Stata. In this tutorial, we are going to look into the code of calculating daily, weekly, monthly, and yearly stock returns. Download Example File Daily Stock return There are
Very often we obtain datasets that are saved inside a zipped folder owing to them being email attachments or generally large files. Such files are typically unzipped using software like WinRAR, 7-Zip or Windows’ built-in decompression tool. These compressed files are saved with a .zip or some other extension. We can save time by directly
