Ask the Expert Webinar Series

How Many Ways Can You Join SAS® Tables?

On-Demand • Cost: Complimentary

About the webinar

Why join data?

IT systems seldom store all data in one massive table, because it would result in extreme maintenance costs for the IT department. That’s why tables tend to be split up into smaller entities.

Enter the business need for joins, which are a means to access two or more tables to help answer business questions.

This presentation will describe various join algorithms and attempt to address comparisons between them.

You will learn about:

  • PROC SQL join with pass-through-implicit and explicit.
  • PROC FEDSQL join in SAS® Viya®.
  • Data step hash join.
  • Data step merge.

This webinar is the first in a two part series. To register and watch part two click here.

Have a SAS profile? To complete this form automatically Sign In

*
*
*
*
 
 
*
*
 
 
 Yes
 No

All personal information will be handled in accordance with the SAS Privacy Statement.

 
  Yes, I would like to receive occasional emails from SAS Institute Inc. and its affiliates about SAS products and services. I understand that I can withdraw my consent at any time by clicking the opt-out link in the emails.
 
 

About the Expert

Speaker 1

Charu Shankar
Senior Technical Training Specialist, SAS

Charu Shankar has a background in computer systems management, and she engages with logic, visuals and analogies to spark critical thinking. A SAS instructor since 2007, Shankar curates and delivers unique content via the SAS YouTube channel, SAS events, SAS Ask the Expert Series, SAS Training Post blog and more. She is a popular speaker at SAS users group conferences and has helped train thousands of SAS users on topics related to SAS, SQL, efficiencies, PERL, macros, Python and Viya, among others.

Register now