ETL (extract, transform and load) is an integral process for data engineers to extract data from different sources, transform the data into a trusted resource, and load that data into systems that end users such as data scientists can use for computation and analysis. In all the buzz around analytics, ETL is often relegated to the background, but data scientists depend deeply on this solid foundational task before they can deep dive into analytics.
Come to this session to learn to leverage the power of the cloud to extract, transform and load data using SAS programs executed in the SAS Viya Compute Server. The good news is that if you are already programming in SAS®9, you’ll feel right at home in Viya!
You will learn to:
- Extract & transform data from a variety of data sources using SAS/ACCESS interface code;
- Transform and clean data prior to analysis; and
- Explore data using traditional SAS coding techniques, and then load data into SAS data sets, database tables or CAS tables for analysis.
Presented by Charu Shankar at SAS Explore 2023.
