请问一个关于SQL的select的问题

shiyiming

假如有个dataset sales的变量有num,sale200301,sale200301......sale200412，
我现在用带参数的宏来选择想要的变量,比如我想要sale200306--sales200406之间的变量：
%macro sale(month_s,month_e);
proc sql;
create table newsale as
select &month_s-&month_e ？？？
form sales;
%mend;
%sale(sale200306,sales200406)
上面那样肯定不行的，应该怎样才行呢？
Thx！！！

shiyiming

我晚上去打球，没时间给你写了，明天来，先看大家的程序。

shiyiming

[code:744da]%macro sale(month_s,month_e);
data newsale;
set sales;
keep &month_s - &month_e;
run;
%mend;
%sale(sale200306,sale200406);[/code:744da]

shiyiming

data sales;
input
sale200301 sale200302 sale200303 sale200304 sale200305 sale200306
sale200307 sale200308 sale200309 sale200310 sale200311 sale200312
sale200401 sale200402 sale200403 sale200404 sale200405 sale200406
sale200407 sale200408 sale200409 sale200410 sale200411 sale200412;
cards;
1 2 3 4 5 6 7 8 9 10 11 12 1 2 3 4 5 6 7 8 9 10 11 12
;
run;

%macro ahuige(down,up);
sale&down
%do i=%eval(&down+1) %to &up;
   %if 01<=%sysfunc(substr(&i,5,2)) and %sysfunc(substr(&i,5,2))<=12 %then ,sale&i;
%end;
%mend;



%macro sale(down,up);
proc sql;
create table newsale as
select %ahuige(&down,&up)
from sales;
%mend;

%sale(200306,200406)  

proc print;
run;

shiyiming

oh,thanks you tow guys! 昨晚还想请教collen的呢。
发觉学sas的人确实不多，多亏有论坛。

shiyiming

我编程的水平不比ahuige强到哪里，统计方面可以问我，shiyiming不太懂，呵呵， <!-- s:) --><img src="{SMILIES_PATH}/icon_smile.gif" alt=":)" title="Smile" /><!-- s:) -->