Some of the best SAS programming practices to handle very large data sets are:
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:
The areas that I am most interested in SAS are:
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:
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:
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:
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:
The general function format of function in SAS is
We can use SAS in two different operating systems
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:
Some categories in SAS 9 are:
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: