楼主: crazygoing
2918 11

[原创博文] 如何这样合并数据集 [推广有奖]

11
lqyrendajinji 发表于 2011-1-7 13:30:51
use proc sql, no need to sort, but you may use order by clause

proc sql;
creat table ab as
select COALESCE(a.id,b.id) as id,  money, house, sex, race, age
from a right join b on a.id=b.id;

12
tannepeng 发表于 2011-1-27 16:18:44
data ab;

merge a b;

by ID;

run;  

正解!放心用吧!千万的用!

您需要登录后才可以回帖 登录 | 我要注册

本版微信群
加好友,备注cda
拉您进交流群
GMT+8, 2025-12-29 10:05