SAS Adv Training Program

Generate Detail Reports by Working with a Single Table, Joining Tables, Or Using Set Operators in SQL

• Use PROC SQL to perform SQL queries.

• Select columns in a table with a SELECT statement and FROM clause.

• Create a table from a query result set.

• Create new calculated columns.

• Assign an alias with the AS keyword.

• Use case logic to select values for a column.

• Retrieve rows that satisfy a condition with a WHERE clause.

• Subset data by calculated columns with the CALCULATED keyword.

• Join tables - inner joins, full joins (coalesce function), right joins, left joins, cross

• joins.

• Combine tables using set operators - union, outer join, except, intersect.

• Sort data with an ORDER BY clause.

• Assign labels and formats to columns.

Generate Summary Reports by Working with a Single Table, Joining Tables, Or Using Set Operators in The Sql.

• Summarize data across and down columns using summary functions (AVG,

• COUNT, MAX, MIN, SUM).

• Group data using GROUP BY clause.

• Filter grouped data using HAVING clause.

• Eliminate duplicate values with the DISTINCT keyword

Construct Sub-Queries and In-Line Views Within an SQL Procedure Step

• Subset data by using non-correlated subqueries.

• Reference an in-line view with other views or tables (multiple tables).

Use Special Features of the SQL Procedure.

• Use SAS data set options with PROC SQL (KEEP=, DROP=, RENAME=,

• OBS=).

• Use PROC SQL invocation options (INOBS=, OUTOBS=. NOPRINT,

• NUMBER)

• Use PROC SQL with the SAS Macro Facility to create macro variables with the

• INTO keyword.

• Use SAS functions (SCAN, SUBSTR, LENGTH).

• Access SAS system information by using DICTIONARY tables (members,

• tables, columns)

Create and Manipulate SAS Date Values

• Explain how SAS stores date and time values.

• Use SAS informants to read common date and time expressions.

• Use SAS date and time formats to specify how the values are displayed