Solved: Re: Cannot join by the same key - Page 2 - SAS Support Communities

☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.

Super User

Super User

Re: Cannot join by the same key

Posted 08-02-2025 08:07 AM (266 views) | In reply to SASdevAnneMarie

It‘s a combination of the k, a and d modifier.

Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
The macro for direct download as ZIP
How to post code
Please vote for Provide Sequential Search Capability for Hash Objects
How to deal with locked files on UNIX

Super User

Super User

Re: Cannot join by the same key

Posted 08-03-2025 01:19 AM (243 views) | In reply to SASdevAnneMarie

Kurt already gave you the answer.
'kad' stands for Keep Alphabet Digit characters, and get rid of others characters.

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!

Call for Content EXTENDED

Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.

Submit your proposal!