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

How do you specify the number of iterations and specific condition within a single do loop?

615


Can you execute a macro within a macro? Describe. : sas-macro

667


how can you import .csv file in to sas? : Sas programming

632


Differentiate input and infile.

592


What is the difference between input and infile statement?

678






What are the functions used for character handling?

635


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3056


Explain what is the use of proc gplot?

702


what is factor analysis? : Sas-administrator

607


Hi, If anyone has base SAS certification dumps, please share.

1381


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

595


what is treatment emergent events and treatment emregent adverse event

1937


What are the functions which are used for character handling functions?

608


Give some ways by which you can define the variables to produce the summary report (using proc report)?

593


Explain how merging helps to combine data sets.

607