Hi @cieffegi, glad to hear it is working and thanks for marking a post as the solution.
I was going to suggest using validate which "Checks the accuracy of a query expression's syntax and semantics without executing the expression" to see if that gave any clues, and when I tried it after substituting sashelp table names in place of yours:
proc sql;
/* create table last_positions as */
validate
select distinct
a.*,
substr(b.name,2,1) AS numerical_rating
from sashelp.cars as a
left join sashelp.class as b
on a.make = b.name and a.cylinders = b.age
;
quit;
no issues were reported:
73 proc sql;
74 /* create table last_positions as */
75 validate
76 select distinct
77 a.*,
78 substr(b.name,2,1) AS numerical_rating
79
80 from sashelp.cars as a
81 left join sashelp.class as b
82 on a.make = b.name and a.cylinders = b.age
83 ;
NOTE: PROC SQL statement has valid syntax.
84 quit;
So you might find using it useful in future.
Thanks & kind regards,
Amir.
... View more
