Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement.

You may want to view the contents of DICTIONARY tables to see information about your current SAS session, prior to actually using the table in a SAS DATA step or a SAS procedure. Because DICTIONARY ...