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

do you need to know if there are any missing values? : Sas programming

548


What is the difference between the proc sql and data step?

663


What is the maximum length of the macro variable? : sas-macro

625


How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

1884


what is program data vector? : Sas-administrator

614






What do you code to create a macro? : sas-macro

580


what is sas application server? : Sas-di

541


Which function is used to count the number of intervals between two sas dates?

569


Give some examples where proc report’s defaults are same as proc print’s defaults?

642


Differences between where and if statement?

584


what r the job openings SAS for fresher graduates !

2015


how are numeric and character missing values represented internally? : Sas programming

619


In ARRAY processing, what does the DIM function do?

712


how sas deals with business intelligence? : Sas-bi

586


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2261