How to convert string to numeric data in Stata| Destring in Stata
In stata sometimes when we donwload data from web or import it from csv or excel file it is in string or text format. This video explains how to convert text variable into numeric form in state.
Download exercise file:
https://payhip.com/b/UCkle
00:00 Intro to Destring
1:50 Convert string to numeric
5:52 Syntax of command
7:51 Remove dollar sign from numbers
8:44 Remove text (NULL,NA etc) from variable
11:17 Convert percentages into fractions
Download Do/Data file from the following link:
https://thedatahall.com/how-to-conver...
Best 10 Introductory Econometrics Books
https://thedatahall.com/best-10-intro...
Econometric Analysis of Cross Section and Panel Data by Jeffrey M. Wooldridge
https://amzn.to/4220RUA
Introductory Econometrics for Finance by Chris Brooks
https://amzn.to/3HwmOmM
An Introduction to Modern Econometrics Using Stata by Christopher F. Baum
https://amzn.to/42prKBT
Microeconometrics Using Stata by A. Colin Cameron and Pravin K. Trivedi
https://amzn.to/42ra88r
Website: thedatahall.com
Disclaimer: Some links are affiliate links that help the channel at no cost to you.