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
Describe the function and untility of the most difficult SAS macro that you have written.
How do you add a number to a macro variable? : sas-macro
What are symget and symput? : sas-macro
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
How many data types are there in SAS?
What do the SAS log messages "numeric values have been converted to character" mean?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
is data integration and etl programming is same? : Sas-di
what is change analysis in sas di ? : Sas-di
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
How do you connect the desktop application to metadata server? : sas-grid-administration
Do you need to rearrange the order of the data for the report?
What is the role of administrative users? : sas-grid-administration
Describe the function and untility of the most difficult SAS macro that you have written.
what is slowly changing dimension? : Sas-di