SAS® SQL 1: Essentials Duration: 14 hours SQL1 : SQ1M6
This course teaches you how to process SAS data using Structured Query Language (SQL). Learn How To Query and subset data. Summarize and present data. Combine tables using joins and set operators. Create and modify tables and views. Create data-driven macro variables using a query. Access DBMS data with SAS/ACCESS technology.Who Should Attend SAS programmers and business analysts Prerequisites Before attending this class, you should be able to do the following:; Submit SAS programs on your operating system. Create and access SAS data sets. Use arithmetic, comparison, and logical operators. Invoke SAS procedures.;You can gain this experience from the SAS Programming 1: Essentials course. No knowledge of SQL is necessary.SAS Products Covered Base SAS Course Outline Essentials Setting up for this course.Overview of SAS Foundation.Course logistics.Course data files.Introducing the Structured Query Language.Overview of the SQL procedure.Exploring tables.Specifying columns.PROC SQL FundamentalsSubsetting data.Presenting data.Summarizing data.Creating and managing tables.Using DICTIONARY tables.SQL JoinsIntroduction to SQL joins.Inner joins.Outer joins.Complex SQL joins.SubqueriesNoncorrelated subqueries.Correlated subqueries.In-line views.Creating views with the SQL procedure.Subqueries in the SELECT clause.Remerging summary statistics.Set OperatorsIntroduction to set operators.The INTERSECT operator.The EXCEPT operator.The UNION operator.The OUTER UNION operator.Using and Creating Macro Variables in SQLInterfacing PROC SQL with the macro language.Creating data-driven macro variables with a query.Using macro variables in SQL.Accessing DBMS Data with SAS/ACCESSOverview of SAS/ACCESS technology.SQL pass-through facility.SAS/ACCESS LIBNAME statement.PROC FedSQL.
Live Instructor Dates SOLD SEPARATELY |
---|
DATES ▼ | LOCATION ▲ ▼ | TIME ▲ ▼ | LANGUAGE | EVENT FEE | |
---|
09-13 DEC 2024 | Live Web, US | 1:00 PM-4:30 PM EST | English | 1,600 USD | | 06-07 JAN 2025 | Live Web, US | 9:00 AM-5:00 PM EST | English | 1,600 USD | | 27-31 JAN 2025 | Live Web, US | 1:00 PM-4:30 PM EST | English | 1,600 USD | | 03-07 MAR 2025 | Live Web, US | 1:00 PM-4:30 PM EST | English | 1,600 USD | | 03-04 APR 2025 | Live Web, US | 9:00 AM-5:00 PM EDT | English | 1,600 USD | | 01-02 MAY 2025 | Cary, NC, US | 9:00 AM-5:00 PM EDT | English | 1,600 USD | | 12-16 MAY 2025 | Live Web, US | 1:00 PM-4:30 PM EDT | English | 1,600 USD | | 09-13 JUN 2025 | Live Web, US | 1:00 PM-4:30 PM EDT | English | 1,600 USD | | 10-11 JUL 2025 | Live Web, US | 9:00 AM-5:00 PM EDT | English | 1,600 USD | | 11-15 AUG 2025 | Live Web, US | 1:00 PM-4:30 PM EDT | English | 1,600 USD | | 15-19 SEP 2025 | Live Web, US | 1:00 PM-4:30 PM EDT | English | 1,600 USD | | 02-03 OCT 2025 | Live Web, US | 9:00 AM-5:00 PM EDT | English | 1,600 USD | | 13-17 OCT 2025 | Live Web, US | 1:00 PM-4:30 PM EDT | English | 1,600 USD | | 17-21 NOV 2025 | Live Web, US | 1:00 PM-4:30 PM EST | English | 1,600 USD | | 08-12 DEC 2025 | Live Web, US | 1:00 PM-4:30 PM EST | English | 1,600 USD | |
|