|
Replies:
0
-
Pages:
1
|
|
|
Posts:
1
Registered:
1/17/12
|
|
|
|
Macro variables
Posted:
Jan 17, 2012 3:14 AM
|
|
|
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:
%let age=25;
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?
Please help!
Thanks!
Marijana
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
