Most Useful SAS FUNCTIONS in your daily work for beginners

Section2 - SAS Character Functions. In this lecture, we are going to learn how to extract substring from a character string. We will learn two functions : substr and scan. We will learn when each one is used, what the disadvantages and advantages are. In addition, we will also learn functions, that calculate the length of the string, such as length, lengthc and lengthn, and see how can they help us to extract substring. At the end, we will talk about left and right functions.

Section2 - SAS Character Functions. In this lecture, we are going to costruct Unigrams from restaurant reviews . N-gram models are widely used in statistical natural language processing, NLP. In order to meet the goal, divide each review into words, we need to learn quite a few functions.  We will learn, how to calculate the number of words in each review, how to extract each word in the review, how to remove or replace specific characters from a character string and last, how can we change the capitalization of text. This lecture will be very interesting.

Section2 - SAS Character Functions. In this lecture, we are going to talk about, how can we concatenate strings and numeric values. We are going to learn concatenation operator, trim and strip functions, that removes leading and trailing blanks, but also learn cat's family functions, that do the same job as concatenation operator, but more comfortable to use. cat's family functions consist of four functions : cat, cats, catx, catt.

Section2 - SAS Character Functions. In this lecture, we are going to talk about, how can we search for a specific substring of characters within a character string. We are going to learn two functions : find and index  functions. As you will see, both functions do the same, but find function more flexible. She has much more parameters to control the search.

Section2 - SAS Character Functions. In this lecture, we will focus on two functions : put and input. These functions are very important and you will use it a lot. They convert variable type, from numeric to character and vice versa, from character to numeric. I will illustrate most uses of these functions with examples.

Section3 - SAS Date & Time Functions. In this lecture, we are going to learn most basic date / time / datetime functions. Although they are basic functions, you will use them all the time. We will learn functions that return  date / time / datetime values, such as mdy, hms, dhms and today functions. But before we learn the functions, I will explain how date / time / datetime work in SAS. We will talk about how can we declare date / time/ datetime constants.

Section3 - SAS Date & Time Functions. In this lecture, we are going to learn how can we extract "parts" from date, time or datetime values. This is most simple and basic SAS functions, you have to know, because you are going to use them almost all the time. We are going to learn five date functions that extracts month, day, year, weekday and qtr functions. Three time functions such as hour, minute and second. And two functions that works with datetime values, datepart function that extract date value, and timepart function, that extract time value.

Section3 - SAS Date & Time Functions.  This video is introduction to SAS Interval functions. We are going to learn very popular and powerful functions, that asked a lot during job interviews. What is SAS Interval Functions? For example, these functions can determine how long a period has elapsed between two time points. Or these functions can helps us  exactly to compute a person’s age. It should be very interesting.

Section3 - SAS Date & Time Functions. In this lecture, we start to learn SAS interval function. We are going to learn two functions, yrdif function that calculates the number of years between two dates, and datdif function, that calculates the number of days between two dates. As you will see, both functions are flexible and simple, and can calculate the number of years / days between two dates according to different specified day count conventions.

Section3 - SAS Date & Time Functions. In this lecture, we continue to learn SAS interval function and we are going to concentrate on intck SAS function, that calculates the number of time periods which have been crossed between two SAS dates, times or datetime. For example, the number of days or years that occur between two dates. This function is very popular and powerful SAS function, and you will certainly be asked about this function during the interview.

Section3 - SAS Date & Time Functions. In this lecture, we finish to learn SAS interval function and the last function we are going to focus is  intnx SAS function, that increments a date, time, or datetime value by a given time interval, and returns a date, time, or datetime value. In other words, this function advances a given date, time or datetime by a specified number of intervals. Intnx function can help us to answer the following questions, for example, When is the next Sunday? When was the last Friday? Or What would be date after fifteen weeks? As intck function, also intnx function  is very popular and powerful SAS function, and you will certainly be asked about this function during the interview.

Section4 -  Statistical and Mathematical SAS Functions. This lecture is introduction to section  "Statistical and Mathematical SAS Functions", The topics we are going to learn are:

1. Descriptive Statistics Functions

2. Truncation Functions

3. Random Number Generator

4. Probability Density & Cumulative Distribution Functions

5. Calculation of critical value and p-value

These are supposed to be fascinating and very important lectures

Section4 -  Statistical and Mathematical SAS Functions. In this lecture, we concentrate on descriptive statistics SAS functions. If you are going to calculate descriptive statistics horizontally, you should use these functions. We are going to learn 12 functions, such as n, nmiss, sum, max, min, mean, median, range, std, var, iqr and pctl functions.

Section4 -  Statistical and Mathematical SAS Functions. In this lecture, we are going to learn truncation functions. Truncation functions consist of 4 functions : ceil, floor, int and round functions. These functions can round a number up, round it down or round it to the nearest integer.

Section4 -  Statistical and Mathematical SAS Functions. In this lecture, we are going to focus on random number generator. We are going to talk, how can we generate random numbers from a variety distributions. Also we will talk about the process of generation random numbers. We are going to learn three functions : ranuni, rannor and rand.

Section4 -  Statistical and Mathematical SAS Functions. In this video, we are going to learn  probability density function(PDF) and cumulative distribution function(CDF) for a variety of distributions. We are going to define functions and learn to draw the distributions.

Section4 - Calculation of critical values and p-values. In this lecture, we are going to talk about functions, that know to calculate critical values and p-values. But before we drill down into the functions, i will present you some introduction to critical values and p-values, to remind you what it is.

To calculate critical values in SAS use quantile function. Quantile function allows you to calculate critical value for twenty four different distributions. Compared to calculation of critical value, where we used only one function for all distributions, in calculation of p-value, each distribution has its own function.

Section5 - You almost reached the end of the course  "Most Useful SAS Functions in your daily work for beginners".  You learnt more than sixty functions and now it's time to test the knowledge you learned in the course. I created three projects on real datasets, and you are asking to solve each of them. In this video, i remind you where you can find the instructions, datasets and solutions to the projects

Section5 - In this last video, I want to say thank you so much for choosing my course "Most Useful SAS Functions in your daily work for beginners". Thank you for spending your valuable time with me. In addition, in the Resources you can find the full list of my courses and I am happy to offer you all my courses at the most biggest discount Udemy allows me.