PROC SQL always ends with QUIT statement.Why cant you use
RUN in PROQ SQL ?
Answer Posted / sandeep
I agree with the above ans and here is little more addition
to the above one is
if you give the run statement SAS ignores the run statement
and executes the query as usual but in editor window you can
see that the query is still running (PROC SQL RUNNING), we
can terminate the proc sql queries with Quit statement only.
like wise in SAS some procedures can be terminated with Run
statements (ex: proc print, proc append) and some procedures
can be terminated with Quit statement only (ex: proc sql).
more views welcome...
| Is This Answer Correct ? | 22 Yes | 0 No |
Post New Answer View All Answers
What is the role of administrative users? : sas-grid-administration
How to create an external dataset with sas code?
How would you determine the number of missing or nonmissing values in computations?
what is factor analysis? : Sas-administrator
Mention sas system options to debug sas macros.
Explain by-group processing?
How do you add a number to a macro variable? : sas-macro
how to debug and test the sas program? : Sas-administrator
how do the in= variables improve the capability of a merge? : Sas programming
How substr function works in sas?
what is the difference between nodup and nodupkey options? : Sas programming
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
for whom is sas data integration studio designed? : Sas-di
How do dates work in sas?
For what purpose would you use the RETAIN statement?