Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we use QUIT commmand for proc datasets and proc sql ???
- 3 Answers
- 8921 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / n katepalli
The question was why were those commands used.
To my knowledge, proc sql and datasets are interactive
procedures i.e quit command is used after them i.e telling
sas not to expect another one of them .
where as proc print,sort are non - interactive procedures.
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / 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 |
QUIT command is used for both proc datasets,proc sql.
Proc SQL
Select
from
Quit;
Proc datasets
proc datasets lib=db;
quit;
run;
| Is This Answer Correct ? | 2 Yes | 15 No |
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
what are the advantages of using SAS in clinical data mangement? why should not we use other software products in managing clinical data?
how to know the attributes of first five datasets in a library
Tell me about % include and % eval? : sas-macro
Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)
What are the new features included in the new version of SAS Programming Language?
If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
How you can read the variables that you need?
What is the order of application for output data set options, input data set options and SAS statements?
what is fact table and factless table?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
What does the RUN statement do?
Teradata 
