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
What are the implications?
How necessary is it to be creative in your work?
Explain input and put function?
What is the work of tranwrd function?
What is the basic syntax style in SAS?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
what are the considerations when picking a SAS/STAT procedure?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
what are the component of range? : Sas-bi
What are types of transport files?
how are numeric and character missing values represented internally? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
what is the basic structure sas administrator? : Sas-administrator
What is the difference between order and group variable in proc report?
name the scheduler for scheduling job and explain the scheduler? : Sas-di