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
How can you create a macro variable with in data step? : sas-macro
explain the main difference between the nodup and nodupkey options? : Sas-administrator
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
What is the use of the %include statement?
What is the maximum length of the macro variable?
How do you add a number to a macro variable? : sas-macro
what is the difference between unique key and primary key? : Sas-di
Do you need to rearrange the order of the data for the report?
Difference between sum function and using “+” operator?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What is the difference between using drop = data set option in data statement and set statement?
What is interleaving in SAS?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
what is the purpose of _error_? : Sas programming