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 categories that sas informats are used to the place the data? : Sas-administrator
Enlist the syntax rules followed in sas statements.
How to convert a numeric variable to a character variable?
What will calendar procedure do?
Explain the purpose of retain statement.
what is hash files in sas and why we are using this one in sas?
How do you control the number of observations and/or variables read or written?
How substr function works in sas?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
what is star schema? : Sas-di
What is the command used to find missing values?
How many ways to overcome a missing values???
what are sas bi dashboard components? : Sas-bi
what are the benefits of data integration? : Sas-di
how sas deals with business intelligence? : Sas-bi