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 are some good SAS programming practices for processing very large data sets?

6 Answers   Quintiles,

---

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

0 Answers  

---

Hi, I need to create a SAS Map of USA using SAS Graphs(Proc Gmap).The data i have dosent contain any co-ordinates of USA cities or counties or states, and the zip codes are diffrent in the data i have from the zip code in the Maps.US dataset in the Maps Library for SAS MAPS. the data i have is a sales report. i have to generate the maps according to the states,cities aligned in the sales data, HELP Appriciated

1 Answers  

---

What are TEAEs

2 Answers   Accenture, Quintiles,

---

Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..

1 Answers  

---

%STPbegin;%STPEND; ERROR: No logical assign for filename _WEBOUT. WARNING: No body file. HTML output will not be created. unable to fix it.plz help

2 Answers  

---

sas implimented companies in hyderabad

11 Answers   CTS, HSBC,

---

What are types of transport files?

2 Answers   PRA Health Sciences, Quintiles,

---

Mention sas system options to debug sas macros.

0 Answers  

---

How to find out no. of business days in a month using macros.???(excluding weekends and holidays).

2 Answers   HSBC,

---

what is sas enterprise intelligence architecture? : Sas-bi

0 Answers  

---

data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks

3 Answers  

---