PROC SQL always ends with QUIT statement.Why cant you use
RUN in PROQ SQL ?

Answer Posted / richa

The PROC SQL step does not require a RUN statement. PROC
SQL executes each query automatically. If you use a RUN
statement with a PROC SQL step, SAS ignores the RUN
statement, executes the statements as usual, and generates
the note shown below in the SAS log:

NOTE: PROC SQL statements are executed immediately;
The RUN statement has no effect.

As per SAS certification guide.

Is This Answer Correct ?    47 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between input and infile statement?

906


what is sas database server? : Sas-di

834


Name few SAS functions?

890


Mention sas system options to debug sas macros.

941


Explain what is the use of proc gplot?

927


How will you generate test data with no input data?

843


Hi, If anyone has base SAS certification dumps, please share.

1637


explain the use of % includes a statement in sas? : Sas-administrator

780


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

906


what is sas data set?

881


Mention the validation tools used in SAS?

889


How can you create a macro variable with in data step? : sas-macro

797


What are the special input delimiters used in SAS?

890


what is the function of catx syntax? : Sas-administrator

884


Explain how you can debug and test your SAS program?

771