Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

In addition to using subselects to examine data in related tables, it’s also possible to use an aggregate function in a WHERE clause subselect to make a determination about the primary result set.

When you use the new names in the first SELECT statement, you can specify the names in any order. Add the NOLABEL option to the query to display the renamed columns. The PROC SQL SELECT statement uses ...

In Version 7, you can specify librefs based on DBMS data that you create by using the SAS/ACCESS LIBNAME statement. See Using DBMS Data in Version 7 and Version 8 for examples. If you are using ...