{"id":95,"date":"2017-04-16T02:44:03","date_gmt":"2017-04-16T02:44:03","guid":{"rendered":"http:\/\/www.gologica.com\/blog\/?p=95"},"modified":"2025-04-06T02:56:07","modified_gmt":"2025-04-06T02:56:07","slug":"sas-grid-administrator-interview-questions","status":"publish","type":"post","link":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/","title":{"rendered":"SAS Grid Administrator Interview Questions"},"content":{"rendered":"

How does desktop application are connected to metadata server<\/strong><\/p>\n

Using connection profile, Connection profile is a file stored on a desktop that contains the information necessary to connect to your metadata profile.<\/p>\n

What is the difference between ‘roles’ and ‘capabilities’ in SAS admin?<\/strong><\/p>\n

Roles determine which user interface elements a user sees when interacting with and application.
\nThe features in applications that provide role-based management are called capabilities.
\nTo prevent someone from having capability, make sure he or she is not in any role that provides that capability.<\/p>\n

Is internal authentication alone is sufficient to enable a user to have access to a standard workspace server?<\/strong><\/p>\n

No, because a host account is also required.<\/p>\n\n\n\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"SAS<\/a><\/p>\n

Describe 5 ways to do a \u201ctable lookup\u201d in SAS.<\/strong><\/p>\n

Match Merging, Direct Access, Format Tables, Arrays, PROC SQL.<\/p>\n

How many levels of administrative users are there in SAS.<\/strong><\/p>\n

There are two basic levels of basic administrative users
\nAdministrative: They are subject to metadata layer access control and they have metadata access capabilities that a typical end user does not have.
\nUnrestrictive users: They can perform tasks when the metadata server is pause for administration and obviously they do have unrestricted access to metadata.<\/p>\n

What are some good SAS programming practices for processing very large data sets?<\/strong><\/p>\n

Sampling method using OBS option or sub setting, commenting the Lines, Use Data Null.<\/p>\n

What is the difference between role and permission?<\/strong><\/p>\n

Having roles do not affect access to the metadata of data.
\nHaving a certain capability is not an alternative to meeting permission requirements. Permission requirements and capability requirements are cumulative.<\/p>\n

How does the internal authentication works in SAS.<\/strong><\/p>\n

At a log-on prompt, say person X enters his internal credentials. The client send those credentials to the metadata server for verification then the metadata server recognizes that the ID is for the internal account , so the metadata server checks the credentials against its list of internal accounts. After validating the ID and the password, the metadata server accepts the client connection. The connection is accepted using the SAS identity associated with the internal account.<\/p>\n

How would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable?<\/strong><\/p>\n

Using PROC TRANSPOSE<\/p>\n

For what purpose would you use the RETAIN statement?<\/strong><\/p>\n

The retain statement is used to hold the values of variables across iterations of the data step. Normally, all variables in the data step are set to missing at the start of each iteration of the data step. What is the order of evaluation of the comparison operators: + \u2013 * \/ ** ()?A) (), **, *, \/, +, \u2013<\/p>\n

Why is SAS considered self-documenting?<\/strong><\/p>\n

SAS is considered self documenting because during the compilation time it creates and stores all the information about the data set like the time and date of the data set creation later No. of the variables later labels all that kind of info inside the dataset and you can look at that info using proc contents procedure.<\/p>\n

What are the validation tools in SAS?<\/strong><\/p>\n

For dataset: Data set name\/debugData set: name\/stmtchk
\nFor macros: Options:mprint mlogic symbolgen.<\/p>\n

What do the PUT and INPUT functions do?<\/strong><\/p>\n

If we omit the INPUT or the PUT function during the data conversion, SAS will detect the mismatched variables and will try an automatic character-to-numeric or numeric-to-character conversion. But sometimes this doesn\u2019t work because $ sign prevents such conversion. Therefore it is always advisable to include INPUT and PUT functions in your programs when conversions occur.<\/p>\n\n\n\n
<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/a><\/p>\n

How many users does SAS have globally?<\/strong><\/p>\n

4 million<\/p>\n

What is SAS GRAPH?<\/strong><\/p>\n

SAS\/GRAPH software creates and delivers accurate, high-impact visuals that enable decision makers to gain a quick understanding of critical business issues.<\/p>\n","protected":false},"excerpt":{"rendered":"

How does desktop application are connected to metadata server Using connection profile, Connection profile is a file stored on a …<\/p>\n","protected":false},"author":1,"featured_media":2100,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"aside","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"pmpro_default_level":"","footnotes":""},"categories":[15232],"tags":[],"coauthors":[182],"class_list":["post-95","post","type-post","status-publish","format-aside","has-post-thumbnail","hentry","category-other-segments","post_format-post-format-aside","pmpro-has-access","user-has-not-earned"],"yoast_head":"\nSAS Grid Administrator Interview Questions - GoLogica<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS Grid Administrator Interview Questions - GoLogica\" \/>\n<meta property=\"og:description\" content=\"How does desktop application are connected to metadata server Using connection profile, Connection profile is a file stored on a …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"GoLogica\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-16T02:44:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-04-06T02:56:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"175\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62\"},\"headline\":\"SAS Grid Administrator Interview Questions\",\"datePublished\":\"2017-04-16T02:44:03+00:00\",\"dateModified\":\"2025-04-06T02:56:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/\"},\"wordCount\":612,\"image\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png\",\"articleSection\":[\"Other Segments\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/\",\"url\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/\",\"name\":\"SAS Grid Administrator Interview Questions - GoLogica\",\"isPartOf\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png\",\"datePublished\":\"2017-04-16T02:44:03+00:00\",\"dateModified\":\"2025-04-06T02:56:07+00:00\",\"author\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#primaryimage\",\"url\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png\",\"contentUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png\",\"width\":300,\"height\":175,\"caption\":\"SAS Grid Administrator Interview Questions\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.gologica.com\/elearning\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SAS Grid Administrator Interview Questions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#website\",\"url\":\"https:\/\/www.gologica.com\/elearning\/\",\"name\":\"GoLogica\",\"description\":\"E-Learning Portal\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.gologica.com\/elearning\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/image\/d0ab308492a1bfcbec1a1ce1637996db\",\"url\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/themes\/wplms\/assets\/images\/avatar.jpg\",\"contentUrl\":\"https:\/\/www.gologica.com\/elearning\/wp-content\/themes\/wplms\/assets\/images\/avatar.jpg\",\"caption\":\"admin\"},\"url\":\"https:\/\/www.gologica.com\/elearning\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAS Grid Administrator Interview Questions - GoLogica","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/","og_locale":"en_US","og_type":"article","og_title":"SAS Grid Administrator Interview Questions - GoLogica","og_description":"How does desktop application are connected to metadata server Using connection profile, Connection profile is a file stored on a …","og_url":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/","og_site_name":"GoLogica","article_published_time":"2017-04-16T02:44:03+00:00","article_modified_time":"2025-04-06T02:56:07+00:00","og_image":[{"width":300,"height":175,"url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#article","isPartOf":{"@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/"},"author":{"name":"admin","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62"},"headline":"SAS Grid Administrator Interview Questions","datePublished":"2017-04-16T02:44:03+00:00","dateModified":"2025-04-06T02:56:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/"},"wordCount":612,"image":{"@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png","articleSection":["Other Segments"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/","url":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/","name":"SAS Grid Administrator Interview Questions - GoLogica","isPartOf":{"@id":"https:\/\/www.gologica.com\/elearning\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#primaryimage"},"image":{"@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#primaryimage"},"thumbnailUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png","datePublished":"2017-04-16T02:44:03+00:00","dateModified":"2025-04-06T02:56:07+00:00","author":{"@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62"},"breadcrumb":{"@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#primaryimage","url":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png","contentUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/uploads\/2017\/04\/SAS-Grid-Administrator-Interview-Questions.png","width":300,"height":175,"caption":"SAS Grid Administrator Interview Questions"},{"@type":"BreadcrumbList","@id":"https:\/\/www.gologica.com\/elearning\/sas-grid-administrator-interview-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.gologica.com\/elearning\/"},{"@type":"ListItem","position":2,"name":"SAS Grid Administrator Interview Questions"}]},{"@type":"WebSite","@id":"https:\/\/www.gologica.com\/elearning\/#website","url":"https:\/\/www.gologica.com\/elearning\/","name":"GoLogica","description":"E-Learning Portal","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.gologica.com\/elearning\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/61458e59d78b8e05fb57997461069c62","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.gologica.com\/elearning\/#\/schema\/person\/image\/d0ab308492a1bfcbec1a1ce1637996db","url":"https:\/\/www.gologica.com\/elearning\/wp-content\/themes\/wplms\/assets\/images\/avatar.jpg","contentUrl":"https:\/\/www.gologica.com\/elearning\/wp-content\/themes\/wplms\/assets\/images\/avatar.jpg","caption":"admin"},"url":"https:\/\/www.gologica.com\/elearning\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/95","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/comments?post=95"}],"version-history":[{"count":4,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/95\/revisions"}],"predecessor-version":[{"id":2848,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/posts\/95\/revisions\/2848"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/media\/2100"}],"wp:attachment":[{"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/media?parent=95"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/categories?post=95"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/tags?post=95"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.gologica.com\/elearning\/wp-json\/wp\/v2\/coauthors?post=95"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}