is any SAS name that serves as an alias to associate the SAS System with a database, schema, server, or group of tables and views. are options that you specify to connect to ORACLE. If the connection ...

In some SAS/ACCESS interfaces, you can issue an EXECUTE statement directly without first explicitly connecting to a DBMS (see CONNECT Statement). If you omit the CONNECT statement, an implicit ...

More like a.code + '%'. Just the right side, not both. Your original example was flawed in any event, as you'd have been looking for the literal word a.cidcode, not what was in the variable.