按条件导出excel数据

按条件导出excel数据

写法1:

proc export data=hbq.tmp_double_card_51_6(firstobs=1 obs=65486)

outfile="C:\Users\EX_WLJR_HUANGBIQUAN\Downloads\二类户促动测试群购买数据采集.xls" replace;

sheet='二类户促动测试客群5活动组part1';

run;

proc export data=hbq.tmp_double_card_51_6(firstobs=65487 obs=124696)

outfile="C:\Users\EX_WLJR_HUANGBIQUAN\Downloads\二类户促动测试群购买数据采集.xls" replace;

sheet='二类户促动测试客群5活动组part2';

run;

--写法2:

proc export data=hbq.tmp_double_card_51_6(where=(ecifno<='600095999998'))

outfile="C:\Users\EX_WLJR_HUANGBIQUAN\Downloads\二类户促动测试群购买数据采集2.xls" replace;

sheet='二类户促动测试客群5活动组part1';

run;

proc export data=hbq.tmp_double_card_51_6(where=(ecifno > '600095999998'))

outfile="C:\Users\EX_WLJR_HUANGBIQUAN\Downloads\二类户促动测试群购买数据采集2.xls" replace;

sheet='二类户促动测试客群5活动组part2';

run;