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