Interested to Buy Any Domain ? << Click Here >> for more details...
how do u test a pros sql(works or not) without executing it?
- 1 Answers
- 11085 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 |
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
What do the put and input function do?
How many ways to overcome a missing values???
How do you specify the number of iterations and specific condition within a single do loop?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
it will become easy if uuu provide website linkssss and list of consultanciessssss
Describe the function and untility of the most difficult SAS macro that you have written.
How to read the file names of a text files from a shared drive using SAS?
what are the scrubbing procedures in sas? : Sas programming
Differentiate between format and informat? : sas-grid-administration
What is program data vector (pdv) and what are its functions?
Describe how you would pass data to macro.
Teradata 
