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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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