Managing and Querying Data Using Flows in SAS Studio
Duration: 10.5 hours
VSTI : VSTI32
Master managing and querying data with our introductory course on using steps in flows, an intuitive point and click tool that visualizes data pipelines in SAS Studio on the SAS Viya platform.
Learn How To
Access and manipulate data of various types.
Create queries that filter and sort data, compute new columns, and join multiple tables.
Enhance flows to boost productivity and efficiency.
Who Should Attend
Professionals seeking to leverage SAS Studio Basic, SAS Studio Analyst or SAS Studio Engineer for data access and preparation.
Prerequisites
No SAS experience is required, although proficiency in using a computer is essential.
SAS Products Covered
SAS Studio
Course Outline
Getting Started
SAS Viya Overview
SAS Studio Licensing
Using Flows in SAS Studio
Working with Data
Understanding Data
Understanding SAS Libraries
Using the Table Viewer in SAS Studio
Importing Unstructured Data Using SAS Studio
Exporting SAS Tables in SAS Studio
Transforming Data
Managing Columns Using SAS Studio
Filtering Rows Using SAS Studio
Sorting SAS Tables in SAS Studio
Calculating Columns in SAS Studio
Conditionally Calculating Columns in SAS Studio
Summarizing and Filtering Data by Groups in SAS Studio