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


Please Help Members By Posting Answers For Below Questions

What can be the size of largest dataset in SAS?

729


Explain the special input delimiters used in sas programming.

589


Of all your work, where have you been the most successful?

4215


Explain the difference between nodup and nodupkey options?

615


Which are the statements whose placement in the data step is critical?

768






What is the difference between match merge and one to one merge?

697


Explain data_null_?

622


How will you generate test data with no input data?

571


How can you limit the variables written to output dataset in data step?

764


how will you location sas platform applications available from web browser? : Sas-bi

554


Compare sas with other data analytics tools.

593


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?

1775


what is proc Index? and what is proc document?

2003


How to sort in descending order?

809


What are the advantages of using sas?

619