Re: [程式] SAS 合併資料
我先用你的例子 假設兩個DATE
DATA AA;INPUT COMPANY $ DATE YYMMDD8.; FORMAT DATE YYMMDDN8.;
CARDS;
A 20010101
A 20010102
B 20010101
B 20010102
C 20010101
C 20010102
D 20010101
D 20010102
;
RUN;
DATA BB;INPUT COMPANY $ DATE YYMMDD8.; FORMAT DATE YYMMDDN8.;
CARDS;
A 20010201
A 20010202
D 20010201
D 20010202
E 20010201
E 20010202
;
RUN;
然後我再把兩個資料都有的COMPANY找出來
PROC SORT DATA=AA NODUPKEY OUT=A1(KEEP=COMPANY);BY COMPANY;
PROC SORT DATA=BB NODUPKEY OUT=B1(KEEP=COMPANY);BY COMPANY;
DATA COMPANY;MERGE A1( IN=A) B1( IN=B) ;BY COMPANY;IF A=B;RUN;
再將兩組資料都有的COMPANY串回原資料
PROC SORT DATA=AA;BY COMPANY;
PROC SORT DATA=BB;BY COMPANY;
DATA AA1;MERGE AA( IN=A) COMPANY( IN=B);BY COMPANY;IF A=B;RUN;
DATA BB1;MERGE BB( IN=A) COMPANY( IN=B);BY COMPANY;IF A=B;RUN;
DATA CC;SET AA1 BB1;RUN;
PROC SORT DATA=CC;BY COMPANY DATE;RUN;
這是我想到的方法,也許你會覺得有些搞工XD
就參考看看囉~~
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.43.126.223
討論串 (同標題文章)