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

In proc transpose and data step with arrays which one you pick?

2584


What is substr function?

632


How can sas program be validated?

585


what is SAS OPTIMIZATION?

1823


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

578






If money were no object, what would you like to do?

2697


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

577


how do you debug and test your sas programs? : Sas programming

571


what is the use of proc sql? : Sas programming

604


is data integration and etl programming is same? : Sas-di

586


how will you locate the sas platform applications? : Sas-bi

590


What areas of SAS are you most interested in?

1074


what are the best practices to process the large data sets in sas programming? : Sas-administrator

549


What are the special input delimiters used in SAS?

663


name the scheduler for scheduling job and explain the scheduler? : Sas-di

610