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 ...

As a result, you can now create a PROC SQL view, DATA step view, or SAS/ACCESS view with DBMS data. For this example you create a view descriptor, VLIB.ALLEMP, based on SYBASE data. The outer PROC SQL ...