BookmarkSubscribeRSS Feed
sqlGoddess
SAS Employee

Hi SAS Programming Community,

I’m presenting a live “Ask the Expert” webinar on October 19th, 11 AM – Noon ET entitled How Many Ways Can You Join SAS® Tables? I’ll cover various join algorithms and attempt to address comparisons between them. Bring your questions. I’ll host a live Q&A session at the end of the webinar.

 

You will learn about:

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

Reserve your spot for the webinar.

 

Want more tips? Be sure to subscribe to the Ask the Expert board to receive follow up Q&A, slides and recordings from this and other SAS Ask the Expert webinars.

 

Can't join the live event? You can view this and other Ask the Expert sessions on-demand here.

2 REPLIES 2
ballardw
Super User

No Set / Point in the data step?

sqlGoddess
SAS Employee

OH Yes! that's a good tip. a lot to unpack in merge & your question prompts me to include this topic in a new paper I;m about to write. Will post it once done. thanks for asking

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 2041 views
  • 1 like
  • 2 in conversation