→ MOONY135: 這邊是把前三欄都當成文字格式喔 09/28 20:26
我用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://www.ptt.cc/bbs/Statistics/M.1411906952.A.214.html