Why do we use QUIT commmand for proc datasets and proc sql ???
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 |
What is the basic syntax of a sas program?
What is program data vector (pdv) and what are its functions?
Explain data_null_?
What do you code to create a macro? : sas-macro
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
what is the difference between proc report and proc format?
How can you create a macro variable with in data step? : sas-macro
If you’re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
How would you determine how far down on a page you have printed in order to print out footnotes?
How to get part of string form the source string without using sub string function in SAS?
create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;
how to change the execute of macro