GitHub

SQL Query (Insert Values).sql

INSERT INTO Pilot VALUES ('PEA001', 'Denny', 'Quaid', '1965', '1992', 'Senior Pilot', '36500', 18500, 'EA1709'); INSERT INTO Pilot VALUES ('PEA002', 'Julie', 'Choo ...
GitHub

insert_into_corporate_tables.sql

INSERT INTO branch_supplier VALUES(2, 'Uni-ball', 'Writing Utensils'); INSERT INTO branch_supplier VALUES(3, 'Patriot Paper', 'Paper'); INSERT INTO branch_supplier ...
Simon Fraser University

DICTIONARY tables

The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.
Simon Fraser University

joined-table

alias specifies an alias for table-name. sql-expression is described in sql-expression. table-name can be one of the following: the name of a PROC SQL table. the name of a SAS data view. a ...