Hello everybody, I have a external file as a txt. file. Inside the file there is a proc SQL Statement. My Textfile looks like: proc SQL;
select * from afdeb.dbdb01eg;
quit; Now I want to replace the 01 inside the table name as a macro variable like afdeb.dbdb&_xx.eg. I know if I want to replace macro variables in external files I have to work with double quotes like afdeb.dbdb"&_xx."eg. But it only works outside a name. For your understanding: I have tables with generations. 01 is the current month, 02 the month before and so on. My plan is to increment the generations to get all data. The SQL Statement lays on a Server in a text file. Is it possible to resolve a macro variable in a external file inside a name? Many thanks for your help!
... View more