Commonly Asked SAS Interview Questions with Answer (ST) : 1 - 5

Ques (ST) 1: What are the basic steps for data mining in SAS Enterprise Miner ?

Ans : The basic step for data mining in SAS Enterprise Miner is SEMMA. It is a short form of five processes which are given below :

• Sample   (S) 
• Explore   (E)
• Modify    (M)
• Model     (M)
• Access   (A)

Ques (ST) 2: What is SAS Add-In for Microsoft Office ?

Ans : The SAS Add-In for Microsoft Office is a Component Object Model (COM) which provides access to SAS Datasets from MS-Excel, MS-Power Point, MS-Word and MS Outlook.

It also allows SAS Stored Processes to be run on server and the result to be returned to either MS-Word or MS-Excel.



Ques (ST) 3: What is Change Management feature in SAS DI Studio ?

Ans : The Change Management feature in SAS DI Studio allows multiple users to work on same metadata repository at the same time without overwriting each other's change.

• If Change Management is enabling for specific user then user could see pop-up with Check-in and Check-out.

• If a metadata object has been checked out by one user, it means that metadata object is locked so that it could not be updated by other user until the specific object has been checked back in by that user.

Ques (ST) 4: What is SAS OLAP Cube Studio ?

Ans : The SAS OLAP Cube Studio is to build and define OLAP Cubes in SAS. It is a Java interface tool.

OLAP - Online Analytical Processing is a software technology which allows us to analyze the data from multidimensional database tables dynamically.

CUBE - A Cube is a specific set of data which is organized, structured in a hierarchical and multidimensional manner with various dimensions and stages of data. Cubes also contains measures which are numeric analysis of input tables



Ques (ST) 5: What are the SAS Stored Process Desktop Clients ?

Ans : There are many Desktop clients by which we can access or execute the SAS Stored Process.
Few names are given below :

1. SAS Enterprise Guide
2. SAS Information Map Studio
3. SAS Add-In for Microsoft Office

Commonly Asked SAS Interview Questions with Answer : 61 - 65

Ques 61 : How could we create a SAS date value by using separate variables representing day, month and year of the date ?

Ans : We can use MDY function to create a SAS date value by using separate variables like day, month and year.

Ques 62 : What are the ways to view cube data when cube has been created by SAS OLAP CUBE Studio ?

Ans : We can view the cube data (cube - created by SAS OLAP CUBE STUDIO ) by following ways :

1.  SAS Enterprise Guide

2.  SAS Web OLAP viewer for java

3.  MS- Excel Pivot tables

4.  SAS Information Delivery Portal's visual data explorer portlet

Ques 63 : What are the load styles or ways to load the data to DW or permanent table by using TABLE LOADER transformation in SAS DI Studio ?

Ans : There are THREE ways to load the data to permanent table by using Table Loader Transformation in SAS DI Studio as given below :

1. Append to Existing

2. Replace

3. Update / Insert

Ques 64 : Can we create an Index on a View ?

Ans : No, We can not create an Index on View.

Ques 65 : Why we do Indexing (in simple word) and how many types of Indexes we can create in SAS ?

Ans : Indexing : To extract a small subset of observations from a large data set.

We can create two types of Indexes in SAS :

1. Simple Index

2. Composite Index