Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
6 Hour(s) 58 Minute(s)
Language
English
Taught by
Büşra Fenerci
Rating
2 views
Course Overview
Learn Data Transformation with SAS. Clean dirty data with SAS. Analyse your data with SAS. Lots of SAS Practices !
What are we going to learn in this course?
Firstly we are going to download and install SAS University Edition which is totaly free.
We will convert Excel tables to SAS tables.
We will write lots of SAS functions and create new variables/columns.
We will write SQL scripts also, and we will compare SAS and SQL codes.
We will join different tables, and filter&sort tables.
We will create graphs easily.
Creating meaningful data is the first step for the all data processes. If you want to create a model, apply data mining model, you have to apply this step firstly.
If you want to become a data engineer or data scientist, this course is really helpful.
You can understand and analysis data with some basic and easy functions in SAS which will be explained in the lesson.
Then you can manipulate data, impute missing variables and create new columns, merge different tables with SAS.
At the end of the course, you can apply all techniques to create clean and meaningful data with SAS.
Lots of functions and examples are applied in this course, if you have any question about a function, I can answer you quickly and also you can suggest new topics or functions to me. Lots of additions will be done in this course.
Course Content
- 10 section(s)
- 93 lecture(s)
- Section 1 Introduction
- Section 2 SAS Variable Types
- Section 3 Import and Export Tables in SAS
- Section 4 Filter and Sort SAS Tables
- Section 5 SAS Functions
- Section 6 If-Else Conditions
- Section 7 SAS Procedures
- Section 8 Join / Merge SAS Tables
- Section 9 Using SQL in SAS
- Section 10 Creating Charts and Plots
What You’ll Learn
- You can do data analysis easliy.
- You can transpose your data, add new calculated columns.
- You can delete some values in your data, and impute them also.
- After you finish this course, you can start applying data mining techniques and create data models.
Reviews
-
SSapphire Cudjoe
The course is outdated and the audio is terrible. First, the SAS download in voice box is not applicable because the software is no longer supported. Second, the audio is high pitched and grating, it sounds as if a wind screen wasn't used to reduce the sharpness of the P's and S's. The speaker has a thick accent and poor grammar which makes it a little more difficult to understand.
-
MMaria Guadalupe Garcìa Rodriguez!
I really like the course, but I think could be better if were more test/tast to practice :), The audio is not so bad, but i think could be better. Thanks.
-
WWilliam Morrow
The topics covered and the interactive nature of the course was really useful. The way she kept demonstrating the subject matter and reinforcing the material really made it stick.
-
KKirsty Craig
The screen shots in the videos so far are all out of focus so I can't see what the presenter is referring to.
