Hi, I'm new in Toad and i need help. I have some experiance in writing MySQL in SAS Enterprise Guide. There I could make some macro variables which I could use in a lot of queries, for example:
proc sql; create table old25 as select * from table where old=&age; quit;
proc sql; create table younger as select * from table where old<&age; quit;
How can I do that in Toad? I have values which are repeated 10 times or more and I don't want to write them every of that 10 times..... I have found something about bind variables (a have to declare them) but then some window is oped and I have tu put the wright value in it - again 10 times. How can I avoid that?