楼主: liuliuqiu
8027 4

[问答] SAS求标准差 [推广有奖]

  • 6关注
  • 2粉丝

已卖：35份资源

副教授

64%

还不是VIP/贵宾

-

0%
威望
0 级
论坛币
2239 个
通用积分
8.1161
学术水平
3 点
热心指数
5 点
信用等级
5 点
经验
14393 点
帖子
429
精华
0
在线时间
1129 小时
注册时间
2009-3-24
最后登录
2025-12-11
楼主
liuliuqiu 发表于 2017-3-21 14:58:07 |AI写论文
5论坛币
请教一个程序，现有多个个体（1,2....n）和月度的出口数据，现求每个个体出口的年度波动率即出口标准差，用SAS程序应如何求解？谢谢！

idtexport

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



最佳答案

lovexialulu 查看完整内容

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;
分享0
关键词：标准差 程序 如何

相关帖子

沙发
lovexialulu 发表于 2017-3-21 14:58:08
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;
藤椅
lovexialulu 发表于 2017-3-21 16:05:56
  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;

  10. proc means data=b n mean std median noprint;
  11. var tot;
  12. output out=c ;
  13. by id;
  14. run;
复制代码
板凳
liuliuqiu 发表于 2017-3-21 16:40:14
lovexialulu 发表于 2017-3-21 16:05
谢谢您！但结果不大对，我想要的是每个个体的年度波动率，即2000、2001一直到2010年每年的波动率，现在得出来的是个体的总体波动率，能否再帮我看一下？
报纸
liuliuqiu 发表于 2017-3-22 09:41:07
lovexialulu 发表于 2017-3-21 14:58
data a;
set raw;
year=input(substr(t,1,4),best.);
非常感谢
返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群

京ICP备16021002号-2 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问：王进律师 知识产权保护声明   免责及隐私声明

GMT+8, 2026-2-17 12:25