SAS users can leverage SQL-based queries via Proc SQL. Both data steps and Proc SQL can generate similar outputs. However, the complexity of the code may differ. The default output generated may also differ but that can be adjusted by specifying various options available in both methods. The process of getting results in both methods differs. We will focus on the process of getting things done in Proc SQL, compare data steps and Proc SQL, and look at the specific uses of Proc SQL.
In this chapter, we will cover the following topics:
- Comparing data steps and Proc SQL
- Proc SQL joins
- Proc SQL essentials
- Dictionary tables
