数学之路-sas备忘(10)

merge合并2个或2个以上的数据集。

libname saslib "k:\sas";

data saslib.goodsprice;

   input id name$ price 6.2;

datalines;

  1 鼠标 35.6

  2 键盘 28.95

  3 鼠标垫 8.2

  4 耳麦  29.7

   ;

data saslib.goodsquantity;

   input id quantity;

datalines;

  1 150

  2 98

  4 162

  3 45

   ;

proc sort data=saslib.goodsprice;

by id;

proc sort data=saslib.goodsquantity;

by id;

data saslib.mygoods;

  merge saslib.goodspricesaslib.goodsquantity;

  by id;

run;

proc print data= saslib.mygoods;

run;

 

本博客所有内容是原创，如果转载请注明来源

http://blog.youkuaiyun.com/myhaspl/

也可使用update，但update仅能操作2个数据集。

libname saslib "k:\sas";

data saslib.goodsprice;

   input id name$ price 6.2;

datalines;

  1 鼠标 35.6

  2 键盘 28.95

  3 鼠标垫 8.2

  4 耳麦  29.7

   ;

data saslib.goodsquantity;

   input id quantity;

datalines;

  1 150

  2 98

  4 162

  3 45

   ;

proc sort data=saslib.goodsprice;

by id;

proc sort data=saslib.goodsquantity;

by id;

data saslib.mygoods;

  update saslib.goodspricesaslib.goodsquantity;

  by id;

run;

proc print data= saslib.mygoods;

title '电脑周边产品';

run;

libname saslib "k:\src\sas";

data saslib.goodsprice;

   input id name$ price 6.2;

datalines;

  1 鼠标 35.6

  2 键盘 28.95

  3 鼠标垫 8.2

  4 耳麦  29.7

   ;

data saslib.goodsquantity;

   input id quantity;

datalines;

  1 150

  2 98

  4 162

  3 45

   ;

proc sort data=saslib.goodsprice;

by id;

proc sort data=saslib.goodsquantity;

by id;

 

data saslib.mygoods;

  update saslib.goodspricesaslib.goodsquantity;

  by id;

run;

proc print data= saslib.mygoods;

title '电脑周边产品';

run;