SAS Grid Administration Interview Questions

If you're looking for SAS Grid Administration Interview Questions for Experienced or Freshers, you are in right place. There are a lot of opportunities from many reputed companies in the world. According to research, SAS Grid Administration has a market share of about 1.9%... So, You still have the opportunity to move ahead in your career as a SAS Grid Administrator. Mindmajix offers Advanced SAS Grid Administration Interview Questions 2024 that help you in cracking your interview & acquiring a dream career as SAS Admin.

SAS Grid Admin Interview Questions And Answers

1. What is SAS?

SAS which is often referred to as a leader when it comes to Analytics is an innovative software through which it enables and inspires its clients around the globe to transform data into intelligence.
As a SAS administrator, you will have three roles to play namely

  1. Platform oriented support
  2. User-oriented support
  3. Data-oriented support

2. What is the role of SAS GRID ADMINISTRATOR?

The SAS Platform Administrator/GRID Administrator fills in as contact between the SAS Developers and enterprise infrastructure support teams to ensure the 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

3 What is a Connection profile?

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

4. How do you connect the desktop application to the Metadata server?

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

5. What are the five ways to do a table lookup in SAS?

The five ways to do a table lookup are

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

6. What is the role of Administrative users?

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

7. What is the role of unrestrictive users?

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

MindMajix Youtube Channel

8. In SAS, what are the areas that you are most interested in?

The areas that I am most interested in SAS are

  • BASE
  • STAT
  • GRAPH
  • ETS

9 What are the different versions of SAS that you have used until now?

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

  • SAS 9.1.3 in Windows and UNIX
  • SAS 9.0 in Windows and UNIX
  • SAS 8.2 in Windows and UNIX
  • SAS 7 and
  • SAS 6.12

10 What are the best SAS programming practices for handling very large datasets?

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

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

11 How does internal authentication work in SAS?

During the login 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 servers use SAS identity associated with the internal account to accept the connection.

12. What do you know about SAS and what we do?

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

13. What are the different operating system platforms in which we can use SAS?

We can use SAS in two different operating systems, they are

  1. UNIX OR LINUX
  2. WINDOWS

14. Name some categories in SAS 9?

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

15. What are the different servers in SAS?

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.

16. Name any two SAS spawners?

Two SAS spawners are

  • SAS object spawner
  • SAS/CONNECT spawner

17. Explain the use of PROC gplot?

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

18. How do you define PROC in SAS?

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

  • Sorting
  • Summarizing
  • Listing 

19. What is the SAS data set?

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

  1. Descriptor portion
  2. Data portion

20. Differentiate between FORMAT and INFORMAT?

  • Format: This indicates SAS to print the variables
  • Informat: This indicates SAS where a number should be read in a particular format.

21. What is the general format of function In SAS?

The general function format of function in SAS is

myvalue=FUNCTION_NAME(required_argument1, …, required_argumentN,optional_argument1,…,optional_argumentN);

22. Describe what are the different levels of administrative users in SAS?

There are basically two levels of administrative users in SAS, they are

  1. Administrative 
  2. Unrestrictive users

23. In SAS admin differentiate between roles and capabilities

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.

24. For a user to have access to a standard workspace server, Is internal authentication alone is sufficient?

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.

Explore SAS Grid Administration Sample Resumes! Download & Edit for Free..!

 

About Author

Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.

read less