SAS Grid Administration Interview Questions & Answers

Question 1. What Is The Role Of Sas Grid Administrator?

Answer :

The SAS Platform Administrator/GRID Administrator fills in as contact between the SAS Developers and enterprise infrastructure support teams to ensure proper delivery of technology solutions as per business requirements and objectives.

The SAS Platform Administrator or SAS GRID Administrator makes sure that the platform is positioned for compliance with IT policies and standards and agreed upon service levels.

Question 2. What Is Connection Profile?

Answer :

Connection profile can be described as a file that is stored on a desktop which contains the necessary information to connect to your metadata profile.

Question 3. How Do You Connect The Desktop Application To Metadata Server?

Answer :

A Desktop application is connected to Metadata server with the help of connection profile. So as soon as you answer this question, interviewer next question would be.

Question 4. What Are The Five Ways To Do A Table Lookup In Sas?

Answer :

The five ways to do a table lookup are:

1. Match merging
2. Direct access
3. Format tables
4. Arrays
5. PROC SQL

Question 5. What Is The Role Of Administrative Users?

Answer :

Administrative users have access to Metadata layer which a typical end user doesn’t have.

Question 6. What Is The Role Of Unrestrictive Users?

Answer :

As the name suggests Unrestrictive users don’t have access to the Metadata layer, they just perform tasks when the Metadata server is paused.

Question 7. In Sas, What Are The Areas That You Are Most Interested In?

Answer :

The areas that I am most interested in SAS are:

1. BASE
2. STAT
3. GRAPH
4. ETS

Question 8. What Are The Different Versions Of Sas That You Have Used Until Now?

Answer :

The different versions of SAS that I have used until now are:

1. SAS 9.1.3 in Windows and UNIX
2. SAS 9.0 in Windows and UNIX
3. SAS 8.2 in Windows and UNIX
4. SAS 7 and
5. SAS 6.12

Question 9. What Are The Best Sas Programming Practices For Handling Very Large Datasets?

Answer :

Some of the best SAS programming practices to handle very large data sets are:

1. Sampling method using OBS option or sub setting
2. commenting the Lines
3. Use Data Null

Question 10. How Does The Internal Authentication Work In Sas?

Answer :

During the log in time, let us say you have entered your credentials that it requires, it sends the information to Metadata servers which checks whether the credential details are right or wrong with the available credentials in its database and it accepts the client connection after validating the credentials. Metadata server’s uses SAS identity associated with the internal account to accept the connection.

Question 11. What Do You Know About Sas And What We Do?

Answer :

SAS turns numbers into a beautiful presentation that allows organizations or government entities to make proper decisions based on that data.

Question 12. What Are The Different Operating System Platforms In Which We Can Use Sas?

Answer :

We can use SAS in two different operating systems

they are:

1.  UNIX OR LINUX
2.  WINDOWS

Question 13. Name Some Categories In Sas 9?

Answer :

Some categories in SAS 9 are:

1. Array
2. Bitwise logical operations
3. Descriptive statistics
4. Trigonometric
5. Macro
6. Mathematical
7. Financial’
8. Hyperbolic
9. SAS file I/O
10. Variable control

Question 14. What Are The Different Servers In Sas?

Answer :

There are 5 different SAS servers:

they are

1.  SAS metadata server
2.  SAS OLAP server
3.  SAS/SHARE server
4.  SAS table server
5.  SAS deployment tester server.

Question 15. Name Any Two Sas Spawners?

Answer :

Two SAS spawners are:

1. SAS object spawner
2. SAS/CONNECT spawner

Question 16. Explain The Use Of Proc Gplot?

Answer :

With the help of PROC gplot, we can create more fancier and colorful graphics as it is having a number of options to choose from.

Question 17. How Do You Define Proc In Sas?

Answer :

In SAS, PROC steps analyzes and process data in a form of SAS data set which controls and performs tasks on SAS data set such as:

1. Sorting
2. Summarizing
3. Listing 

Question 18. What Is The Sas Data Set?

Answer :

A SAS data set can be described as a file consisting. These are the two parts:

1. Descriptor portion
2. Data portion

Question 19. Differentiate Between Format And Informat?

Answer :

FORMAT: This indicates SAS to print the variables

INFORMAT: This indicates SAS where a number should be read in a particular format.

Question 20. What Is The General Format Of Function In Sas?

Answer :

The general function format of function in SAS is

myvalue=FUNCTION_NAME(required_argument1, …,

required_argumentN,optional_argument1,…,optional_argumentN);

Question 21. Describe What Are The Different Levels Of Administrative Users In Sas?

Answer :

There are basically two levels of administrative users in SAS:

they are

1. Administrative 
2. Unrestrictive users

Question 22. In Sas Admin Differentiate Between Roles And Capabilities?

Answer :

Roles determine which user interface elements a user sees when interacting with an application.

The features in applications that provide role-based management are called capabilities.

Question 23. For A User To Have Access To A Standard Workspace Server, Is Internal Authentication Alone Is Sufficient?

Answer :

No, as for a user to have access to a standard workplace server, internal authentication alone is not sufficient, even a host account is required.