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.

How would you code the criteria to restrict the output to be produced?

9 Answers  

---

If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value?

3 Answers   Accenture,

---

Mention the category in which sas informats are placed?

0 Answers  

---

If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?

1 Answers  

---

List out some key concept of SAS

0 Answers  

---

---

how to know the attributes of first five datasets in a library

2 Answers  

---

Explain bmdp procedure?

0 Answers  

---

What is the purpose of _error_?

1 Answers   Quintiles,

---

is it possible to generate sas datasets using proc print ???

1 Answers   GSK GlaxoSmithKline,

---

Which is the best training institute for SAS in hyderabad.

112 Answers   Stansys Software Solutions,

---

why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

2 Answers   Accenture,

---

What are the differences between proc means and proc summary?

0 Answers  

---