发帖强烈求助SAS writing

在美国读书 要把4个EXCel作业改成saS  
还有4个小时就要交了 一个都没有写出  大家能帮帮忙么？
数据都在excel里 就是要出excel里面的图
我proc  plot太差 写了天都写不来 MaxDrawdown_format.xls (187 KB)

2010-12-19 19:49:50 上传

MAX DRAWDOWN SIMULATION

ding~~~thx so much for all of your help in advance

每次打开excel看到的数字都不一样,很让我抓狂
So, 如果你用的不是9.2,也有可能很抓狂

1. data raw1;
   
2.     input Bin percent8. Frequency;
   
3.     format bin percentn8.2;
   
4. datalines;
   
5. -8.50% 1
   
6. -8.00% 0
   
7. -7.50% 0
   
8. -7.00% 0
   
9. -6.50% 0
   
10. -6.00% 0
    
11. -5.50% 2
    
12. -5.00% 2
    
13. -4.50% 2
    
14. -4.00% 1
    
15. -3.50% 4
    
16. -3.00% 4
    
17. -2.50% 5
    
18. -2.00% 9
    
19. -1.50% 19
    
20. -1.00% 17
    
21. -0.50% 24
    
22. 0.00% 27
    
23. 0.50% 27
    
24. 1.00% 24
    
25. 1.50% 20
    
26. 2.00% 20
    
27. 2.50% 9
    
28. 3.00% 9
    
29. 3.50% 8
    
30. 4.00% 4
    
31. 4.50% 4
    
32. 5.00% 0
    
33. 5.50% 2
    
34. 6.00% 0
    
35. 6.50% 1
    
36. 7.00% 0
    
37. 7.50% 0
    
38. 8.00% 1
    
39. 8.50% 0
    
40. ;
    
41. proc sgplot data=raw1;
    
42.     title 'AAAAAAAAAA';
    
43.     vbar bin /response=frequency legendlabel='Frequency';
    
44.     yaxis label='Frequency' grid;
    
45.     keylegend /location=inside position=topright;
    
46. run;
    
47. data raw2;
    
48.     input xvar yvar;
    
49.     if xvar=40 then start=yvar;
    
50.     if xvar=50 then end=yvar;
    
51.     label xvar='Points in Time'
    
52.           yvar='Cummulated Returns'
    
53.           start='Maximum Drawdown Start'
    
54.           end='Maximum Drawdown End';
    
55. datalines;
    
56. 1 -0.016226963
    
57. 2 0.101942411
    
58. 3 -0.095823826
    
59. 4 -0.093068083
    
60. 5 -0.494835864
    
61. 6 -0.005611127
    
62. 7 -0.217995424
    
63. 8 -0.31334668
    
64. 9 0.018121449
    
65. 10 -0.555798523
    
66. 11 -0.705446198
    
67. 12 0.080958298
    
68. 13 0.758472895
    
69. 14 1.229839697
    
70. 15 1.402622623
    
71. 16 1.233950656
    
72. 17 1.428082919
    
73. 18 1.010944625
    
74. 19 1.347729718
    
75. 20 1.393750242
    
76. 21 1.587853421
    
77. 22 1.566174887
    
78. 23 2.31513952
    
79. 24 1.917421424
    
80. 25 2.103704034
    
81. 26 2.296570325
    
82. 27 1.504865404
    
83. 28 1.81933173
    
84. 29 2.230699179
    
85. 30 2.470077821
    
86. 31 2.514820144
    
87. 32 2.914532297
    
88. 33 2.615672206
    
89. 34 2.882996217
    
90. 35 2.602075965
    
91. 36 2.52181875
    
92. 37 2.369698165
    
93. 38 2.855326168
    
94. 39 2.633091733
    
95. 40 2.879697414
    
96. 41 2.813991777
    
97. 42 3.25644227
    
98. 43 3.506852176
    
99. 44 3.826024624
    
100. 45 3.88680258
     
101. 46 4.240176293
     
102. 47 4.132260421
     
103. 48 4.033612782
     
104. 49 4.066066532
     
105. 50 4.322454246
     
106. 51 4.432044642
     
107. 52 4.342438962
     
108. 53 4.334728413
     
109. 54 4.451238851
     
110. 55 4.111993723
     
111. 56 4.172025945
     
112. 57 4.135048827
     
113. 58 3.751131814
     
114. 59 3.832994167
     
115. 60 3.607588718
     
116. 61 3.401049929
     
117. 62 3.708905508
     
118. 63 3.629643683
     
119. 64 3.379532385
     
120. 65 3.239453458
     
121. 66 3.403714598
     
122. 67 3.677370716
     
123. 68 3.731654035
     
124. 69 3.994293166
     
125. 70 4.333033636
     
126. 71 4.375675956
     
127. 72 4.200821282
     
128. 73 4.506961208
     
129. 74 4.631788216
     
130. 75 4.815231864
     
131. 76 4.855844613
     
132. 77 4.410259832
     
133. 78 4.566443799
     
134. 79 4.491674065
     
135. 80 4.363805832
     
136. 81 4.149706349
     
137. 82 3.919456593
     
138. 83 4.182649435
     
139. 84 4.418432761
     
140. 85 4.62367957
     
141. 86 4.737810049
     
142. 87 4.852506486
     
143. 88 4.735949846
     
144. 89 4.810452076
     
145. ;
     
146. proc sgplot data=raw2;
     
147.     title 'AAAAAAAAAA';
     
148.     series x=xvar y=yvar /lineattrs=(color=green);
     
149.     scatter x=xvar y=start /markerattrs=(color=red size=10 symbol=starfilled);
     
150.     scatter x=xvar y=end /markerattrs=(color=blue size=10 symbol=starfilled);
     
151.     refline -0.41 /axis=y label='Maximum Loss' lineattrs=(color=red);
     
152.     refline 5.08 /axis=y label='Maximum Gain' lineattrs=(color=blue);
     
153.     yaxis min=-1 max=6 grid;
     
154.     xaxis grid;
     
155.     keylegend /location=outside position=bottom;
     
156. run;

复制代码