how do u test a pros sql(works or not) without executing it?
- 1 Answers
- 10607 Views
- DELL, HSBC, I also Faced
- E-Mail Answers
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 |
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What are TEAEs
2 Answers Accenture, Quintiles,
What are the main differences between sas versions 8.2, 9.0, 9.1?
Explain translate function?
name the scheduler for scheduling job and explain the scheduler? : Sas-di
in ods is there any lib's
Describe crosslist option in tables statement?
Under what circumstances would you code a SELECT construct instead of IF statements?
Explain why double trailing @@ is used in input statement?
Have you ever linked SAS code, If so, describe the link and any required statements used to either process the code or the step itself?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
what is the use of catalog?
Teradata 
