If you're looking for SAS Grid Administration Interview Questions for Experienced or Freshers, you are at right place. There are 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 opportunity to move ahead in your career in SAS Grid Administrator. Mindmajix offers Advanced SAS Grid Administration Interview Questions 2019 that helps you in cracking your interview & acquire dream career as SAS Admin.
Q1) What is SAS?
SAS which is often referred to as 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
Q2) 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 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
Q3) What is Connection profile?
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.
Q4) How do you connect the desktop application to Metadata server?
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
Q5) What are the five ways to do a table lookup in SAS?
The five ways to do a table lookup are
- Match merging
- Direct access
- Format tables
- PROC SQL
Q6) What is the role of Administrative users?
Administrative users have access to Metadata layer which a typical end user doesn’t have.
Q7) 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.
Subscribe to our youtube channel to get new updates..!
Q8) In SAS, what are the areas that you are most interested in?
The areas that I am most interested in SAS are
Q9) 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
Q10) 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
- Sampling method using OBS option or sub setting
- commenting the Lines
- Use Data Null
Q11) How does the internal authentication work in SAS?
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.
Q12) 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.
Q13) 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
Q14) Name some categories in SAS 9?
Some categories in SAS 9 are
- Bitwise logical operations
- Descriptive statistics
- SAS file I/O
- Variable control
Q15) 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.
Q16) Name any two SAS spawners?
Two SAS spawners are
- SAS object spawner
- SAS/CONNECT spawner
Q17) Explain the use of PROC gplot?
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.
Q18) How do you define PROC in SAS?
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:
Q19) What is the SAS data set?
A SAS data set can be described as a file consisting. These are the two parts:
- Descriptor portion
- Data portion
Q20) 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.
Q21) 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);
Q22) Describe what are the different levels of administrative users in SAS?
There are basically two levels of administrative users in SAS, they are
- Unrestrictive users
Q23) 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.
Q24) 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.