Interview Questions   Tutorials   Discussions   Programs   Videos   

SAS - How do you test a pros sql(works or not) without executing it?




373
views
asked mar September 20, 2014 06:29 AM  

How do you test a pros sql(works or not) without executing it?


           

1 Answers



 
answered By vishnoiprem   0  

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.

syntax:

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.

flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  Question tags

sas × 1

Asked 2 years and 3 months ago ago
Number of Views -373
Number of Answers -1
Last updated
3 years and 2 months ago ago

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!

Alert