|
楼主

楼主 |
发表于 2012-2-10 10:04:58
|
只看该作者
求助 帮忙解释下呗 谢谢
%macro wzq;
%let wzq=;
%let id=%sysfunc(open(mart_tj.su7201_1));
%put id=&id;
%let _data=%sysfunc(varnum(&id,data));
%let _where=%sysfunc(varnum(&id,where));
%let _in=%sysfunc(varnum(&id,in));
%do %while(%sysfunc(fetch(&id)) eq 0);
%let data=%sysfunc(getvarc(&id, &_data));
%let where=%sysfunc(getvarc(&id, &_where));
%let in=%sysfunc(getvarc(&id, &_in));
%if "&where" ne '' %then %do;
%let mwhere=%str(where=(&where));%end;
%else %let mwhere=;
%if &in ne %then %do;
%let qwhere=%str(in=&in);%end;
%else %let qwhere=;
%do;
&data(&mwhere &qwhere)
%end;
%end;
%Str(;)
%let rc=%sysfunc(close(&id));
%put &rc;
%mend; |
|