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

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

0 Answers  


What is slibref?

0 Answers  


I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?

1 Answers  


what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

0 Answers  


how sas deals with business intelligence? : Sas-bi

0 Answers  






sas implimented companies in hyderabad

11 Answers   CTS, HSBC,


Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 Answers  


What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here

2 Answers  


Under what circumstances would you code a SELECT construct instead of IF statements?

7 Answers   Accenture,


How are the analysis data sets structured?

3 Answers  


How to convert HTML file into SAS dataset?

0 Answers  


Code a PROC MEANS that shows both summed and averaged output of the data.

5 Answers  


Categories