topic Re: Study materials for Sas Viya reporting in New SAS User

Study materials for Sas Viya reporting

jejobo2340 — Wed, 01 Dec 2021 10:33:21 GMT

Hi everyone,

I am a beginner with SAS world and I want to find study materials for myself. I would like to learn everything related to data preparation(ETL) in SAS Viya in order to perform all the transformations on tables and prepare them for the SAS report (but for now I am not interested in the report preparation itself) .

I saw some videos on youtube showing data preparation like this one, but I afraid using the GUI for creating the transformations is not enough in real-world scenarios where the transformations become complex.

So my idea is to master the data preparation first and then learn the reporting part (like this video) which seems much easier.

So can someone suggest a comprehensive study material for the data preparation? maybe I need to learn Sas coding first, I saw many books related to coding but I did not find one showing the coding skill in the SAS Viya environment, not the SAS studio alone.

Cheers

update: I also need to learn how to use data modeling techniques such as creating a star schema model in SAS Viya.

Re: Study materials for Sas Viya reporting

Cynthia_sas — Wed, 01 Dec 2021 15:50:09 GMT

Hi:
We have a class on self-service data preparation in SAS Viya, you will find the course nformation here:
https://support.sas.com/edu/schedules.html?id=18401&ctry=US -- this is a 2 day class, which represents in-depth training on Data Preparation in SAS Viya, so it is more detailed than a YouTube video.

To learn about Programming in SAS Viya, using SAS Studio, you would look at this course, entitled Programming with SAS Viya, here: https://support.sas.com/edu/schedules.html?crs=PGVIYA&ctry=US and the more advanced
High-Performance Data Processing with CASL in SAS Viya class, shown here: https://support.sas.com/edu/schedules.html?crs=CASL&ctry=US

Be sure to look at the prerequisites tabs on both pages because they will show you what basic level of SAS knowledge you need before taking these classes.

When you are ready to dive into reporting, we would recommend the Visual Analytics 1 and Visual Analytics 2 classes, which you'll find on this learning path: https://support.sas.com/training/us/paths/va.html -- just click on a course title to drill down to the web page for the course, so you can see what's covered.

Cynthia

Re: Study materials for Sas Viya reporting

jejobo2340 — Wed, 01 Dec 2021 17:12:18 GMT

Thank you Cynthia for the info.

I am more comfortable learning with books so I ask if there are any books that fulfill my requirements written in the first post.

Re: Study materials for Sas Viya reporting

Cynthia_sas — Wed, 01 Dec 2021 17:17:48 GMT

Hi:
When you take our classes you get course notes in PDF format for after-class study. Otherwise, your options are to print the documentation PDF files or look in the RedShelf bookstore for books.
Cynthia

Re: Study materials for Sas Viya reporting

jejobo2340 — Thu, 02 Dec 2021 08:52:22 GMT

I would like to have a more specific suggestion about the books in the Redshelf. Any book talking about data modeling in Sas explaining how to create star schema for instance?

I didn't find any basic level book about SAS viya that explain the SAS programming from a beginner's level.

Re: Study materials for Sas Viya reporting

Cynthia_sas — Fri, 03 Dec 2021 03:59:17 GMT

Hi:
Basically, when you use SAS Studio on the SAS Viya platform, the assumption is that you already know SAS programming. So SAS Viya books won't contain an introduction to SAS programming. They will assume that you already know the basics of writing a SAS program and accessing data (such as we teach in the Programming 1 class) and then, once you know those basics, the books/classes on SAS Viya will explain how to change your basic programs to run on the SAS Viya platform.
Cynthia