SAS求标准差

请教一个程序，现有多个个体（1,2....n）和月度的出口数据，现求每个个体出口的年度波动率即出口标准差，用SAS程序应如何求解？谢谢！

id	t	export
1	2000M01	715.7006
1	2000M02	706.9256
1	2000M03	710.6221
1	2000M04	700.1311
1	2000M05	708.2567
1	2000M06	732.6823
1	2000M07	716.7608
1	2000M08	704.8138
1	2000M09	696.2142
1	2000M10	705.4665
1	2000M11	710.1729
1	2000M12	719.4408
1	2001M01	719.352
1	2001M02	708.7314
1	2001M03	686.6508
1	2001M04	694.3744
1	2001M05	697.6404
1	2001M06	690.2271
1	2001M07	697.1531
1	2001M08	714.9677
1	2001M09	714.292
1	2001M10	719.5846
1	2001M11	717.247
1	2001M12	706.0435
1	2002M01	700.995
1	2002M02	705.4693
1	2002M03	719.4172
1	2002M04	734.4351
1	2002M05	751.4481
1	2002M06	767.8617
1	2002M07	742.6122
1	2002M08	739.4231
1	2002M09	767.3983
1	2002M10	770.1667
1	2002M11	775.6593
1	2002M12	795.1697
1	2003M01	804.9042
1	2003M02	806.6904
1	2003M03	809.8767
1	2003M04	812.369
1	2003M05	830.7275
1	2003M06	819.2229
1	2003M07	798.9793
1	2003M08	800.4831
1	2003M09	815.1662
1	2003M10	799.42
1	2003M11	820.2558
1	2003M12	841.059
1	2004M01	838.4807
1	2004M02	835.2331
1	2004M03	831.3804
1	2004M04	794.3107
1	2004M05	805.5009
1	2004M06	783.6799
1	2004M07	756.6795
1	2004M08	752.7142
1	2004M09	746.5701
1	2004M10	755.7898
1	2004M11	769.4859
1	2004M12	754.5144
1	2005M01	729.6054
1	2005M02	721.9043
1	2005M03	692.1565
1	2005M04	666.2456
1	2005M05	656.4707
1	2005M06	644.3169
1	2005M07	650.0122
1	2005M08	683.7015
1	2005M09	643.8646
1	2005M10	652.3739
1	2005M11	639.9373
1	2005M12	643.4431
1	2006M01	649.2592
1	2006M02	646.7393
1	2006M03	649.7081
1	2006M04	656.2987
1	2006M05	638.8516
1	2006M06	619.5454
1	2006M07	616.2767
1	2006M08	590.2577
1	2006M09	563.2352
1	2006M10	560.8316
1	2006M11	556.4278
1	2006M12	546.8494
1	2007M01	535.4854
1	2007M02	532.084
1	2007M03	546.8851
1	2007M04	544.0865
1	2007M05	526.2786
1	2007M06	516.7336
1	2007M07	516.2968
1	2007M08	515.6534
1	2007M09	522.7075
1	2007M10	511.0025
1	2007M11	485.5297
1	2007M12	480.7437
1	2008M01	489.4926
1	2008M02	495.7434
1	2008M03	505.2726
1	2008M04	498.2082
1	2008M05	495.1532
1	2008M06	494.4151
1	2008M07	487.8363
1	2008M08	476.1917
1	2008M09	470.4673
1	2008M10	454.0803
1	2008M11	454.4558
1	2008M12	472.447
1	2009M01	459.6341
1	2009M02	448.7627
1	2009M03	549.8419
1	2009M04	555.5451
1	2009M05	573.212
1	2009M06	558.8959
1	2009M07	575.2602
1	2009M08	587.1002
1	2009M09	608.8417
1	2009M10	614.2858
1	2009M11	621.143
1	2009M12	592.4144
1	2010M01	585.4478
1	2010M02	589.5069
1	2010M03	608.0551
1	2010M04	581.5545
1	2010M05	558.83
1	2010M06	543.4958
1	2010M07	562.0954
1	2010M08	547.3118
1	2010M09	562.267
1	2010M10	563.0309
1	2010M11	547.8618
1	2010M12	559.7085
2	2000M01	2.421655
2	2000M02	2.397311
2	2000M03	2.410897
2	2000M04	2.361386
2	2000M05	2.362836
2	2000M06	2.393731
2	2000M07	2.350897
2	2000M08	2.335592
2	2000M09	2.323223
2	2000M10	2.290019
2	2000M11	2.294726
2	2000M12	2.332209
2	2001M01	2.323044
2	2001M02	2.313539
2	2001M03	2.256564
2	2001M04	2.265764
2	2001M05	2.245072
2	2001M06	2.229714
2	2001M07	2.253145
2	2001M08	2.305932
2	2001M09	2.307328
2	2001M10	2.287763
2	2001M11	2.266283
2	2001M12	2.249547
2	2002M01	2.223252
2	2002M02	2.222518
2	2002M03	2.231969
2	2002M04	2.269201
2	2002M05	2.310281
2	2002M06	2.381523
2	2002M07	2.367239
2	2002M08	2.376243
2	2002M09	2.367615
2	2002M10	2.365718
2	2002M11	2.370103
2	2002M12	2.433541
2	2003M01	2.464007
2	2003M02	2.453822
2	2003M03	2.459084
2	2003M04	2.477199
2	2003M05	2.541711
2	2003M06	2.507539
2	2003M07	2.491591
2	2003M08	2.465313
2	2003M09	2.559324
2	2003M10	2.562886
2	2003M11	2.593316
2	2003M12	2.659886
2	2004M01	2.651545
2	2004M02	2.649325
2	2004M03	2.650113
2	2004M04	2.598776
2	2004M05	2.629188
2	2004M06	2.624534
2	2004M07	2.60939
2	2004M08	2.614707
2	2004M09	2.629492
2	2004M10	2.682816
2	2004M11	2.749261
2	2004M12	2.779888
2	2005M01	2.729464
2	2005M02	2.742262
2	2005M03	2.704386
2	2005M04	2.715036
2	2005M05	2.640161
2	2005M06	2.607332
2	2005M07	2.598829
2	2005M08	2.613114
2	2005M09	2.594533
2	2005M10	2.587982
2	2005M11	2.549211
2	2005M12	2.558393
2	2006M01	2.587266
2	2006M02	2.568704
2	2006M03	2.579122
2	2006M04	2.633197
2	2006M05	2.674582
2	2006M06	2.648072
2	2006M07	2.656109
2	2006M08	2.664451
2	2006M09	2.642702
2	2006M10	2.649272
2	2006M11	2.698837
2	2006M12	2.692876
2	2007M01	2.667369
2	2007M02	2.693449
2	2007M03	2.70324
2	2007M04	2.728282
2	2007M05	2.708019
2	2007M06	2.71287
2	2007M07	2.740884
2	2007M08	2.743408
2	2007M09	2.786404
2	2007M10	2.813665
2	2007M11	2.846422
2	2007M12	2.828648
2	2008M01	2.855533
2	2008M02	2.882885
2	2008M03	2.943655
2	2008M04	2.906566
2	2008M05	2.901035
2	2008M06	2.92418
2	2008M07	2.901375
2	2008M08	2.810085
2	2008M09	2.787424
2	2008M10	2.664057
2	2008M11	2.663466
2	2008M12	2.757083
2	2009M01	2.695668
2	2009M02	2.626574
2	2009M03	2.676175
2	2009M04	2.681116
2	2009M05	2.77101
2	2009M06	2.778492
2	2009M07	2.780461
2	2009M08	2.803247
2	2009M09	2.836022
2	2009M10	2.845903
2	2009M11	2.882222
2	2009M12	2.806165
2	2010M01	2.782
2	2010M02	2.743318
2	2010M03	2.71765
2	2010M04	2.704905
2	2010M05	2.639051
2	2010M06	2.647231
2	2010M07	2.718151
2	2010M08	2.700949
2	2010M09	2.78558
2	2010M10	2.813504
2	2010M11	2.731146
2	2010M12	2.756654
3	2000M01	2.119837
3	2000M02	2.180173
3	2000M03	2.224393
3	2000M04	2.232544
3	2000M05	2.301691
3	2000M06	2.234013
3	2000M07	2.25584
3	2000M08	2.270007
3	2000M09	2.388901
3	2000M10	2.48512
3	2000M11	2.452592
3	2000M12	2.351823
3	2001M01	2.374296
3	2001M02	2.461867
3	2001M03	2.578016
3	2001M04	2.487795
3	2001M05	2.459275
3	2001M06	2.454483
3	2001M07	2.497005
3	2001M08	2.411513
3	2001M09	2.618342
3	2001M10	2.529349
3	2001M11	2.434769
3	2001M12	2.461281
3	2002M01	2.445924
3	2002M02	2.404396
3	2002M03	2.345579
3	2002M04	2.348916
3	2002M05	2.274692
3	2002M06	2.35563
3	2002M07	2.414166
3	2002M08	2.399693
3	2002M09	2.433652
3	2002M10	2.3882
3	2002M11	2.361056
3	2002M12	2.40113
3	2003M01	2.339463
3	2003M02	2.264371
3	2003M03	2.275994
3	2003M04	2.221364
3	2003M05	2.17717
3	2003M06	2.098981
3	2003M07	2.13195
3	2003M08	2.151984
3	2003M09	2.102323
3	2003M10	2.032047
3	2003M11	2.010519
3	2003M12	1.981293
3	2004M01	1.937873
3	2004M02	1.920174
3	2004M03	1.950863
3	2004M04	2.010845
3	2004M05	2.056307
3	2004M06	2.12835
3	2004M07	2.086688
3	2004M08	2.083483
3	2004M09	2.055394
3	2004M10	2.008819
3	2004M11	1.975434
3	2004M12	1.993594
3	2005M01	1.96906
3	2005M02	1.938001
3	2005M03	1.957287
3	2005M04	1.941851
3	2005M05	1.951767
3	2005M06	1.907307
3	2005M07	1.9116
3	2005M08	1.954009
3	2005M09	1.903427
3	2005M10	1.931081
3	2005M11	1.90215
3	2005M12	1.948031
3	2006M01	1.924634
3	2006M02	1.943958
3	2006M03	2.012641
3	2006M04	1.950491
3	2006M05	1.956757
3	2006M06	1.990273
3	2006M07	1.93766
3	2006M08	1.951645
3	2006M09	1.973757
3	2006M10	1.924129
3	2006M11	1.920675
3	2006M12	1.901175
3	2007M01	1.930246
3	2007M02	1.909543
3	2007M03	1.871363
3	2007M04	1.847491
3	2007M05	1.835104
3	2007M06	1.785755
3	2007M07	1.786304
3	2007M08	1.865875
3	2007M09	1.76351
3	2007M10	1.705599
3	2007M11	1.793773
3	2007M12	1.79248
3	2008M01	1.795666
3	2008M02	1.701405
3	2008M03	1.791394
3	2008M04	1.739081
3	2008M05	1.69546
3	2008M06	1.697091
3	2008M07	1.718126
3	2008M08	1.817201
3	2008M09	1.947499
3	2008M10	2.227994
3	2008M11	2.264105
3	2008M12	2.223253
3	2009M01	2.339174
3	2009M02	2.273567
3	2009M03	2.17528
3	2009M04	2.061707
3	2009M05	1.956585
3	2009M06	1.913027
3	2009M07	1.875776
3	2009M08	1.865912
3	2009M09	1.800216
3	2009M10	1.735498
3	2009M11	1.754391
3	2009M12	1.747898
3	2010M01	1.744517
3	2010M02	1.722194
3	2010M03	1.657648
3	2010M04	1.62486
3	2010M05	1.729622
3	2010M06	1.735187
3	2010M07	1.689873
3	2010M08	1.691983
3	2010M09	1.609796
3	2010M10	1.610276
3	2010M11	1.58638
3	2010M12	1.51533

liuliuqiu 发表于 2017-3-21 16:40
谢谢您！但结果不大对，我想要的是每个个体的年度波动率，即2000、2001一直到2010年每年的波动率，现在得 ...

data a;
set raw;
year=input(substr(t,1,4),best.);
run;
proc means data=a n mean std median noprint;
var export;
output out=c ;
by id year;
run;

1. data a;
   
2. set raw;
   
3. year=input(substr(t,1,4),best.);
   
4. run;
   
5. proc sql noprint;
   
6. create table b as
   
7. select distinct id,year,sum(export) as tot from a group by id ,year order by id ,year;
   
8. quit;
   
9. 
   
10. proc means data=b n mean std median noprint;
    
11. var tot;
    
12. output out=c ;
    
13. by id;
    
14. run;

复制代码

lovexialulu 发表于 2017-3-21 16:05

谢谢您！但结果不大对，我想要的是每个个体的年度波动率，即2000、2001一直到2010年每年的波动率，现在得出来的是个体的总体波动率，能否再帮我看一下？

lovexialulu 发表于 2017-3-21 14:58
data a;
set raw;
year=input(substr(t,1,4),best.);

非常感谢