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


Please Help Members By Posting Answers For Below Questions

Explain why double trailing @@ is used in input statement?

829


what are _numeric_ and _character_ and what do they do? : Sas programming

916


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4167


Name types of category in which SAS Informats are placed?

954


How do you debug and test your SAS programs?

1299


it will become easy if uuu provide website linkssss and list of consultanciessssss

1764


What is the difference between input and infile statement?

906


How does the internal authentication work in sas? : sas-grid-administration

849


explain the difference between proc means and proc summary?

898


name the scheduler for scheduling job and explain the scheduler? : Sas-di

833


Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2026


what do you mean by data staging area? : Sas-di

859


How substr function works in sas?

919


What are the features of SAS?

821


What would be the value of month at the end of data step execution and how many observations would be there?

821