how do u test a pros sql(works or not) without executing it?



how do u test a pros sql(works or not) without executing it?..

Answer / amit gupta

you have 2 different ways for that.
1. using Noexec option
2 using Validate option

Noexec option checks the all queries written in proc sql
step while Validate checks only single query.

syntex:
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.

Is This Answer Correct ?    29 Yes 0 No

Post New Answer

More SAS Interview Questions

How to test the debugging in sas?

0 Answers  


Describe a time when you were really stuck on a problem and how you solved it?

1 Answers  


In SAS explain which statement does not perform automatic conversions in comparisons?

0 Answers  


Do you prefer Proc Report or Proc Tabulate? Why?

9 Answers   Oracle,


Explain what is data step?

0 Answers  






why is sas considered self-documenting? : Sas programming

0 Answers  


I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak

1 Answers  


What are the uses of sas?

0 Answers  


Mention some common errors that are usually committed in sas programming.

0 Answers  


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

0 Answers   SAS,


What is your favorite all time computer book? Why?

0 Answers   Oracle,


code the tables statement for a single level frequency?

2 Answers  


Categories