Tag: Read data in SAS

Example 8.33: Merging data sets one-to-many

It’s often necessary to combine data from two data sets for further analysis. Such merging can be one-to-one, many-to-one, and many-to-many. The most common form is the one-to-one match, which we cover in section 1.5.7. Today we look at a one-to-man…

Example 8.26: reading data with variable number of words in a field

A student came with a question about how to snag data from a PDF report for analysis. Once she’d copied things her text file looked like:1 Las Vegas, NV — 53.3 — — 12 Sacramento, CA — 42.3 — — 23 Miami, FL — 41.8 — — 34 Tucson, AZ –…