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-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 2752 views
  • 1 like
  • 2 in conversation