Welcome to the course Most useful SAS functions in your daily work for beginners. First of all, I want to say thank you for choosing to take this course. I sincerely hope you will like and enjoy this course. In my opinion, its most complete SAS course about the functions. In this course, you are going to learn a variety of SAS functions. We will cover more than 60 functions, and I will only concentrate on function that you need in your daily work. I divided the functions into three categories: Character functions, Date and Time functions, and Statistical and Mathematical functions.A few words about teaching method. I believe in practice. Therefore, during each lesson, you will have different assignments to see if you understand the material. I put a strong emphasis on practice. Moreover, at the end of the course, you will have three projects on real data. These projects should give you an indication of whether you have understood the SAS functions and are ready to implement them. This course has course folder, that you will download. You will find there all the material you are going to learn during the course. It contains all SAS programs we develop during the lessons. In addition you will find there instructions to projects, the real datasets you going to use during the projects and of course the solutions to the projects. What about the requirements of the course? You have to know only SAS Base. In simply words, you have to know data manipulation, write conditional statements, loops and no more than that. In this course, we are going to work on SAS Studio and sometimes called also SAS University Edition. This is free version, and if so far you have not downloaded it, dont worry. We will do it together. It’s pretty simple. Curriculum of the course: I divided the course into five sections: The first section is introduction. In this section, you are going to learn the content of the course. Another two lectures are about Installation & Familiarity with SAS University Edition. If you have SAS Studio and you got to work on it, you can skip these lectures and go straight to the video about downloading course folder. And in the last video of this section, we will download course folder and put it into SAS shared folder. As I said in the previous video, this folder contains real datasets for three projects, projects instructions and solutions, and of course, all the functions and examples, syntaxes of the functions, we are going to solve during the course. Last section, contains conclusions and discounts to my other courses. The rest three parts is a core of the course. In the second section, we are going to learn character functions. We will see, how to extract substrings from string, count the number of characters and words in the string, remove and replace specific characters in the string, how to concatenate character strings and numeric values, how to search a character expression within a string and how to convert numeric variable to character variable and vice versa. Third section concentrates on most useful date and time functions. We start from declaring constant date, time and datetime variables and after that, go straight to functions. We will learn most basic functions that returns date, time or datetime values based on parameters. We will also see, how can we extract parts from date, time or datetime values. We will also learn more complex SAS date, time or datetime functions that are asked in each job interview. These are Interval Functions. For example, these functions can determine how long a period has elapsed between two time points or advances a given date, time or datetime by a specified number of intervals. Fourth section dedicated to mathematical and statistical functions. We are going to draw distributions, generate random numbers from different distributions, round numbers. Also, we will talk about calculation of p-values and critical values and et cetera. Guys, you can ask me any questions you want during the course or even after you finish. I usually answer within a few hours, but no more than 24 hours. Thank you very
