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.

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.

Answer / charu tiwari

QUIT command is used for both proc datasets,proc sql.

Proc SQL
Select
from
Quit;

Proc datasets
proc datasets lib=db;
quit;
run;

Can we create datasets by proc step ? (Proc contents, Means)?

2 Answers  

---

how can u convert this 25-jul-2010 from numeric to charcter?

3 Answers  

---

how to perform paired t-test using Base/SAS & SAS/Stat?

2 Answers  

---

If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?

1 Answers   HCL, Quintiles,

---

What is the purpose of _error_?

1 Answers   Quintiles,

---

I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 Answers  

---

what is the difference between SET and MERGE?

19 Answers   CitiGroup,

---

Are you involved in writing the inferential analysis plan? Tables specifications?

0 Answers   Oracle,

---

What do you feel about hardcoding?

1 Answers  

---

What report output formats can you generate using SAS?

3 Answers   Accenture,

---

How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 Answers  

---

what is SAS/Graph?

1 Answers   CitiGroup, NTPC,

---