PROC SQL always ends with QUIT statement.Why cant you use
RUN in PROQ SQL ?
- 7 Answers
- 27874 Views
- HP, I also Faced
- E-Mail Answers
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
Mention what are the data types does SAS contain?
List out some key concept of SAS
What is the function of output statement in a SAS Program?
What versions of SAS have you used (on which platforms)?
what is sas business intelligence? : Sas-bi
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
What is the basic structure of the SAS base program?
Are you involved in writing the inferential analysis plan? Tables specfications?
what is data access? : Sas-di
How do you use the do loop if you don’t know how many times you should execute the do loop?
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
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
Describe what are the different levels of administrative users in sas? : sas-grid-administration
To what type of programms have you used scratch macros?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
