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 are the statements that are executed only?
How would you define the end of a macro? : sas-macro
What are the difficulties u faced while doing vital signs table or dataset?
what is function of retain statment
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Give some examples where proc report’s defaults are same as proc print’s defaults?
What are the implications?
what is study design in while working with SAS? what are screening variables in SAS?
explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di
How are numeric and character missing values represented internally?
how do you want missing values handled? : Sas programming
explain about data integrator metadata reports? : Sas-di
How to create an external dataset with sas code?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
Why and when do you use proc sql?