how do u test a pros sql(works or not) without executing it?
- 1 Answers
- 10358 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 |
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
What is by-group processing?
Which of the following is not created during compilation phase?
Mention sas system options to debug sas macros.
Have you used macros? For what purpose you have used? : sas-macro
What is substr function?
what is null hypothesis? why do you consider that?
0 Answers Accenture, Quintiles,
How to get part of string form the source string without using sub string function in SAS?
Explain the purpose of retain statement.
Difference between sum function and using “+” operator?
Explain the special input delimiters used in sas programming.
How experienced are you with customized reporting and use of Data _Null_ features?
Teradata 
