作者MOONY135 (谈无慾)
看板Statistics
标题Re: [程式] SAS 资料合并
时间Sun Sep 28 20:22:30 2014
我用SAS SQL语法
CAT就是把你那三栏并起来用以比对
/*table A*/
PROC SQL;
CREATE TABLE work.tableA_step1 AS
SELECT 'J_edu_f'n,
'J_edu_m'n,
'J_dep_f'n,
catx('','J_edu_f'n , 'J_edu_m'n,'J_dep_f'n) as 'A_compare'n
FROM WORK.'tableA'n
order by 'A_compare'n /*排序只是好看*/
;
QUIT;
/*table B*/
PROC SQL;
CREATE TABLE work.tableB_step1 AS
SELECT 'edu_f'n,
'edu_m'n,
'dep_f'n,
catx('','edu_f'n , 'edu_m'n,'dep_f'n) as 'B_compare'n,
'height'n,
'weight'n
FROM WORK.'tableB'n
order by 'B_compare'n /*排序只是好看一点*/
;
QUIT;
/*把两张表inner join*/
PROC SQL;
CREATE TABLE WORK.最终结果 AS
SELECT t1.J_edu_f,
t1.J_edu_m,
t1.J_dep_f,
t2.height,
t2.weight
FROM WORK.TABLEA_STEP1 t1
INNER JOIN
WORK.TABLEB_STEP1 t2
ON (t1.A_compare = t2.B_compare); /*当两边相等的时候就合并*/
QUIT;
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 111.254.142.36
※ 文章网址: http://webptt.com/cn.aspx?n=bbs/Statistics/M.1411906952.A.214.html
1F：→ MOONY135: 这边是把前三栏都当成文字格式喔 09/28 20:26