Question-: 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-: 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-: 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.
Question-: What all are the basic categories in which you can divide the SAS procedures?
Answer: You can divide SAS procedures in below three categories. - Report writing: These are mainly for displaying the data like CALENDAR, PLOT, SQL, PRINT, SUMMARY etc.
- Statistics: Using these procedure elementary statistics can be calculated which include descriptive statistics which is based on moment, quantiles, confidence intervals, frequency counts, crosstabulations, correlations, distribution tests and ranking the standardize the data.
- Utilities: These are for various utility like
o Create, edit, sort, transpose data sets. o Creating user-defined functions. o Various file maintenance operations. Examples are: CATALOG, APPEND, SORT, DELETE, MIGRATE, PDS etc.