Write a Temporary SAS Code for a SQL Query

david27 — Wed, 01 Mar 2023 20:03:39 GMT

I have this but i cannot put the ending bracket.

Can you please advise.

Thank You

options symbolgen mprint mlogic merror;
filename code temp;
data _null_;
   file code ;
  set sashelp.class(obs=10);
  if _n_=1 then put  "select name from sashelp.class where name in ("  @;
  else put ',' @;
  str = quote(strip(name),"'");
  put str ;
  if eof then put ");quit;";
run;
%macro tst_code;
proc sql;
%include code ;
%mend tst_code;
%tst_code;

Re: Write a Temporary SAS Code for a SQL Query

ballardw — Wed, 01 Mar 2023 20:12:03 GMT

You didn't provide a variable EOF that should indicate the end of the file.

  set sashelp.class(obs=10) end=eof;

The End= assigns end of data to the variable name following the =;

Without it your code 1) created a variable named EOF

2) with a missing value

and missing is never true so that put never occurred.

topic Write a Temporary SAS Code for a SQL Query in SAS Programming

Write a Temporary SAS Code for a SQL Query

Re: Write a Temporary SAS Code for a SQL Query