For a complete description of the PROC SQL statements, see SQL Procedure Pass-Through Facility Statements. CONNECT statement, see The following section describes the ORACLE-specific arguments that you ...
When you use the DBLOAD procedure to create a table, the procedure issues dynamic SQL statements to create the table and insert data from a SAS data file, DATA step view, PROC SQL view, or view ...
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.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback