Execute SQL query stored in a table

[PramodhG]

My SQL queries are stored in a table in teradata in a column name Qry.

Please let me know how i can read the Qry value to a variable and then execute the query in that variable.

[Patrick]

Here you go:

data sql_codes;
  code='select * from sashelp.class';
  output;
  stop;
run;

/* option 1 */
filename codegen temp;
data _null_;
  set sql_codes;
  file codegen;
  put code;
run;

proc sql;
  %include codegen / source2;
  ;
quit;

/* option 2 */
data _null_;
  set sql_codes;
  cmd=cats('proc sql;',code,'; quit;');
  call execute(cmd);
run;