[問題] sas 的merge問題
想請教SAS的MERGE問題
我要合併兩個年度的資料 依照ID來合併
以下是合併指令:
data test;
set aa;
proc sort out=a;
by id;
run;
data test2;
set bb;
proc sort out=b;
by id;
run;
data new;
set b a;
merge a(in=ina) b(in=inb);
by id;
if a and inb then output ;
run;
LOG檔為:
NOTE: Variable a is uninitialized.
NOTE: There were 61142 observations read from the data set WORK.B.
NOTE: There were 60036 observations read from the data set WORK.A.
NOTE: There were 60044 observations read from the data set WORK.A.
NOTE: There were 61142 observations read from the data set WORK.B.
NOTE: The data set WORK.NEW has 0 observations and 87 variables.
NOTE: DATA statement used (Total process time):
real time 0.43 seconds
cpu time 0.40 seconds
想請問為何在NEW中沒有觀察值呢?
另外 我合併很多筆資料
同樣的語法 有的資料可以合併 有的卻出現以上的情況
請問是哪裡出了問題嗎?
謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.112.92.101
推
09/10 19:12, , 1F
09/10 19:12, 1F
→
09/10 19:21, , 2F
09/10 19:21, 2F
→
09/10 19:21, , 3F
09/10 19:21, 3F
推
09/11 01:15, , 4F
09/11 01:15, 4F
推
09/11 01:15, , 5F
09/11 01:15, 5F
推
09/11 01:16, , 6F
09/11 01:16, 6F
討論串 (同標題文章)
以下文章回應了本文：
完整討論串 (本文為第 1 之 3 篇)：