SAS中文论坛

标题: how to merge?? [打印本页]

作者: shiyiming 时间: 2010-8-9 19:57
标题: how to merge??
要变量合并，若id相同，则执行输出到新数据集，若没有相同，输出到另外个数据集，原始数据集如下;
dataset1
[code:3o5oz0oh]id v1 v2 v3 v4 v5
11 a 1 1 1 1
12 b 2 2 2 2
13 c 6 6 6 6
14 a 3 3 3 3
15 b 5 5 5 5
16 c 1 1 1 1
17 a 2 2 2 2
18 b 6 6 6 6
19 c 3 3 3 3
20 a 5 5 5 5
[/code:3o5oz0oh]
dataset2
[code:3o5oz0oh]id v11 v12 v13 v14 v15
18 1 2 1 1 1
19 2 1 2 1 2
20 2 1 2 1 2
21 1 2 1 2 1
22 1 2 1 2 1
23 2 1 2 1 1
24 2 1 2 1 1
25 2 1 2 1 1
[/code:3o5oz0oh]
望大侠指教！！

作者: shiyiming 时间: 2010-8-9 20:42
标题: Re: how to merge??
[code:2onj66gz]data one;
input id v1 $ v2-v5;
datalines;
11 a 1 1 1 1
12 b 2 2 2 2
13 c 6 6 6 6
14 a 3 3 3 3
15 b 5 5 5 5
16 c 1 1 1 1
17 a 2 2 2 2
18 b 6 6 6 6
19 c 3 3 3 3
20 a 5 5 5 5
;
data two;
input id v11-v15;
datalines;
18 1 2 1 1 1
19 2 1 2 1 2
20 2 1 2 1 2
21 1 2 1 2 1
22 1 2 1 2 1
23 2 1 2 1 1
24 2 1 2 1 1
25 2 1 2 1 1
;
data out1 out2;
merge one(in=one) two(in=two);
by id;
if one and two then output out1;
else output out2;
run;[/code:2onj66gz]

欢迎光临 SAS中文论坛 (https://mysas.net/forum/)