CODEWITHSUNDEEP
sqlsas
JCP
JCP

Reputation: 19

SAS Proc SQL join

I need help underdstanding a proc sql code in SAS as below: what kind of join are they doing here?

PROC SQL;
CREATE TABLE ACO AS  (
SELECT DISTINCT
ID,
c.OUTID
Reason
FROM s.cr             A
JOIN s.os            C        on a.AId = c.AId ;
quit();

Thank you in advance.

Upvotes: 0

Views: 323

Answers (1)

Richard
Richard

Reputation: 27508

A JOIN operator with no other qualifier is an INNER JOIN.

Read more in the documentation

Upvotes: 1

Related Questions