Ask the Expert Webinar Series

How Many Ways Can You Join SAS® Tables?

Oct. 19 • 11 a.m. ET • 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.

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

With a background in computer systems management, Charu engages with logic, visuals and analogies to spark critical thinking. A SAS instructor since 2007, she curates and delivers unique content via the SAS YouTube channel, SAS events, Ask the Expert series, SAS Training blog and more. Charu 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, SAS Viya and more. When not coding, Charu is a yoga instructor who loves to explore Canadian trails with her rescue husky, Miko.

Register now