PROC SQL in SAS | PROC SQL All in One | A Complete Guide to Proc SQL in SAS

Video Description

After learning the SAS Base it is important to take your skills to next level and this is where this video helps you learn the PROC SQL from basic to advance level. This video covers the following topics: ► What is PROC SQL in SAS ► How to write the PROC SQL statement/statements ► What is SELECT and FROM statement in PROC SQL ► What comes in SELECT and what comes in FROM when you write a PROC SQL statement in SAS ► Selection all/one/multiple columns from a table using SELECT and FROM CLAUSE ► Selecting based on conditions. Using WHERE clause in PROC SQL to filter the data ► Summarizing the data of a table based on some specific variables. Using GROUP BY clause in PROC SQL to summarize the data ► Filter the data post summarization in PROC SQL. Filter on the variable calculated in the query. Using HAVING clause in PROC SQL to filter the data ► Sorting in PROC SQL. Using ORDER BY clause in PROC SQL. ► Introduction to CASE WHEN statement ► Simple use of Case When to Create a Variable/Column Based on One Variable ► Multiple Case When or Nested Case When to Create a Variable/Column using one Variable or Column ► Using Case When Statement on More Than One Variable to Create a Column or Variable ► Introduction to PROC SQL ► List of the Summary Functions Used in PROC SQL ► COUNT, FREQ, N to Take the Count of Non-Missing Observations ► MIN to Find the Minimum Value in a Given Numeric Variable ► MAX to Find the Maximum Value in a Given Numeric Variable ► AVG, MEAN to Find the Average/Mean Value of a Given Variable ► RANGE to Find the Range of a Category on Given Numeric Variable ► STD to Find the Standard Deviation of a Category on Given Numeric Variable ► SUM to Find the Total by a Category of a Given Numeric Variable ► Grouping on More Than One Variable or Summarizing on More Than One Variable ► Introduction to Joins in PROC SQL in SAS ► Type of Joins Used in PROC SQL SAS ► LEFT Join to Merge/Join Two/More Tables in PROC SQL in SAS ► RIGHT Join to Merge/Join Two/More Tables in PROC SQL in SAS ► INNER Join to Merge/Join Two/More Tables in PROC SQL in SAS ► FULL Join to Merge/Join Two/More Tables in PROC SQL in SAS ► Summary or an Overview of All The Joins in PROC SQL in SAS ► Introduction to Joins in PROC SQL in SAS ► Type of Joins Used in PROC SQL SAS ► LEFT Join to Merge/Join Two/More Tables in PROC SQL in SAS ► RIGHT Join to Merge/Join Two/More Tables in PROC SQL in SAS ► INNER Join to Merge/Join Two/More Tables in PROC SQL in SAS ► FULL Join to Merge/Join Two/More Tables in PROC SQL in SAS ► Summary or an Overview of All The Joins in PROC SQL in SAS ► Prerequisites to Merge or Join the Tables in SAS ► LEFT Join VS Merge in SAS ► RIGHT Join VS Merge in SAS ► INNER Join VS Merge in SAS ► FULL Join VS Merge in SAS #Learnerea #SASTraining #SASTutorial #SASCourse #SASTutorialForBeginners #SAS #SASforBeginners #SASProgramming #SASTProgrammingForBeginners #SASProgrammingTutorial Contacts: Facebook ► https://www.facebook.com/Learnerea Download the excel files for practice data GitHub ► https://github.com/LEARNEREA/Excel_Files