how do u test a pros sql(works or not) without executing it?
- 1 Answers
- 10645 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 do the sas log messages “numeric values have been converted to character” mean? What are the implications?
name few built in sas transformation in DI studio ?
Differentiate between format and informat? : sas-grid-administration
You need to perform an analysis on a massive dataset by groups, but are unable to sort the data due to memory constraint. How would you accomplish the task?
How the Excel file enter into the SAS environment without Code of Infile & Import procs,if i have no file Conversion?
Name statements that are recognized at compile time only?
Code the MEANS to produce output to be used later.
What is the use of divide function?
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?
What is the use of %include statement?
What is the purpose of _error_?
What is SAS?
Teradata 
