I'm very new at SAS Guide, and I didn't find nothing to solve my problem.   I need to do a PROC SQL that inserts a few data into a sas table from an oracle table.   It works fine for many tables. But I have some tables that are repeated in some schemas and I would like to reuse the same program, inputing the schema as a param.   Example:     PROC SQL; SELECT VAL INTO:var_val FROM PARAM WHERE DESCRIPTION = 'somevalue'; CONNECT TO ORACLE (PATH=ORACLEDB USER=XXX PASSWORD=YYY); INSERT INTO    MYTABLE       (ColumnA)    SELECT       ColumnA    FROM       CONNECTION TO ORALCE(          SELECT             ColumnA          FROM             &var_val.table_oracle ); QUIT;             It doesn't work because variable &var_val is substituted with apostrophes. I hope that exists something like an "EXEC" command that I could tranform my query in a complete string, and execute after substituation.     Is there some way to do what I need?       thks! ... View more