Proc SQL is not just about learning how Cartesian products are formed and how tables are joined. In this chapter, we will go beyond these concepts and learn about SAS views. SAS views is a concept that we will be mentioning for the first time in this book. Manipulating data and macros has already been discussed in this book at length. Now, we will look at the differences in coding in Proc SQL and how some output can be generated faster than it can be by using DATA steps. We will also see how powerful and unique some of the Macro options are in Proc SQL.
In this chapter, we will explore the following topics:
- SAS views in Proc SQL
- Manipulating data in Proc SQL
- Identifying duplicates using Proc SQL
- Creating an index in Proc SQL
- Macros in Proc SQL
