Question-16: What is the difference between procedure and proc step?

Answer: Proc step which starts with the PROC (procedure) and ends with the run statement or (if next PROC or Data step found), is called the proc step. Hence, Proc step is a collection of statements which must include the procedure in it.

Question-17: Then what is the proc statement?

Answer: In the proc step we write which procedure to use and end it with the semicolon (remember each SAS statement must end with semicolon) is known as Proc statement. See the below example for entire Proc step comprising proc statement in the first line

proc print data=he_learner;

                title 'HadoopExam Learner List'

run;

All 3 lines are part of PROC step and the first line are known as proc statement. And the ‘PRINT’ is a procedure, which is in-built in SAS to print the content of the SAS Data set.

Question-18: What is the purpose of the “RUN” statement?

Answer: A RUN statement in the SAS base program indicates that all the preceding statements are ready to be executed.

Question-19: What all are the possible output from the SAS program?

Answer: A SAS program can generate following types of the output

• A new SAS Data set
• SAS Log
• Report or new Data listing
• Catalog files
• External data files
• Creating new entries in external databases like RDBMS (Oracle, MySQL, SQL Server, excel etc.)

Question-20: What all information and data can be stored by the SAS Data sets?

Answer: As we have seen previously SAS data set can store variables and observations. And few other things also it stores like descriptive information about the Data.