Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we use QUIT commmand for proc datasets and proc sql ???
- 3 Answers
- 8752 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 |
Explain what is the use of proc gplot?
here is a string like chq.2312244%4452- from that i want only special characters in a column. dont use compress. bcoz i have 1.2 billion of records.i want another process to find the values instant from the data.
Explain how you can debug and test your SAS program?
What are some problems you might encounter in processing missing values? In Data steps? Arithmetic? Comparisons? Functions? Classifying data?
what is function of retain statment
what is difference in window SAS & Unix SAS.....how do define working environment in both???
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 u import .csv file in to SAS?tell Syntax?
7 Answers CitiGroup, Franklin Templeton,
What is the difference between %local and %global?
What r all the reporting procedures...?
what is the use of proc contents and proc print in sas? : Sas-administrator
do you need to know if there are any missing values? : Sas programming
Teradata 
