CODEWITHSUNDEEP
sasproc-sql
paolof89
paolof89

Reputation: 1359

SAS - What is the SQL language used in a PROC SQL?

I'm new to SAS and I'm using the PROC SQL functionality. I can not understand which is the sql language used in the PROC SQL.

It seems similar to Oracle-Sql but some functions are not available.

Can anyone clarify this point?

Upvotes: 1

Views: 1863

Answers (1)

Tom
Tom

Reputation: 51566

PROC SQL supports the ANSI SQL definition from 1992. You can also use most SAS functions.

International Organization for Standardization (ISO): Database SQL. Document ISO/IEC 9075:1992. Also, as American National Standards Institute (ANSI) Document ANSI X3.135-1992

http://support.sas.com/documentation/cdl/en/sqlproc/63043/HTML/default/viewer.htm#p0corah7t43hy7n1r7efplde5c8z.htm

Upvotes: 2

Related Questions