Commonly Asked SAS Interview Questions with Answer (ST) : 6 - 10

Ques (ST) 6 : What is SAS Stored Process and what are the uses of it ?

Ans : SAS Stored Process is a SAS code or program which is stored on a server and could be executed by many SAS applications. 

SAS Stored Process is described by metadata and gives effective method for change control management as program is saved on server. 

Stored Processes can be centrally managed and maintained which provides the facility to update the program and at the same time all SAS clients which invokes the program would get result from updated version of code.

We can use SAS Stored Process for the following :

1. To build web applications
2. Analytics
3. Web reporting
4. To deliver result package to clients or to Middle tier
5. To publish results
6. Centrally management of program
7. To enhance the security of program and data

Ques (ST) 7 : What are the Inputs and Outputs for SAS Stored Process ?

Ans : SAS Stored Process could access any SAS data source or external file to create SAS dataset, files and all other data targets supported by SAS.

INPUTS to SAS Stored Process :

1. SAS Data sources
2. External files

OUTPUTS from SAS Stored Process :

1. External files
2. SAS Datasets
3. Catalogs
4. E-mails
5. Result packages
6. ODS outputs

Ques (ST) 8 : What are the SAS Web Clients for SAS Stored Process ?

Ans : We can access or execute SAS Stored Process by following SAS Web Clients :

1. SAS Web Report Studio
2. SAS Information Delivery Portal
3. Stored Process Web Application

Ques (ST) 9 : What are the servers on which SAS Stored Processes are hosted ?

Ans : SAS Stored Processes can be hosted by two types of servers :

1. SAS Stored Process Server
2. SAS Workspace Server

Ques (ST) 10 : What is your preferred method to work on (Create) SAS Stored Processes ?

Ans : For me, SAS Enterprise Guide is the preferred method to work on SAS Stored Processes because it gives the facility to create, register and test stored processes in one interface.

SAS Data Integration Studio also gives a point and click interface for creating and registering Stored Process.

• SAS Stored Processes must be .sas file in SAS.