본문 바로가기

전산Tip/SAS

데이타셋이 생성 될때까지 무한루프 돌기

반응형



rsubmit;
%macro xxx;
        %let outtbl = temp2;
        proc delete data=&outtbl;run;
        %do %while( not %sysfunc(exist( &outtbl )) );    

                proc sql;
                     connect to odbc(user=&cid password=&cpwd dsn=RMTM1); 
                     create table &outtbl as
                     select * from connection to odbc
                  (
                          select count(*) as cnt
                                from  테이블1
                          where  기준년월 = '200912'
                  );
                     disconnect from odbc;
                quit;

                %let u=%sysfunc(sleep(2,10));
        %end;
%mend;
%xxx;
endrsubmit;