how do u test a pros sql(works or not) without executing it?
- 1 Answers
- 10357 Views
- DELL, HSBC, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What are the automatic variables for macro? : sas-macro
Tell e how how dealt with..
What is Linear Regression?
What are the parameters of scan function?
List out some key concept of SAS
Explain bmdp procedure?
how do you pull data from equifax?tell me the process?
how can you create zero observation dataset? : Sas programming
What is the function of output statement in a SAS Program?
What is a macro routine?
What are the table names in oracle database...?
how to generate the test data in sas without input data? : Sas-administrator
why is sas data integration studio important? : Sas-di
What are the applications primarily used by business analyst? : Sas-bi
what is slowly changing dimension? : Sas-di
