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


Please Help Members By Posting Answers For Below Questions

what is snowflake schema? : Sas-di

696


How do dates work in sas?

645


what is program data vector? : Sas-administrator

614


what are sas/access and sas/connect? : Sas programming

548


In sas admin differentiate between roles and capabilities? : sas-grid-administration

556






Mention what is SAS data set?

677


Explain the use of proc gplot? : sas-grid-administration

556


What would you change about your job?

1926


how the sas basic syntax style described? : Sas-administrator

608


Describe a time when you were really stuck on a problem and how you solved it?

2086


How to create an external dataset with sas code?

588


What can you learn from the SAS log when debugging?

921


Mention the difference between ceil and floor functions in sas?

648


Name types of category in which SAS Informats are placed?

736


This entry was posted in General. Bookmark the permalink. Post a comment or leave

4041