Proc sql where error message

tsetredst — Tue, 30 Aug 2016 01:55:30 GMT

Hi,

I am getting the following error when running code. The error indicates that the multiple "." in my where statement is incorrect.

Syntax error, expecting one of the following: ;, !, !!, &, *, **, +, -, /, <, <=,
<>, =, >, >=, ?, AND, BETWEEN, CONTAINS, EQ, EQT, EXCEPT, GE, GET, GROUP, GT, GTT,
HAVING, IN, INTERSECT, IS, LE, LET, LIKE, LT, LTT, NE, NET, NOT, NOTIN, OR, ORDER,
OUTER, UNION, ^, ^=, |, ||, ~, ~=.

proc sql;
create table sorted_2.sec_1 as
select * from sorted_2.sec_1, sorted_2.eod
where sorted_2.sec_1.date_L_ = sorted_2.eod.date_L_ and sorted_2.sec_1._ric = sorted_2.eod._ric;
run;

Any help would be great - thanks!

Re: Proc sql where error message

LinusH — Wed, 31 Aug 2016 04:20:10 GMT

SAS only support two level names.

So you need to define aliases in your FROM clause.

topic Proc sql where error message in SAS Procedures

Proc sql where error message

Re: Proc sql where error message