按条件导出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;
写法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;