Parsing: Using SAS when the data is hiding in a nonstandard format

[#1]

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)