DATA Step, Macro, Functions and more

inner join

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

inner join

Hi All,

 

can u please suggest me on this as i was confused evry time.

what would be the minimum and maximum number of records if i use inner join between two tables .?

and is duplicate values impact on that count?

 


Accepted Solutions
Solution
‎05-16-2017 09:50 AM
Super User
Posts: 17,784

Re: inner join

Yes duplicates will affect number. 

Inner means records are in both data sets so the minimum is 0 - which is no overlap. 

The maximum is N1XN2 as a CROSS JOIN. So in the INNER join case this information is not that helpful. 

View solution in original post


All Replies
Solution
‎05-16-2017 09:50 AM
Super User
Posts: 17,784

Re: inner join

Yes duplicates will affect number. 

Inner means records are in both data sets so the minimum is 0 - which is no overlap. 

The maximum is N1XN2 as a CROSS JOIN. So in the INNER join case this information is not that helpful. 

Occasional Contributor
Posts: 12

Re: inner join

Thank You Soooo MUCH @Reeza .

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 93 views
  • 0 likes
  • 2 in conversation