Structured Query Language (PROC SQL) is a database language found in the base-SAS software. It enables access to data stored in SAS® data sets or tables using a powerful assortment of statements, clauses, options, functions, and other language features. This hands -on workshop presents core concepts of this powerful language as well as its many applications, and is intended for SAS users who desire an overview of the capabilities of this exciting procedure. Attendees will explore the construction of simple SQL queries, ordering and grouping data, the application of case logic for data reclassification, the creation and use of views, and the construction of simple inner and outer joins.
Sample Programs:
conference:
Paper Type:
Hands On Workshop (HOW)
