8.数据集排序合并更新).ppt

例，用update语句更新数据 主数据集：HEALTH ID NAME TEAM WEIGHT0 1114 sally blue 125 1441 sue green 145 1750 joey red 189 1994 mark yellow 165 2304 joe red 170 从数据集：FITNESS ID NAME TEAM WEIGHT1 1114 sally green 119 1994 mark yellow 174 2304 joe red 170 参考程序 data HEALTH; input ID NAME$ TEAM$ WEIGHT; cards; 1114 sally blue 125 1441 sue green 145 1750 joey red 189 1994 mark yellow 165 2304 joe red 170 ; data FITNESS; input ID NAME$ TEAM$ WEIGHT1; cards; 1114 sally green 119 1994 mark yellow 174 2304 joe red 170 ; proc sort data=health; by id; proc sort data=fitness; by id; run; data c; update health fitness; by id; run; proc print; run; Obs ID NAME TEAM WEIGHT0 WEIGHT1 1 1114 sally green 125 119 2 1441 sue green 145 . 3 1750 joey red 189 . 4 1994 mark yellow 165 174 5 2304 joe red 170 170 主数据集更新后的结果 1114号的TEAM由blue更新成了green 新变量weight1被添加到了主数据集 从数据集中含有缺失数据 data FITNESS; input ID NAME$ TEAM$ WEIGHT; cards; 1114 sally green 119 1994 mark yellow . 2304 joe red 170 ; proc sort data=health; by id; proc sort data=fitness; by id; run; data c; update health fitness; by id; run; /*weight变量名与主数据集相同*/ 更新模式，Updatemode=选项 missingcheck模式（默认） 1994号165没有被替换 Obs ID NAME TEAM WEIGHT 1 1114 sally green 119 2 1441 sue green 145 3 1750 joey red 189 4 1994 mark yellow 165 5 2304 joe red 170 data c; update health fitness; by id; run; nomissingcheck模式 Obs ID NAME TEAM WEIGHT 1 1114 sally green 119 2 1441 sue green 145 3 1750 joey red 189 4 1994 mark yellow . 5 2304 joe red 170 data c; update health fitness updatemode=nomissingcheck; by id; run; 1994号165被替换为缺失 五、数据集转置----Transpose过程 转置就是把数据集的观测变为变量，变量变为观测。利用SAS的Transpose过程可以对数据集进行转置。 语法格式 PROC TRANSPOSE DATA=in-dataset LABEL=label LET NAME=name OUT=out-dataset PREFIX=prefix; BY DESCE