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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5

1874


what is the basic structure sas administrator? : Sas-administrator

792


Describe a time when you were really stuck on a problem and how you solved it?

2424


Describe the function and untility of the most difficult SAS macro that you have written.

1946


What is factor analysis?

857


how to do user inputs and command line arguments in sas?

2674


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

850


where are dashboard components are created and maintained? : Sas-bi

789


What is the function of output statement in a SAS Program?

815


what do you mean by data staging area? : Sas-di

835


What are the default statistics for means procedure?

890


What is the work of tranwrd function?

959


how do you pull data from equifax?tell me the process?

1576


What are the 3 components in sas programming?

934


How does the internal authentication work in sas? : sas-grid-administration

837