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.

For what purpose(s) would use the RETURN statement?

1 Answers  

---

Which command is used to save logs in the external file?

0 Answers  

---

Explain by-group processing?

0 Answers  

---

how will you location sas platform applications available from web browser? : Sas-bi

0 Answers  

---

what is operational data and operational system? : Sas-di

0 Answers  

---

You have a data set of 100 observations,how can you restrict the output so that the output has only data from row no. 10 to row no. 20

9 Answers  

---

Dear all, proc means data=dsn noprint completetypes; class trtmntgroup /preloadfmt; output out=tot n=n; format trtmntgroup trtf. ; by vstgrp descending severity; run; This is the code I used for AE table. I got the values without giving the variable ‘trtmntgroup(numeric)’ in var statement. And if I give the var statement for that variable i’m getting the same values.How is that possible? What is the difference between class and var statement? Could any one explain me how does proc means work at the back end. And what is the difference between _freq_ value and N value in proc means. Thanks and regards, Rajesh.

1 Answers  

---

what is the primary variable in your study?

3 Answers   Accenture,

---

how to do user inputs and command line arguments in sas?

0 Answers   D&B, TCS,

---

Name statements that are execution only.

14 Answers   Accenture,

---

how to perform paired t-test using Base/SAS & SAS/Stat?

2 Answers  

---

What is the pound sign used for in the data_null_ ?

1 Answers  

---