Split Transformation

proc import datafile='C:\Documents and Settings\mobileclub\Desktop\source\xls\data1.xls' out=demo
dbms=excel replace;
sheet='Demo1$';
run;

proc export outtable=DM_m data=demo (where=(sex='M'))
dbms=access replace;
database='D:\dmm.mdb';
run;

proc export outtable=DM_m data=demo (where=(sex='F'))
dbms=access replace;
database='D:\dmf.mdb';
run;