PROC SQL always ends with QUIT statement.Why cant you use
RUN in PROQ SQL ?
Answer Posted / sandeep
I agree with the above ans and here is little more addition
to the above one is
if you give the run statement SAS ignores the run statement
and executes the query as usual but in editor window you can
see that the query is still running (PROC SQL RUNNING), we
can terminate the proc sql queries with Quit statement only.
like wise in SAS some procedures can be terminated with Run
statements (ex: proc print, proc append) and some procedures
can be terminated with Quit statement only (ex: proc sql).
more views welcome...
Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
What can be the size of largest dataset in SAS?
Explain the special input delimiters used in sas programming.
Of all your work, where have you been the most successful?
Explain the difference between nodup and nodupkey options?
Which are the statements whose placement in the data step is critical?
What is the difference between match merge and one to one merge?
Explain data_null_?
How will you generate test data with no input data?
How can you limit the variables written to output dataset in data step?
how will you location sas platform applications available from web browser? : Sas-bi
Compare sas with other data analytics tools.
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what is proc Index? and what is proc document?
How to sort in descending order?
What are the advantages of using sas?