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 to merge the data using merge statement and proc format? Is the result is same ?

2 Answers  

---

what are input dataset and output dataset options?

6 Answers   HCL,

---

what is fact table and factless table?

1 Answers  

---

what is SAS/Access and SAS/Connect?what are the uses?

3 Answers  

---

If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?

7 Answers   Accenture,

---

What is the Program Data Vector (PDV)? What are its functions?

5 Answers   Accenture,

---

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

0 Answers  

---

How we can create SAS USER DEFINED CODE?

0 Answers  

---

SAS using companies in chennai

1 Answers  

---

name the scheduler for scheduling job and explain the scheduler? : Sas-di

0 Answers  

---

6) Explain about below automatic variables a) _N_ b) _ERROR_ c) _CHAR_ d) _NUMERIC_ e) _ALL_ f) FIRST.BY VARIABLE g) LAST.BY VARIABLE h) _NAME_ i) _TYPE_ j) _FREQ_ k) _STAT_ l) _BREAK

1 Answers   IBM, SAS,

---

How are numeric and character missing values represented internally?

0 Answers   Quintiles,

---