The asterisk (*) in the SELECT statement indicates that all the columns in VLIB.PRODUCT are ... which is based on data contained in the EMPLOYEES table. proc sql undo_policy=none; insert into ...

Views in DICTIONARY Tables lists all of the permanent PROC SQL views in the SASHELP library ... other SAS procedure, or the DATA step. SASHELP.VCATALG create view sashelp.vcatalg as select * from ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...