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
what is the use of proc sql? : Sas programming
How to sort in descending order?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
Tell e how how dealt with..
how to do user inputs and command line arguments in sas?
Define run-group processing?
name some data transformation used in sas di? : Sas-di
how many types of prompts are there? : Sas-bi
what is information maps?
explain what is factor analysis? : Sas-administrator
What is interleaving in SAS?
What is the use of stop statement?
Why and when do you use proc sql?
What is data _null_?
How do you test for missing values?