Re: Proc SQL join - SAS Support Communities

Fluorite | Level 6

Fluorite | Level 6

Proc SQL join

Posted 12-05-2018 02:04 AM (1298 views)

hi team,

i want exact difference between left right and full join in proc sql with simple examples?

can any one help me?

3 REPLIES 3

Tourmaline | Level 20

Tourmaline | Level 20

Re: Proc SQL join

Posted 12-05-2018 02:15 AM (1291 views) | In reply to ravindra2

What do you mean by exact difference? Are you looking for code examples?

The DATA to DATA Step Macro
Blog: SASnrd

Fluorite | Level 6

Fluorite | Level 6

Re: Proc SQL join

Posted 12-05-2018 02:17 AM (1289 views) | In reply to PeterClemmensen

yes code example and explanation

Super User

Super User

Re: Proc SQL join

Posted 12-05-2018 02:54 AM (1282 views) | In reply to ravindra2

Everything you need to know about SQL joins can be found (Maxim 1) in the SQL Procedure Documentation, including examples.

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

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!