用SAS实现商业周刊经典风格 对绘图背景进行隔行填色

厚积薄发

data ex;
. M5 L3 O, e) v" ^! ?input x y g color $;
( R! v+ {8 u8 k+ y0 m+ kcards;
1 2 1  Yahoo!
! s4 }8 d: f, E6 ?& U+ y1 4 2 Google
2 5 1 Yahoo!
/ S( c9 D. i8 B/ d3 i+ [4 }/ m! w6 H2 8 2 Google
7 F; O- ]/ v: n- E4 12  1 Yahoo!
4 10 2 Google
. ?4 @$ [4 p% ~* h2 B- V6 f5 9  1 Yahoo!
5 7 2 Google
# Z! m7 t/ v: @0 v# o9 @9 z) B;
  D. a6 g" C, V4 Y1 Kdata title_anno;
8 d5 f) z9 Y# e1 |5 L4 P# P: U6 ewhen=’b'; xsys=’3′; ysys=’3′; style=’solid’;
function=’move’; x=0; y=87;  output;
# {3 ~8 @  s% N( l7 [7 Wfunction=’bar’; x=100; y=100; color=’black’; output;
run;
% ~4 o- B5 q& i6 J6 mdata range_anno;
when=’b'; xsys=’1′; ysys=’1′; style=’solid’;
4 x$ ^3 L$ X1 X  ~$ y: ]function=’move’; x=0; y=0; output;
function=’bar’;  x=100; y=20; color=”cxFFFBDD”;output;
function=’move’; x=0; y=20; output;
function=’bar’; color=”cxEEE3B4″; x=100; y=40; output;
9 ~) j) [, b3 `# ?: c0 dfunction=’move’;x=0; y=40; output;
" t7 G# G0 |: f- F$ k+ e1 q: qfunction=’bar’; color=”cxFFFBDD”; x=100; y=60; output;
function=’move’;x=0; y=60; output;
function=’bar’; color=”cxEEE3B4″; x=100; y=80; output;
function=’move’;x=0; y=80; output;
; l! _  A& v7 G$ j! S6 ^0 cfunction=’bar’; color=”cxFFFBDD”; x=100; y=100; output;
" c# |- c& d# [; `( A7 \run;
1 |6 ^! K& ~- U1 _data range_anno1;
6 s+ ^+ J+ f6 |/ R& v, Y* pwhen=’b'; xsys=’1′; ysys=’1′;
function=’move’; x=0; y=20; output;
function=’bar’;  x=100; y=20; color=”cxD6CECD”;output;
) U8 k0 K; {6 L7 Qfunction=’move’; x=0; y=40; output;
2 {& J8 Y) i) S, t8 a5 q) tfunction=’bar’; color=”cxD6CECD”; x=100; y=40; output;
0 W/ x- y6 ^% A% h; \& d# gfunction=’move’;x=0; y=60; output;
3 q( R: P3 P4 }" |: r) l+ H8 Q" [4 vfunction=’bar’; color=”cxD6CECD”; x=100; y=60; output;
- e  R* k# A! z  {) ofunction=’move’;x=0; y=80; output;
function=’bar’; color=”cxD6CECD”; x=100; y=80; output;
run;
data range_anno;
: n* f5 K3 `/ u3 w4 lset range_anno range_anno1;
& j' P" c& s" x& E2 d  x/ Trun;
FILENAME file “c:\bussiness.png”;
4 m+ T+ ~6 I3 ]7 J" yGOPTIONS reset=all noborder  Cback=”cxEEE3B4″ device=png  gsfname=file
; n3 g5 X+ [5 Fvsize=7cm hsize=7cm
ymax=8cm xmax=9cm
htext=1.5   ;
axis1  major=none width=2 label=none  REFLABEL=none value=(h=1 color=black “Q1″ “Q2″ “Q3″ “Q4″ ) offset=(4,4);
; ]& d7 |4 ?" H( K3 G9 Waxis2 color=black width=2 label=none order=(0 to 13 by 4) minor=none major=(h=1)  value=(h=1.0) offset=(0,2);
6 G" F1 [$ ]) Y" h8 a) [axis3 major=none label=none value=none;
pattern1 v=s color=’cxFF8E00′;
9 r4 P" o7 h* ~. s' Vpattern2 v=s color=’cx004C7A’;
title j=l BCOLOR=black  COLOR=white h=3.5 font=CENTB  ” Bussniess weekly style”;
8 v8 e$ O2 v* }9 k6 C3 V- Atitle2 j=l ” Internation compsdfdsfsfd”;
title3 j=l ” asdfd asdfdf dfsdfsd”;
legend1 label=none value=(HEIGHT=1.2 ‘Yahoo!’ ‘Google’ )  POSITION=(inside middle )  OFFSET=(-11,2.5)
! D: M2 m4 `2 i9 u/ r) x$ Nshape=bar(.1in,.1in);
proc gchart data=ex anno=title_anno;
* D5 c  G/ J$ G$ cvbar g / discrete       type=sum
sumvar=y
maxis=axis1 raxis=axis2 GAXIS=axis3
. o$ C) F9 Z5 z$ @; S  lcoutline=gray33  caxis=”cxD6D3B8″
width=4
space=0
gspace=0
subgroup= color
group=x
# r1 }( b" e; @( }legend=legend1
! X1 r' E' \; M6 i1 o7 B. r# W/ \  janno=range_anno ;
  ^9 D1 _4 g7 @1 l0 c( c  v( Pfootnote justify=l h=1 font=swiss “  Data from **group”;
1 y! e4 h8 `8 d, b  U! Y: ufootnote2 justify=l h=1 font=swiss “  http://sxlion.blog.sohu.com”;
run;
0 H6 M6 I2 o# C7 N4 _7 Mquit;
/ p$ }3 |5 n0 K: \( u  \- }下面是excelpro博客介绍的经典商业周刊风格的图表，对比一下相差无几。
  U) B. M1 d, k  X这代码是相当的复杂，调试也比较费功夫。
9 E* x4 Q7 f/ P  \* P" @
本来准备在sgplot的band语句画区域作为背景来实现的，但是由于存在bar图与band不兼容的情况，于是只好转向anno了。见SAS公司详细说明。
, {5 z  j" w1 F% ?6 nThere are four basic types of plots that you can create with the SGPLOT procedure:
0 y/ @# l( E; n0 T1 gBasic plots
scatter, series, step, band, needle, and vector plots
2 ]: j9 L4 Q5 t0 hFit and confidence plots
$ V& t) }3 M# [2 T$ ^9 xloess, regression, and penalized B-spline curves, and ellipses
Distribution plots
box plots, histograms, and normal and kernel density estimates
Categorization plots
* }6 |8 w) w5 m$ ydot plots, bar charts, and line plots
Not all of the plot types can be used together in the same PROC SGPLOT step. The following table shows which of the plot types can be used together

- G/ j" g$ n9 {% a1 P  I
data ex;
input x y ;
* o) C! i' l8 w1 _9 I* Gcards;
1 2
) w& C# a* O* E- j+ R! o/ |2 7
4 12
5 11
+ h' [4 a6 L, O, @" ~& }( R6  9
+ U! x0 N) T# V7  8
7 J7 j0 V6 v+ a6 q$ P;
title ;
footnote;
proc sgplot data=ex noautolegend;
+ B' \" r; [/ V% }- N/ fSERIES  x=x y=y/LINEATTRS=(color=blue thickness=6) ;
' t- I/ k+ H4 l( D3 D* l/ Zband x=x lower=0 upper=2.5 / OUTLINE  transparency=.8 LINEATTRS=(color=black) fillattrs=(color=cxEEE3B4) NOOUTLINE;
band x=x lower=2.5 upper=5  / OUTLINE transparency=.7 LINEATTRS=(color=black) fillattrs=(color=orange) NOOUTLINE;
band x=x lower=5 upper=7.5 /OUTLINE transparency=.8 LINEATTRS=(color=black) fillattrs=(color=cxEEE3B4) NOOUTLINE;
3 k  b+ l* {" c$ Y. O; r$ ?band x=x lower=7.5 upper=10  / OUTLINE transparency=.7 LINEATTRS=(color=black) fillattrs=(color=orange) NOOUTLINE;
8 B! L1 [) c" q  M3 E+ P% S3 Mband x=x lower=10 upper=12.5 /OUTLINE transparency=.8 LINEATTRS=(color=black) fillattrs=(color=cxEEE3B4) NOOUTLINE;
( L9 Y" ~( B+ M0 A7 k9 x+ Q' _1 nyaxis values=(0 to 12 by 3)   min=0   max=13 valueshint;
$ v2 c+ s! {! Q9 f; Q5 Qxaxis values=(0 to 8 by 2)   min=0   max=8 valueshint;
* m2 T% m2 e$ H7 b+ Z8 n: hrun;
" |' W  S/ G* B来源：数据挖掘学院

平平凡凡的我

不错的东东

schnee

顶！！！！！！！

jt202010

老牦

顶！！！！！！！

飞雪灬无痕

学习了。。。。。。。。

hahaysw

不错的东西，数学中国做的图相当好看啊！

540109558

相当的不简单啊

秋の名山で戦

哇 太强了 效果相当好