PROC SQL always ends with QUIT statement.Why cant you use
RUN in PROQ SQL ?

Answers were Sorted based on User's Feedback



PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?..

Answer / richa

The PROC SQL step does not require a RUN statement. PROC
SQL executes each query automatically. If you use a RUN
statement with a PROC SQL step, SAS ignores the RUN
statement, executes the statements as usual, and generates
the note shown below in the SAS log:

NOTE: PROC SQL statements are executed immediately;
The RUN statement has no effect.

As per SAS certification guide.

Is This Answer Correct ?    47 Yes 0 No

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?..

Answer / 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

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?..

Answer / cutepa1

The diff b/n QUIT n RUN is very simple here.... Using a RUN statement one can generate a result for an SQL statement and without terminating the procedure one can continue on the same Procedure with other SQL statements and generate another result using one more RUN statements. This can be done until a QUIT statement is executed or another PROC step or DATA step is initialised ...

Is This Answer Correct ?    5 Yes 0 No

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?..

Answer / ayetullah

SQL is a non-sas product.WE use RUN statement only with the
SAS codes.Though we can use SQL also and stop the data block
by using QUIT.

Is This Answer Correct ?    3 Yes 3 No

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?..

Answer / bm

Thank you both for the answers.

But they were basically asking about the internal
processing of QUIT statement. the question was like 'Why
cant SAS recognise RUN as an ending statement in PROC SQL?'.

I heard from someone that PROC SQL is not native to SAS(i
am not very clear by this) and hence a QUIT statement is
required.

any feedback ?

Is This Answer Correct ?    1 Yes 2 No

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?..

Answer / sandeep

I dont know the exact ans for the what was the internal
process...

here is what I understand is..

some procedures result (output window) can be seen only
using Run statement only... It means we can see the output
only we the procedure is running (so here we use RUN
statement at end of the programme).

where as some procedures result (output window) will be only
after terminating the programme running... so here we use
QUIT statement to terminate the programme. (If we use run
statement the programme is excuted asausual and result is
displayed but the editor window is displayed front of the
output window showing the programme is running)

if anyone know the internal process about this... pls post
the ans.

Is This Answer Correct ?    0 Yes 1 No

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?..

Answer / dipak

If PROC SQL is ended with Run statement then there will be
no output generated in output window. however if 'Create
table ... as' command is given in proc sql then it will
create the table.

Quit tells SAS to print output to output window, if to be
printed.

Is This Answer Correct ?    1 Yes 8 No

Post New Answer

More SAS Interview Questions

"What is the difference between proc sort nodup and proc sort nodupkey?"

2 Answers  


what are the categories that sas informats are used to the place the data? : Sas-administrator

0 Answers  


I am looking to buy a sas advance book. So any one can guide me that which one i should buy.

0 Answers  


Name statements that function at both compile and execution time.

7 Answers   Accenture,


How would you combine 3 or more tables with different structures?

7 Answers  






How to Rename Library?

3 Answers  


calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 Answers  


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

0 Answers  


what is a post baseline?

2 Answers   Accenture,


Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 Answers  


what are the component of range? : Sas-bi

0 Answers  


how do we mail reports from SAS environment to our team leader

5 Answers   Wockhardt,


Categories