sas 文件合并 左联接

sas文件合并，支持左右连接

连接过程 左连接 merge one two;  by ID;

View Code

 1 data one ;
 2 input ID Name $ ;
 3 datalines;
 4 7 Adam
 5 1 Smith
 6 2 Schneider
 7 4 Gregory
 8 ;
 9 data two;
10 input ID category $ time ;
11 datalines;
12 1    IT 3
13 2    economy 2 
14 4    music 4
15 ;
16 proc sort data=one;
17 by ID;
18 run;
19 proc sort date=two;
20     by ID;
21 run;
22 data combine;
23 merge one two;
24     by ID;
25 run;
26 proc print data=combine;
27 run;

运行结果

Obs	ID	Name	category	time
1	1	Smith	IT	3
2	2	Schneide	economy	2
3	4	Gregory	music	4
4	7	Adam		.

转载于:https://www.cnblogs.com/xinyonde/archive/2013/04/25/3042613.html