[程式] SAS MERGE
-----------------------------------------------------------------------------
想合併2個資料
id yq LTI HS
1101 200601 1103 23031
1101 200602 1103 23031
1101 200603 1103 23031
1101 200604 1103 23031
1101 200701 1103 23031
1101 200702 1103 23031
1101 200703 1103 23031
1101 200704 1103 23031
1101 200801 1103 23031
1101 200802 1103 23031
1101 200803 1103 25339
id yq QP QH
1103 200601 10.227 11.09
1103 200602 14.127 17.55
1103 200603 13.613 15.02
1103 200604 16.747 18.48
1103 200701 15.73 17.51
1103 200702 16.68 20.04
1103 200703 22.977 26.91
1103 200704 21.447 28.12
1103 200801 19.48 22.45
1103 200802 20.86 26.95
1103 200803 15.6 18.56
1103 200804 10.757 12.73
想要合併成
id yq LTI HS QP QH
1101 200601 1103 23031 10.227 11.09
1101 200602 1103 23031 14.127 17.55
1101 200603 1103 23031 13.613 15.02
1101 200604 1103 23031 16.747 18.48
1101 200701 1103 23031 15.73 17.51
1101 200702 1103 23031 16.68 20.04
1101 200703 1103 23031 22.977 26.91
1101 200704 1103 23031 21.447 28.12
1101 200801 1103 23031 19.48 22.45
1101 200802 1103 23031 20.86 26.95
1101 200803 1103 25339 15.6 18.56
我的想法是
DM'LOG;CLEAR;OUT;CLEAR';
PROC IMPORT OUT= C
DATAFILE= "D:\S001.xlsx"
DBMS=EXCEL REPLACE;
SHEET="S001";
proc sort;
by id yq LTI HS;
RUN;
PROC IMPORT OUT= D
DATAFILE= "D:\S002.xlsx"
DBMS=EXCEL REPLACE;
SHEET="S002";
proc sort;
by id yq QP QH ;
RUN;
data three;
merge C D ;
by id yq;
proc sort;
by id yq LTI HS QP QH ;
run;
PROC EXPORT DATA= WORK.three
OUTFILE= "D:\S003.xlsx"
DBMS=EXCEL REPLACE;
SHEET="S003";
RUN;
可是結果不是我要的
有看過 板上 SQL 跟 UPDATE 的CASE
可是還是改不出來
請問我要忘哪個方向去改比較可以得到我要的結果
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 60.244.248.49
※ 編輯: ilove10414 來自: 60.244.248.49 (10/15 15:36)
推
10/15 16:20, , 1F
10/15 16:20, 1F
推
10/15 16:27, , 2F
10/15 16:27, 2F
推
10/15 16:51, , 3F
10/15 16:51, 3F
→
10/15 16:52, , 4F
10/15 16:52, 4F
→
10/15 16:52, , 5F
10/15 16:52, 5F
→
10/15 17:15, , 6F
10/15 17:15, 6F
→
10/15 17:33, , 7F
10/15 17:33, 7F
→
10/18 23:04, , 8F
10/18 23:04, 8F
→
10/18 23:05, , 9F
10/18 23:05, 9F