how do u test a pros sql(works or not) without executing it?
- 1 Answers
- 10693 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 is TAB delimiter? explain about it? what will you do to get TAB delimiter?
is it possible to generate sas datasets using proc print ???
1 Answers GSK GlaxoSmithKline,
Difference between sum function and using “+” operator?
what are the scrubbing procedures in sas? : Sas programming
What is the work of tranwrd function?
What is the use of %include statement?
Describe 5 ways to do a “table lookup” in SAS?
We want to merge file A and B. File A has variable age, file B provide birthdate. How to merge the data according to age in file B
what are different type of sas servers ? On which server does the sas code execute ?
What is slibref?
Can anyone help to find a statement to get all the predefined formats?
3 Answers Verinon Technology Solutions,
Explain how merging helps to combine data sets.
Teradata 
