This course provides training on the generic aspects of how SAS connectivity works, including independent modules covering connectivity to specific data sources and connectivity in specific computing environments. Material will continue to be added to this course over time.
Learn How To
Use database tables just like SAS data sets to read and write database tables in your SAS code that executes in SAS 9 or on the SAS Viya Compute Server. Use database tables like any other caslib data source to load database tables into CAS in-memory tables or to save CAS tables to database tables. Write SAS code that optimizes performance when working with database tables by maximizing in-database processing before returning results to SAS for further processing. Write SAS programs that contain native database SQL code that is submitted directly to the database for execution in database and return any native query results to SAS for further processing in SAS 9, on the SAS Viya SAS Compute Server, or on the SAS Viya CAS server.
Who Should Attend
The generic material is for anyone using SAS to access any database or other external data sources who needs to learn the general concepts. The more specialized material is for subsets of users who would like to discuss connectivity techniques in the context of the specific data sources and see examples.
Prerequisites
Before attending this course, you should have:;Completed the SAS Programming 1: Essentials course or have equivalent knowledge. Some familiarity with the SQL language. Completed the SAS SQL 1: Essentials course or have experience with database SQL programming. Completed the Accelerating SAS Code on the SAS Viya Platform course or have equivalent knowledge.
SAS Products Covered
SAS/ACCESS
Course Outline
Overview of SAS Connectivity to DatabasesArchitecture and data movement. Database access with SAS 9 and the SAS Viya Compute Server.Database access with the SAS Viya CAS server. Further Considerations for the SAS/ACCESS LIBNAME Method SAS/ACCESS LIBNAME overview.Combining database tables.Library views.Creating database tables. Implicit database pass-through with the FEDSQL and DS2 procedures. Further considerations for the SAS/ACCESS SQL pass-through method. Further Considerations for the SAS/ACCESS SQL Pass-Through Method SQL pass-through syntax and examples for several databases Metadata queries and data queries. Using an SQL pass-through query to create a SAS table or a SAS view. Submitting database data definition language (DDL) with SQL pass-through.FedSQL pass-through.Further Considerations for Using Data Connector CaslibsLoading database tables into CAS. Using the CASUTIL procedure to load and save database tables. Using the DATA step, CAS procedures, and PROC FEDSQL to read and write CAS tables into CAS. Using CASL to load and save CAS tables. Load and save performance tuning.
