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.

what does .. meant in sas macros

3 Answers   D&B,

---

what is sas? is a package or tool? give me introduction about sas?

11 Answers   Accenture,

---

What are the statements in proc sql?

0 Answers  

---

How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?

1 Answers   Quintiles,

---

what versions of sas have you used (on which platforms)? : Sas programming

0 Answers  

---

There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT

8 Answers   D&B,

---

what is the diff. b/w proc means and proc summary?

12 Answers   CitiGroup,

---

What data sets do you need to produce the report?

2 Answers   Novartis,

---

What are the statements that are executed only?

0 Answers  

---

How do you add a number to a macro variable?

2 Answers  

---

What is the role of unrestrictive users? : sas-grid-administration

0 Answers  

---

How do you put an elephant in the refrigerator?

6 Answers   Oracle,

---