options noxwait;
ODS TAGSETS.EXCELXP FILE="C:\Users\Administrator\Desktop\&spdm..xls" STYLE=statistical;
proc report data=CK nowd
style(header) = {vjust=middle background=CXE8D898 foreground=black font_size = 8pt font_weight = bold}
style(column) = {vjust=middle font_size =2 font_face="times new roman"} nowd SPANROWS NOCOMPLETECOLS;
col ("&dt_time." big_kind_name RANK SPDM Color SPMC RQ BZSJ)
('商品' ('码&店数统计' V1-V%LEFT(&MAX_CC.) CD)
('销量' HaveDAY XL XL%LEFT(&DAY1.) XL%LEFT(&DAY2.) XL%LEFT(&DAY3.))
('库存' KC ZBKC VAR1-VAR%LEFT(&DIM2.)))
('店铺' SHOP_LIST NOSALE_SHOP_LIST);
define NOSALE_SHOP_LIST/style(column)={font_size=0.5};
define SHOP_LIST/style(column)={font_size=0.5};
define big_kind_name/'大类' ORDER ORDER=DATA;
define RANK/'排名';define SPDM/'商品代码';
define XL/"近&Interval.天";define KC/"门店";
define SPMC/'商品名称';define BZSJ/'零售价格';
define V%LEFT(&UP_C_flag.)/style(column)={background=CXE8D898};
define ZBKC/style(column)={background=CXE8D898};
*define CD/style(column)={background=CXE8D898};
run;
ODS TAGSETS.EXCELXP CLOSE;