Re: [程式] sas 如何用sql inner join??
※ 引述《donnawang (donnawang)》之銘言:
: 如何用sql取代下面的data step??
: data P;
: merge A (in = x) B (in =y keep=var2 var3 var1);
: by var2 var3;
: if x = 1 and y = 1;
: run;
: 我試著
: Proc sql;
: create table test_inner as
: select a.*,var1
: from a inner join b
: on a.var2,var3 =b.var2,var3
^^^^^^^^^^^ ^^^^^^^^^^^^
請說明你這句話的意思
這是英文 意思就是
a的變項2, 變項3(不是指單一檔案)=b的變項2, 變項3(不是指單一檔案)
: ;
: quit;
: 卻卡在on "="
: ERROR 22-322: Syntax error, expecting one of the following: a name, ;, (,
: ',', '.', ANSIMISS, AS, CROSS, EXCEPT, FULL,
: GROUP, HAVING, INNER, INTERSECT, JOIN, LEFT, NATURAL, NOMISS,
: ORDER, OUTER, RIGHT, UNION, WHERE.
: ERROR 76-322: Syntax error, statement will be ignored.
: 不知道是哪裡出錯了??謝謝~
--
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 122.228.188.111
※ 文章網址: http://www.ptt.cc/bbs/Statistics/M.1417863374.A.3EC.html
推
12/06 21:04, , 1F
12/06 21:04, 1F
→
12/06 21:04, , 2F
12/06 21:04, 2F
→
12/07 10:30, , 3F
12/07 10:30, 3F
→
12/07 14:48, , 4F
12/07 14:48, 4F