Answer Posted / 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.

explain the main difference between the nodup and nodupkey options? : Sas-administrator

1106

---

What versions of SAS have you used (on which platforms)?

1456

---

what is the one statement to set the criteria of data that can be coded in any step? : Sas programming

1089

---

what is data access? : Sas-di

1079

---

Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??

2552

---

what is the difference between nodup and nodupkey options? : Sas programming

1112

---

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3529

---

What do the sas log messages “numeric values have been converted to character” mean? What are the implications?

1137

---

Name few SAS functions?

1041

---

what is the effect of the options statement errors=1? : Sas programming

1000

---

What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?

1099

---

How to create list output for cross-tabulations in proc freq?

1060

---

Have you ever used the SAS Debugger?

1693

---

where are dashboard components are created and maintained? : Sas-bi

967

---

What is the use of function Proc summary?

1210

---