The following example uses the alias DBCON for the DBMS connection (the connection alias is optional): proc sql; connect to oracle as dbcon (user=scott password=tiger buffsize=100 path='myorapath'); ...

This example accesses ORACLE data. First, you specify a PROC SQL CONNECT statement to connect to a particular ORACLE database that resides on a remote server. You refer to the database with the alias ...

With the Oracle dialect, when selecting a column alias from a deeply nested subquery, where the alias is longer than 24 characters, the alias in the outside select is truncated to 24 characters and ...

For balance sheets, the GL Account Alias is comprised of the BAL segment value plus the ORG segment. Balance Sheet Sample Alias: 213333333.000000001. Below is an example of the GL Account Alias ...