July 2018
Beginner
536 pages
12h 32m
English
Chapter 26: Introducing the Structured Query Language
26.3 Joining Two Tables (Merge)
26.4 Left, Right, and Full Joins
26.7 Demonstrating the ORDER Clause
26.8 An Example of Fuzzy Matching
PROC SQL (structured query language—usually pronounced sequel) offers an alternative to the DATA step for querying and combining SAS data sets. There are some tasks that PROC SQL can perform much better and easier than the DATA step. Other tasks may be easier or more efficient using a DATA step. You may also be more familiar with SQL versus the DATA step or vice versa. The best advice is to learn both and use the tool that ...