作者milkbottle (milkbottle)
看板Statistics
标题[问题] 有关sas配对问题
时间Tue Sep 1 00:51:11 2009
目前所做研究是希望进行case组与control组配对~
配对条件为:
年龄加减五岁以及居住地相同
上网找寻资料後~
发现了这个语法~
/*定义区间值*/
data control2;
set control;
age_h=age+1; /*可接受的年龄上限*/
age_l=age-1; /*可接受的年龄下限*/
run;
Proc sql;
create table match
as select
one.id as study_id,
two.id as control_id,
one.age as study_age,
two.age as control_age,
one.bmi as study_bmi,
two.bmi as control_bmi,
one.rand_num as rand_num
from study one, control2 two
where ((one.age between two.age_l and two.age_h) /*区间配对*/
and one.bmi=two.bmi);
可是看不懂=>one和two的意思~
为什麽需要写one和two??
还是说有其他写法~希望会的大大教我一下~
谢谢大家~
(不知道这个是否可以在这问~如不行会自d)
--
--
※ 发信站: 批踢踢实业坊(ptt.cc)
◆ From: 61.229.135.32
1F：推 memphis:是从这来的 from study (as) one, control2 (as) two 09/01 01:19
2F：→ memphis:表示 study.ID ,control2.ID 09/01 01:19