I am trying to collect the data from the SQL server. Because, I would need to repeat it for many times, I have to write a macro like the following: %macro _input (table=, input=); PROC SQL; CONNECT TO xxxx as xxxx (NOPROMPT= "DSN=xxxx;SERVER=xxxx;UID=;PWD=; DATABASE=xxxx"); CREATE TABLE website.&table. AS SELECT * FROM CONNECTION TO xxxx (&input.); QUIT; %mend; where xxxx is the connection information to the SQL server. Table is just the table name and input would be sth. like Select abc, sum(def) as ddd from abc where abc like '%bb%' group by abc I put all the data into the table and try to run the macro but it fail. I would like to know is it possible to put the whole SQL script as an input value of a macro.
... View more