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 |
what versions of sas have you used (on which platforms)? : Sas programming
what is the primary variable in your study?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
What is _n_?
how do you validate sas program?
What is the difference Using & and && in the macro variables
Name statements that are recognized at compile time only?
how to display duplicated observations in a data using base sas.
13 Answers HCL, TCS,
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
if we dont want to print output what we have to do..???give syntax..???
8 Answers Accenture, GSK GlaxoSmithKline,
Can anyone help to find a statement to get all the predefined formats?
3 Answers Verinon Technology Solutions,
What is the basic structure of the SAS base program?