What do you do when the data you need is hidden in a nonstandard source, like a text document? In this 22-minute video, independent consultant @KuligowskiAndre reveals techniques for when you're not dealing with cleanly formatted data. He'll walk you through an example in which data is found within a free-form text file.
Video highlights
01:06 - What is parsing?
03:35 - How to find, identify, keep or reject data points
07:32 - Debugging
13:29 - How to account for periods in text
16:57 - The role of the substring function
20:25 - Why you should clean your data
Read the Paper
Related resources
About the PARSE function (SAS documentation)
SAS Text Miner: overview of text parsing node (SAS documentation)
How to scrape data from a web page using SAS (blog post)
