In this session, we will discuss about PROC SQL in SAS. PROC SQL is a powerful SAS procedure that combines the functionality of DATA and PROC steps into a single step. PROC SQL can sort, summarize, subset, join (merge), and concatenate datasets, create new variables, and print the results or create a new table or view all in one step. PROC SQL can be used to retrieve, update, and report on information from SAS data sets or other database products.
Note : This video courtesy is from my friends Shiv & Kiran who are SAS instructors.
#analyticsschool #sasprogramming #sasprogrammingtutorial #basesas #advancesas #procsql