We can do it in two different ways A. using Noexec option B using Validate option
Noexec option checks the all queries written in Proc sql step while Validate checks only single query.
Proc sql noexec; create table stu as select name from student; create table emp as select empname from employee; quit; In this example noexec will check the syntex of both query. proc sql; validate select * from emp; validate select * from stu; quit;
In this validate will check each query individually.
Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!