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.

Mention the validation tools used in SAS?

658

---

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

549

---

Mention the difference between ceil and floor functions in sas?

650

---

What is the difference between order and group variable in proc report?

843

---

How to limit decimal places for the variable using proc means?

605

---

---

what is change analysis in sas di ? : Sas-di

606

---

How can you create a macro variable with in data step? : sas-macro

578

---

what is metadata? : Sas-bi

602

---

What function CATX syntax does?

690

---

What are the ways to do a “table lookup” in sas?

595

---

Explain why double trailing @@ is used in input statement?

577

---

Explain how you can debug and test your SAS program?

565

---

How to read an input file in sas?

656

---

What are the advantages of using sas?

611

---

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

1802

---