全部版块 我的主页
论坛 数据科学与人工智能 数据分析与数据科学 SAS专版
3350 1
2018-09-07
求助, sas如何一对一匹配
比如我有两组数据, 一组控制组一组处理组, 要求的是对于处理组的每一个样本,选择控制组中年龄相同,体重差异最小的作为匹配对象,这种应该怎么处理啊?
我使用的方式是proc sql, 具体代码如下
PROC SQL;
CREATE table controls_id
as select
one.id as treat_id,
two.id as control_id,
one.age as treat_age,
two.age as control_age,

one.weight as treat_weight,
two.weight as control_weight,
abs(one.weight - two.weight) as diff
from treat one, control two
where ( one.age=two.age )
group by one.id having calculated diff = min(calculated diff);
run;

麻烦各位大神帮我看一下,谢谢!
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

全部回复
2018-9-10 11:05:00
PROC SQL;
CREATE table controls_id as select
one.id as treat_id,  two.id as control_id,
one.age as treat_age,  two.age as control_age,
one.weight as treat_weight, two.weight as control_weight,
abs(1-two.weight/one.weight) as diff
/*
我建议改成 差异比例  因为很多研究针对 多个变量建构 最后会变成 总和相加最小的样本
所以应该用比例比较好
*/
from treat one, control two
where ( one.age=two.age )
group by one.id having calculated diff = min(calculated diff);
run;
二维码

扫码加我 拉你入群

请注明:姓名-公司-职位

以便审核进群资格,未注明则拒绝

相关推荐
栏目导航
热门文章
推荐文章

说点什么

分享

扫码加好友,拉您进群
各岗位、行业、专业交流群