m*******g 发帖数: 3044 | 1 proc sql;
create table p.QIs_Q1 as
select
a.ProvNum, b.name, b.measuretitle, b.score
From
p.TX_NUMs a
p.residents_q1 b
where a.provnum=b.provnum
quit;
错误MESSAGE :
107 from
108 p.TX_NUMs a
109 p.residents_q1 b
---
22
76
ERROR 22-322: Syntax error, expecting one of the following: GROUP, HAVING,
ORDER, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
110
111 where a.provnum=b.provnum
112
113 114
115
116 quit; | d******9 发帖数: 404 | 2 p.TX_NUMs a
p.residents_q1 b
You probably omit a "," comma.
From p.TX_NUMs a , p.residents_q1 b | m*******g 发帖数: 3044 | 3 谢谢...
再问一个问题,我可以用LEFT JOIN 吗在WHERE里? a.provnum=b.provnum 是INNER JOIN
吧
【在 d******9 的大作中提到】 : p.TX_NUMs a : p.residents_q1 b : You probably omit a "," comma. : From p.TX_NUMs a , p.residents_q1 b
| d******9 发帖数: 404 | 4 Of course.
proc sql;
create table p.QIs_Q1 as
select a.ProvNum, b.name, b.measuretitle, b.score
From p.TX_NUMs a left join p.residents_q1 b
on a.provnum=b.provnum;
quit; | m*******g 发帖数: 3044 | | f******1 发帖数: 119 | 6 就是,倒数第二句少了分号。以后仔细点就好。如果懒的仔细,就看看ERROR MESSAGE,
尤其是这种‘Syntax error, expecting ...’,大多就是粗心造成的。 |
|