The LIBNAME Statement for Relational Databases

SQL_OJ_ANSI= LIBNAME Option

Specifies whether to pass ANSI outer-join syntax through to the database.

Default value:	NO
Valid in:	SAS/ACCESS LIBNAME statement
DBMS support:	Sybase

Syntax

SQL_OJ_ANSI=YES | NO

YES: specifies that ANSI outer-join syntax is passed through to the database.
NO: disables pass-through of ANSI outer-joins.

Sybase can process SQL outer joins only if the version of the Adaptive Server Enterprise (ASE) database is 12.5.2 or higher.