Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


how do u test a pros sql(works or not) without executing it?



how do u test a pros sql(works or not) without executing it?..

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.

Is This Answer Correct ?    29 Yes 0 No

Post New Answer

More SAS Interview Questions

you have a data set like this. data qqq; input name $ total; cards; qq 22 ww 33 qq 22 ee 44 rr 33 ww 44 ; run; and you want output like this......... name total qq 22 ww 44 Do it by data set step.

6 Answers  


If a variable contains letters or special characters, can it be numeric data type?

0 Answers  


Approximately what date is represented by the SAS date value of 730?

0 Answers  


What is the one statement to set the criteria of data that can be coded in any step?

4 Answers   Accenture,


What are the limitations for memory allocation for SAS variables

0 Answers   Signetsoft,


describe how to adjust the performance of data integrator? : Sas-di

0 Answers  


What is the maximum length of the macro variable?

0 Answers  


i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;

0 Answers   L&T,


How experienced are you with customized reporting and use of Data _Null_ features?

4 Answers   Oracle,


wat is sas? is a package or programming language?

4 Answers  


what is information maps?

0 Answers   CitiGroup,


How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C

3 Answers   Accenture, Oracle,


Categories