Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we use QUIT commmand for proc datasets and proc sql ???
- 3 Answers
- 8895 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 |
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
do you prefer proc report or proc tabulate? Why? : Sas programming
What is the use of the %include statement?
What is difference between sas rename and lable?
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?
is there any differnce between proc means and proc summary?
what do the pad and dim functions do? : Sas programming
Hi, I have one dataset, could you please ans for this. id amount paid_amount 1 700 400 2 900 250 3 300 300 a 400 250 b 500 320 c 800 650 x 200 190 y 900 250 z 300 180 i want create new dataset having id and paid_amount who are paid high amount comparing amount. ex: 1d paid_amount 3 300 c 650 x 190
what can you learn from the sas log when debugging? : Sas programming
Why and when do you use proc sql?
How can I remove header from output data set?
Name the option to produce a frequency line items rather that a table.
Teradata 
