Question-91: Can you please again explain me the difference between function and procedure?

Answer: In SAS, even many other programming this concept is almost same, function may or may not take input from the individual observation to generate the output. However, in case of procedure it requires only one single variable.

Question-92: What is the difference between format and informat?

Answer: Format is used while writing data to a file and informat is used while reading the file. INFOMATS also input the data from external files known Flat Files ASCII.

Question-93: How can you crate a permanent dataset in SAS?

Answer: While creating dataset in SAS use the library reference “libref” which should be other than “WORK” to store the SAS Dataset.

Question-94: Can a numeric variable below to the ‘character’ data type?

Answer: Yes, it is possible and based on the context where it is being used. It happens when numeric variable does not represent several items, but rather a position on some sort of a scale.

Lets take an example you have been given a variable named “classType” which has 3 values 1,2 & 3 where

1 -> means OnDemand class from http://hadoopexam.com

2 -> means Annual Subscription training from HadoopExam.com

3 -> means Classroom training conducted by HadoopExam.com

Question-95: Can you explain the PROC contents and PROC print procedure?

Answer: Using the PROC contents you can display all the information processed in the recent Dataset or dataset explicitly mentioned. While PROC PRINT all the contents can be printed as well as make sure that mentioned information is correct or not.

For example, with the CONTENTS you can not use the WHERE option because CONTENTS proc does not process any observations from the DATASET.