Why do we use QUIT commmand for proc datasets and proc sql ???
- 3 Answers
- 7384 Views
- I also Faced
- E-Mail Answers
Answer Posted / rohit bedi
Proc dataset is one of the procedures which allow run group processing which means that if we write only run after proc dataset, it doesn't get terminated. It continues to run in the background. So we mention quit to terminate proc dataset.
Proc sql also gets terminated only when it encounters a step boundary such as quit, data or another proc statement. That is why you see 'Proc SQL Running' in the editor window top bar when proc sql is used without quit statement.
It is not mandatory to mention quit after proc dataset or proc sql but is recommended as a best practice if it is not required to keep the procedures running as it frees up the memory.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi,by usining ptf how we have to combine (likr merge)10 datasets at a time in the oracle database(and write a macro code also)?Like this i have a douts a lot if you dont mind may please send one text mail for me(madhusudhanap16@gmail.com)?
How can I remove header from output data set?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
Explain the use of proc gplot? : sas-grid-administration
Mention some common errors that are usually committed in sas programming.
What is the difference between INPUT and INFILE ?
Explain the purpose of retain statement.
Which command is used to save logs in the external file?
Mention common programming errors committed in sas ?
What are the statements in proc sql?
what is factor analysis? : Sas-administrator
what is the difference between unique key and primary key? : Sas-di
how will you locate the sas platform applications? : Sas-bi
What is the role of sas grid administrator? : sas-grid-administration
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
