The Road to Mathematics-sas (10)

Merge merges 2 or more 2 datasets.

libname saslib "k:\SAS";

data Saslib.goodsprice;

input ID name$ price 6.2;

Datalines;

1 Mouse 35.6

2 keyboard 28.95

3 Mouse Pad 8.2

4 Headset 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;

This blog all content is original, if reproduced please indicate sourcehttp://blog.csdn.net/myhaspl/

The Road to Mathematics-sas (10)