Hello! I'm new with SAS program and quite confuse with the code. I have a problem with macro function and not sure that sas can work as I want. I want to create many tables with different conditions by creating each table from their value in symbol, Date and interval. (each table should to be named from their determined condition) So, I try the following code but it doesn't work. %macro test; PROC SQL; CREATE TABLE &sym&dd&int AS SELECT t1.Symbol, t1.Date, t1.Time, t1.interval FROM E9count t1 WHERE t1.Symbol = "&sym"; t1.Date= "&dd"; t1.interval="&int" QUIT; %mend test; %let sym=A %let dd=16/04/2009 %let int=1; %test %let sym=A %let dd=16/04/2009 %let int=2; %test %let sym=B %let dd=01/05/2009 %let int=1; %test I'm sure that I miss somthing but don't know how to fix it. Thx in advance.
... View more