cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

SAS Tip: Use a LEFT JOIN to save steps (Daily tip for 2024-Apr-24)

Using a left join with proc sql on multiple variables---may save multiple data steps..Proc sql. Left join. On A. member_id = B. member_id and A.product_code = B. product_code. Order by member_id, product_code;

Thanks to Brian Mitchell for this tip. Read more details in this paper from WUSS 2017: Zeroing in on Effective Member Communication An Rx Education Study.

READ this complete tip   Visit a random SAS tip

Start a topic
About these Tips
A "SAS tip" is a basic unit of information exchange between SAS users. The tips on this board come from sasCommunity.org, from SAS user conferences, from SAS blogs, and from freelance contributions from SAS users like you. We hope that you're able to always learn something new here!


» How you can contribute

Tip-o-meter: 80 tips

From Zero to SAS: Using SAS Studio to Summarize and Manipulate Your Data

Join this webinar to explore how nonprogrammers today use SAS Studio to accomplish many of the same data-cleaning tasks. Register for this free Ask the Expert webinar to learn more.

Premiering April 25, 11 am ET

Register Now