O'Reilly logo

The Little SAS Book: A Primer, Fifth Edition, 5th Edition by Susan J. Slaughter, Lora D. Delwiche

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix Coming to SAS from SQL

If you already know Structured Query Language (SQL), then you will be pleased to know that you can use SQL statements in SAS programs to create, read, and modify SAS data sets. There are two basic ways to use SQL with SAS:

  • You can embed complete SQL statements in the SQL procedure.
  • You can use WHERE statements or WHERE= data set options to select rows in standard SAS DATA and PROC steps.

Both of these features are available with Base SAS, so you don't have to license any other SAS software to use SQL.

Terminology Terms such as table, row, and column that originated with relational databases are now standard SAS terms also. However, other terms can also be used with SAS. To help you understand SAS terminology, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required