數學之路-sas備忘(10),數學之路-sas備忘
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.csdn.net/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;