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.
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.
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.