PROC SQL - 2 | PROC SQL Clauses in SAS | SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY in PROC SQL

This video introduces you to the all most commonly used clauses in PROC SQL. After watching this you would have the good knowledge of HOW TO USE THE CLAUSES OF SQL and manipulate your data.

if you are interested in learning only a particular part of the video, feel free to use the below time frames to jump to the section which you are interested in learning:

00:39 - Learning agenda of the video
01:58 - Selection all/one/multiple columns from a table using SELECT and FROM CLAUSE
05:02 - Selecting based on conditions. Using WHERE clause in PROC SQL to filter the data
07:31 - Summarizing the data of a table based on some specific variables. Using GROUP BY clause in PROC SQL to summarize the data
12:09 - 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
15:45 - Sorting in PROC SQL. Using ORDER BY clause in PROC SQL.


#Learnerea
#SASTraining #SASTutorial #SASCourse #SASTutorialForBeginners #SAS #SASforBeginners
#SASProgramming #SASTProgrammingForBeginners #SASProgrammingTutorial

Contacts:
Facebook ► Facebook: Learnerea

Download excel file for practice data
GitHub ► https://github.com/LEARNEREA/Excel_Files

• #science_technology
• #proc_sql
• #select
• #from
• #where
• #group_by
• #having
• #order_by
• #proc_sql_clauses
• #sql_clauses