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 |
How to test the debugging in sas?
Describe a time when you were really stuck on a problem and how you solved it?
In SAS explain which statement does not perform automatic conversions in comparisons?
Do you prefer Proc Report or Proc Tabulate? Why?
Explain what is data step?
why is sas considered self-documenting? : Sas programming
I use NOCUM/NOPERCENT option in the tables statement like this Proc freq data = deepak; tables x y /nocum nopercent; run; Here I get nopercent and nocum in the output only for variables x and y. How do i do it for all variables? Deepak
What are the uses of sas?
Mention some common errors that are usually committed in sas programming.
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
What is your favorite all time computer book? Why?
code the tables statement for a single level frequency?