Execute SQL query stored in a table

PramodhG — Fri, 17 Aug 2018 21:18:06 GMT

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.

Re: Execute SQL query stored in a table

Patrick — Sat, 18 Aug 2018 00:28:02 GMT

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;

topic Re: Execute SQL query stored in a table in SAS Data Management

Execute SQL query stored in a table

Re: Execute SQL query stored in a table