Here is the one with proc export;


data t1;
   do i =1 to 5;
      sex='F';
      age=i*10;
      output;
    end;
   do i =1 to 3;
      sex='M';
      age=i*10;
      output;
    end;
run;

PROC EXPORT DATA = t1(where=(sex='F'))
  OUTFILE = "c:\downloads\test.xls"  dbms=excel2000  REPLACE;
  sheet='F';
RUN;

PROC EXPORT DATA = t1(where=(sex='M'))
  OUTFILE = "c:\downloads\test.xls"  dbms=excel2000  REPLACE;
  sheet='M';
RUN;

谢谢！按你这个思路 写个宏的话更方便一些 。。 7# bobguy

I find the people here love SAS macro.

9# bobguy
大批量数据还是用宏方便些  呵呵   只是对宏的了解不深  正在学习中

学习了，谢谢！