SAS中dataset行列转换

shiyiming

From hssnow's blog on hssnow.name

之前saslist.net分享了一个SAS面经，其中提到对dataset进行行列转换有两种方法：1.proc transpose过程步；2.do循环+array statement。对于这个常见问题，姚志勇编写的《SAS编程与数据挖掘商业案例》中（P104-106）也有讲解，摘录如下： 数据集chapt6.fishdata如下 根据chapt6.fishdata将列转换成行： ?View Code SAS1 2 3 4 proc transpose data=chapt6.fishdata out=chapt6.fishlength(rename=(col1=measurement)); var length1-length4; by location date; run; ?View Code SAS1 2 3 4 5 6 7 8 9 data chapt6.fishlength2; set chapt6.fishdata(keep=location date length1-length4); array tr[1:4] length1-length4; do i=1 to 4; measurement=tr(i); output; end; keep location date measurement; run; 若再根据chapt6.fishlength将行转换成列： ?View [...]