在线时间 5024 小时 最后登录 2022-11-28 注册时间 2009-4-8 听众数 738 收听数 1 能力 23 分 体力 77924 点 威望 96 点 阅读权限 255 积分 27303 相册 1 日志 14 记录 36 帖子 4293 主题 1341 精华 15 分享 16 好友 1975
数学中国总编辑
TA的每日心情 衰 2016-11-18 10:46
签到天数: 206 天
[LV.7]常住居民III
超级版主
群组 : 2011年第一期数学建模
群组 : 第一期sas基础实训课堂
群组 : 第二届数模基础实训
群组 : 2012第二期MCM/ICM优秀
群组 : MCM优秀论文解析专题
data ex;
0 Y+ C! {. O/ K- B+ _ input x y g color $;
( R; H3 n" s# V, Y cards;
* i5 a* [# A5 ~" l5 _+ p% D 1 2 1 Yahoo!
2 R3 q& S) C9 K& r8 h6 } 1 4 2 Google' ~0 w! r( |8 B1 N- x: i2 x- B a
2 5 1 Yahoo!
! |# z( y7 B- d- G# w 2 8 2 Google
5 _4 v% s! G9 b) w. H 4 12 1 Yahoo!/ _' r- B' |5 j$ r8 n" a: ?7 A
4 10 2 Google* ~: c0 U0 R; S( ^: k
5 9 1 Yahoo!
4 j: z0 a" ]+ \& f* L) e8 O 5 7 2 Google0 c: J! Q1 Q; r, z, ]
;
2 y c% k1 F' w! D @6 f data title_anno;! w0 I( i# f( n3 N8 m( Y
when=’b'; xsys=’3′; ysys=’3′; style=’solid’;
4 E0 f" h4 R) G/ h* k' y3 ]* N function=’move’; x=0; y=87; output;
4 z4 J& _$ D7 c+ w1 Q function=’bar’; x=100; y=100; color=’black’; output;$ N; x) U+ ]6 |, g
run;
+ z% y+ H$ x7 h" J" ]: m8 V data range_anno;
$ ~- Q5 B, P# [: C' D when=’b'; xsys=’1′; ysys=’1′; style=’solid’;
: [, A* u. V4 @6 P# }/ L function=’move’; x=0; y=0; output;
- z) i0 F X4 p function=’bar’; x=100; y=20; color=”cxFFFBDD”;output;$ C0 {# [& k( b, P9 i8 @
function=’move’; x=0; y=20; output;
% I P3 X8 y6 }7 ? function=’bar’; color=”cxEEE3B4″; x=100; y=40; output;) V+ x9 W: C5 d5 P
function=’move’;x=0; y=40; output;
1 N0 v% D a3 I3 \ function=’bar’; color=”cxFFFBDD”; x=100; y=60; output;/ ^( Z9 A6 F7 E/ `( u9 f0 s
function=’move’;x=0; y=60; output;
/ Z% f0 v6 s% M3 m$ w3 ]/ m function=’bar’; color=”cxEEE3B4″; x=100; y=80; output;$ a: \/ ?( S! l- n: ?1 g. g
function=’move’;x=0; y=80; output;
6 T$ i* l% e& V8 c0 ? function=’bar’; color=”cxFFFBDD”; x=100; y=100; output;
+ y4 d) U. u- }6 [' k. y run;, \& V* h6 `' r7 E8 Y
data range_anno1;
% i' {# a, H& z1 s, `8 u" @& C3 o! y when=’b'; xsys=’1′; ysys=’1′;
% `0 n4 w0 X% |- ^7 w+ Y function=’move’; x=0; y=20; output;. t& `( f: P, e
function=’bar’; x=100; y=20; color=”cxD6CECD”;output;
1 E( T U) _. Y# E- ~% u8 M function=’move’; x=0; y=40; output;( R2 [% s+ z* U+ D4 k
function=’bar’; color=”cxD6CECD”; x=100; y=40; output;3 }. r: {! P! C+ i( s: A
function=’move’;x=0; y=60; output;
' c) q! I* {7 R$ k$ h function=’bar’; color=”cxD6CECD”; x=100; y=60; output;
3 R( s9 Q2 L! O1 F( n function=’move’;x=0; y=80; output;
% n w4 H8 B, ~' M function=’bar’; color=”cxD6CECD”; x=100; y=80; output;
$ F7 T7 [, T/ E run;+ K! t+ m8 p" g5 N
data range_anno;
& p( _6 i ~/ z1 U& \# T4 Q" [ set range_anno range_anno1;
2 H g1 W& A' w run;( a8 I. T2 w" T. A6 ?5 p6 m D! e
FILENAME file “c:\bussiness.png”;- O: `6 D3 Q6 B
GOPTIONS reset=all noborder Cback=”cxEEE3B4″ device=png gsfname=file
7 H" V' i4 F/ J& c* ` vsize=7cm hsize=7cm
1 R8 d | @% f I ymax=8cm xmax=9cm
3 |+ F9 @0 E( a3 y1 Y: r- O htext=1.5 ;* `, ^% V7 I0 f+ K1 m" v
axis1 major=none width=2 label=none REFLABEL=none value=(h=1 color=black “Q1″ “Q2″ “Q3″ “Q4″ ) offset=(4,4);
9 ?& k$ G- D3 F( [/ r0 w3 t axis2 color=black width=2 label=none order=(0 to 13 by 4) minor=none major=(h=1) value=(h=1.0) offset=(0,2);
8 L U0 g8 C! N axis3 major=none label=none value=none;
2 {& N; \" W8 k( A pattern1 v=s color=’cxFF8E00′;3 E& }! D7 C( s) b/ m. k. V
pattern2 v=s color=’cx004C7A’;
6 \, v, }* Q, w6 H0 y title j=l BCOLOR=black COLOR=white h=3.5 font=CENTB ” Bussniess weekly style”;, i! l) b/ V0 Y6 _! l
title2 j=l ” Internation compsdfdsfsfd”;* j( ~) m" h' s4 ^1 i1 Y8 l6 V
title3 j=l ” asdfd asdfdf dfsdfsd”;" c) V( w; i K7 D+ h' O7 l% d" N3 X7 m
legend1 label=none value=(HEIGHT=1.2 ‘Yahoo!’ ‘Google’ ) POSITION=(inside middle ) OFFSET=(-11,2.5)
7 q! q2 o- N1 h2 ~6 o# ? shape=bar(.1in,.1in);8 _/ | i' p7 r: V
proc gchart data=ex anno=title_anno;
* n7 F( L# w1 A8 L% M8 g vbar g / discrete type=sum
" g* x1 r6 I- r sumvar=y/ d, }' e; K$ t3 W! z8 ~
maxis=axis1 raxis=axis2 GAXIS=axis37 ~2 T% Q7 e7 L/ |1 E' b8 r/ @
coutline=gray33 caxis=”cxD6D3B8″4 X7 ^1 N: P' |; }1 c% b. V) O
width=4
7 S+ V/ c3 j8 c6 a8 V; O; H. X space=0! ]" K7 v! `$ e
gspace=07 t2 Y/ s8 p& L. J
subgroup= color
! [% O3 L+ U( }" e5 b5 w# J group=x* W% g0 P7 V+ P' @
legend=legend1
4 B5 v" Y5 |& p" d anno=range_anno ;9 L3 A8 A7 [8 W" `3 X- m# J6 G
footnote justify=l h=1 font=swiss “ Data from **group”;
) Z) b8 R( k7 y: v5 L footnote2 justify=l h=1 font=swiss “ http://sxlion.blog.sohu.com ”;7 z* K* r. r& o# q$ W3 v
run;6 m- W8 R3 |2 Y& `/ @# ^' a+ L6 c
quit;
/ @' R7 |4 b5 E7 u- v 下面是excelpro博客介绍的经典商业周刊风格的图表,对比一下相差无几。& i( ]. r( C- Q( D
这代码是相当的复杂,调试也比较费功夫。
, R6 n8 G) ?# e9 N9 |6 j8 Y. w
( v: r# G5 N G' o+ P5 o0 z
本来准备在sgplot的band语句画区域作为背景来实现的,但是由于存在bar图与band不兼容的情况,于是只好转向anno了。见SAS公司详细说明。
6 Z O4 `& x0 y8 B/ m There are four basic types of plots that you can create with the SGPLOT procedure:0 p5 {/ G5 x$ Q
Basic plots
# r s. P. @8 l scatter, series, step, band, needle, and vector plots: R6 ^7 i/ _4 K& H& t) a7 O5 _
Fit and confidence plots" W4 D6 T' E( k: i5 Z& {
loess, regression, and penalized B-spline curves, and ellipses4 t. d! O" C( J$ \' F
Distribution plots, g* V4 b: _/ S* \+ ?
box plots, histograms, and normal and kernel density estimates
* j: A+ M; J u1 k0 Y Categorization plots
! x" Y: c- O1 X8 x5 G dot plots, bar charts, and line plots0 e: v1 O5 _. T0 n( E$ Q4 h& Q- f! T
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* v& l& t6 `! \. n& u. w! c' b" \
6 E/ o" j2 L% ?
2 Z+ A9 m5 \4 \& G- P* |" s data ex;
& F: h7 x8 I; ~1 s input x y ;
5 J: n: @2 I6 D8 Q cards;, v' T+ S r; B- x
1 24 _ _3 G, J7 f1 w, R. ^
2 79 L0 u* i' }7 E/ C
4 12 S5 v# b+ N9 w5 z, ~/ a
5 11
8 j2 z0 ~& g0 C1 J* ] 6 9
6 K1 c, C; U! b8 D3 s$ A7 Y9 I) B 7 8( p; _$ W! u& ]" B- l
;* F& d% a! F+ r1 u: m2 b7 t( |: I
title ;3 I7 l3 Y% ]* I
footnote;
1 y! q& }$ l R4 ?8 L! L proc sgplot data=ex noautolegend;
# p3 d" {! f6 A' z SERIES x=x y=y/LINEATTRS=(color=blue thickness=6) ;
N) M, Y" M* `7 P* U+ `. n. m band x=x lower=0 upper=2.5 / OUTLINE transparency=.8 LINEATTRS=(color=black) fillattrs=(color=cxEEE3B4) NOOUTLINE;, f4 _9 F) u% F3 l% w, q
band x=x lower=2.5 upper=5 / OUTLINE transparency=.7 LINEATTRS=(color=black) fillattrs=(color=orange) NOOUTLINE;
/ `$ K. \8 f2 d; b band x=x lower=5 upper=7.5 /OUTLINE transparency=.8 LINEATTRS=(color=black) fillattrs=(color=cxEEE3B4) NOOUTLINE;% ]+ S8 n( X- |2 K+ f5 X
band x=x lower=7.5 upper=10 / OUTLINE transparency=.7 LINEATTRS=(color=black) fillattrs=(color=orange) NOOUTLINE;
3 B2 k6 x) S$ I: e9 e1 k) R) F& D6 ? band x=x lower=10 upper=12.5 /OUTLINE transparency=.8 LINEATTRS=(color=black) fillattrs=(color=cxEEE3B4) NOOUTLINE;
% u$ E5 D" `. D4 x yaxis values=(0 to 12 by 3) min=0 max=13 valueshint;5 n6 r; j, s, \
xaxis values=(0 to 8 by 2) min=0 max=8 valueshint;* F7 Q. o- i. X" @5 ^, S' n
run;; Q4 g6 j% N4 _% G& }7 F3 v4 R- B
来源:数据挖掘学院
zan