SAS中文论坛

标题: 求教: merge / append datasets [打印本页]

作者: shiyiming 时间: 2011-1-19 16:18
标题: 求教: merge / append datasets
求教: merge / append datasets

无尽感激。

3 datasets

1st dataset
==============================================
Co. ID    Yr    Industry ID Var1 Var2 Var3
1       1995    311
1       1996    311
1       1997    311
1       1998    311
1       1999    311
1       2000    311
1       2001    311
1       2002    311
1       2003    311
1       2004    311
1       2005    311
==============================================

2nd dataset
==============================================
Industry ID             Var4
311
3114
511
61111
==============================================

3rd dataset
==============================================
Industry ID             Var4
311
3114
511
61111
==============================================

我想把2nd dataset 跟 3rd dataset 的Var4 加到1st dataset ；
2nd dataset 跟 3rd dataset 的Var4 包含的数据是同一个内容只是前者是1997的数据，后者是2002年的数据。
Key identifier 是 industry ID
请教：怎么才能把2nd dataset Var4 附加到 1st dataset 的1995-1999，而3rd dataset Var4 附加到1st dataset 的2000-2005，即如下图的样子。

======================================================
Co. ID Yr    Industry ID Var1 Var2 Var3 *Var4*
1    1995    311                         2nd
1    1996    311                         2nd
1    1997    311                         2nd
1    1998    311                         2nd
1    1999    311                         2nd
1    2000    311                         3rd
1    2001    311                         3rd
1    2002    311                         3rd
1    2003    311                         3rd
1    2004    311                         3rd
1    2005    311                         3rd
… …    …                …
======================================================

作者: shiyiming 时间: 2011-1-20 09:40
标题: Re: 求教: merge / append datasets
用hash object。

作者: shiyiming 时间: 2011-1-20 23:37
标题: Re: 求教: merge / append datasets
to mofengchenxi: 不是什么时候都适合用大杀器的.
最简单的方法：分两步来做：
1) 1993~1999;
2) 2000~2005;
[code:2egukg26]
proc sort data=s1; by id industry;
proc sort data=s2; by industry;
proc sort data=s3; by industry;
data d1;
merge s1(where=(year<=1999)) s2;
by industry;
run;
data d2;
merge s1(where=(year>=1999)) s3;
by industry;
run;
data out;
set d1 d2;
run;
[/code:2egukg26]

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