Interested to Buy Any Domain ? << Click Here >> for more details...
how do u test a pros sql(works or not) without executing it?
- 1 Answers
- 11180 Views
- DELL, HSBC, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How we can create SAS USER DEFINED CODE?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
How can I remove header from output data set?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
What is the difference between order and group variable in proc report?
What is the role of sas grid administrator? : sas-grid-administration
What was the last computer book you purchased? Why?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
what is null hypothesis? why do you consider that?
Did you used proc test? when?
data data1; input dt account; format dt date9.; cards; 1745 1230 1756 1120 1788 1130 1767 1240 ; data data2; input startdt enddt total; format startdt date9. enddt date9.; cards; 1657 1834 12300 1557 1758 16800 1789 1789 12300 1788 1345 12383 1899 1899 13250 ; proc sql; create table data3 as select * from data1 as x left join data2 as y on x.dt>=y.startdt and x.dt<=y.enddt; quit; Here, we are getting cartision product. But,I want left join report consisting of this program. It should not get duplicate values. you can modify the program also.
how will you location sas platform applications available from web browser? : Sas-bi
Describe a time when you were really stuck on a problem and how you solved it?
How are numeric and character missing values represented internally?
How to create an external dataset with sas code?
