Top 23 Sas Grid Administration Interview Questions You Must Prepare 19.Mar.2024

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

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.

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.

There are basically two levels of administrative users in SAS:

they are

  1. Administrative 
  2. Unrestrictive users

The areas that I am most interested in SAS are:

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

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

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

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.

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

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

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 

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.

FORMAT: This indicates SAS to print the variables

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

Two SAS spawners are:

  1. SAS object spawner
  2. SAS/CONNECT spawner

The general function format of function in SAS is

myvalue=FUNCTION_NAME(required_argument1, …,

required_argumentN,optional_argument1,…,optional_argumentN);

We can use SAS in two different operating systems

they are:

  1.  UNIX OR LINUX
  2.  WINDOWS

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.

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.

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

  1. Descriptor portion
  2. Data portion

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

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.

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.

The five ways to do a table lookup are:

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