BASE SAS Tip #9: PROC SQL Subquery vs. Inner Join; PROC SQL Join vs. Merge

This video shows you how to link two SAS datasets with some filters. Four major methods were summarized, including using a subquery, joining a dataset with an in-line view (view on the fly), joining two datasets, and a merge statement in a data step. Generally speaking, PROC SQL methods are preferred due to their efficiency in both coding and execution in a cohesive database environment that is more popular nowadays. #procsql #analytics #sql #sasmerge #sasdata