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.

For clinical entire study how many tables will create approx?

1917

---

what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

1005

---

what is hierarchy flattening? : Sas-di

1039

---

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

1011

---

What is data _null_?

1089

---

what is proc Index? and what is proc document?

2644

---

What are all the problems you faced while validating tables and reports?

3410

---

Mention the difference between ceil and floor functions in sas?

1110

---

What are the difference between ceil and floor functions in sas?

1288

---

If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1118

---

Mention what is SAS data set?

1100

---

which date functions advances a date time or date/time value by a given interval? : Sas programming

914

---

what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

1084

---

What are the applications primarily used by business analyst? : Sas-bi

950

---

What is the work of tranwrd function?

1189

---