Re: [問題] SAS proc sql的問題
proc sql;
creat table c
as select
a.var1 as var1,
a.var2 as var2,
b.var3 as var3
from d003 a, d004 b
where (a.var1=b.var1);
quit;
用這個語法看看
※ 引述《hanjing (心寬念純)》之銘言：
: ※ 引述《west1996 (焦了六年變脆了)》之銘言：
: : 剛剛推文漏了一行
: : 改用回的好了
: : proc sql;
: : creat table c as
: : select coalesce(a.var1,b.var1) label='var1',a.var2,b.var3
: : from a full joint b
: : on a.var1=b.varl;
: : quit;
: 我試了
: proc sql;
: create table c as
: select coalesce( d003.f1,d004.f1 ) label='f1',d003.f2,d004.f3
: from d003 full join d004 on d003.f1=d004.fl;
: quit;
: 出現了error
: ERROR: Column fl could not be found in the table/view identified with the
: correlation name D004.
: ERROR: Column fl could not be found in the table/view identified with the
: correlation name D004.
: ERROR: Expression using equals (=) has components that are of different data
: types.
: 但是我確定f1這個是樣本的流水號沒錯
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 125.225.33.56
※ 編輯: tew 來自: 125.225.33.56 (04/10 20:32)
※ 編輯: tew 來自: 125.225.32.247 (04/11 09:25)
討論串 (同標題文章)
本文引述了以下文章的的內容：
完整討論串 (本文為第 7 之 7 篇)：