Use of SQL language with SAS
Aims
The course covers the SQL procedure of SAS which uses the SQL language (Structured Query Language) for queries, manipulating and presenting data. The course will also cover syntax and functions, various query techniques for producing reports, logical views, tables and indices; multiple table queries, summary functions use and totalization.
Who should attend
Data Administrators, Business users, data warehouse architects.
Prerequisites
Basic experience in the use of the SAS language is required.
Course outline
- SQL organisation, uses and terminology
- SQL procedure functionalities, functions, rules and output
- Multiple queries and join
- Comparison of use of SQL and DATA Step SAS programs for joining tables
- Creation and use of tables and views
- Other Proc SQL functionalities
Duration
The duration of the course is 1 days.