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 |
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What is slibref?
I am having a stored process.it needs to route my report to both hthml and Xls.By default SP routes to html.I used the PRINTTO to route the html to Xls.BUt it createsthe file not but no content was written to file(0KB)?how can i do it?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
how sas deals with business intelligence? : Sas-bi
sas implimented companies in hyderabad
Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks
What would the following datastep do? Data _null_; Set Dist end=eof; Call Symput("xx"!!left(put(_n_,2.)),&dimension); If EOF then Call Symput('numrows',left(put(_n_,2.))); Run; dimension is a macro variable that is being passed here
Under what circumstances would you code a SELECT construct instead of IF statements?
How are the analysis data sets structured?
How to convert HTML file into SAS dataset?
Code a PROC MEANS that shows both summed and averaged output of the data.