{"id":12602,"date":"2018-04-07T07:06:24","date_gmt":"2018-04-07T01:36:24","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=12602"},"modified":"2023-08-17T22:46:39","modified_gmt":"2023-08-17T17:16:39","slug":"sas-terminology","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sas-terminology\/","title":{"rendered":"SAS Terminology – Latest SAS Glossary For Data Science"},"content":{"rendered":"

In this SAS Glossary tutorial, we will list down the important SAS Terminology, that you will come across while learning SAS. Before we start the SAS Terminology, you can first revise the concept of\u00a0SAS Programming Language<\/strong>.<\/strong><\/p>\n

Today, we will talk about SAS Terminology, which are used in SAS Programming and are helpful in Data Science. SAS is used for predictive analytics, advanced analytics, multivariate analyses, business intelligence<\/strong>, and data management.<\/p>\n

So, let’s discuss different SAS Terminologies.<\/p>\n

1. Access Descriptor<\/strong><\/p>\n

A\u00a0SAS\/ACCESS file describes data to SAS software<\/strong> that is present in a PC file. You use an access descriptor as a master descriptor file from which you can create view descriptors.<\/p>\n

2. Browsing Data<\/strong><\/p>\n

The process of viewing the observations in a file.<\/p>\n

3. Column<\/strong><\/p>\n

A column is a vertical component of a PC file. Each column has a unique name and contains data of a specific type and with certain attributes. A column is analogous to a variable in SAS terminology.<\/p>\n

4. Column Function<\/strong><\/p>\n

Argument of the function is an operation that computes over each value in the column. For example, AVG (SALARY) is a column function.<\/p>\n

5. Data Type\u00a0<\/strong><\/p>\n

An attribute of every column is in a table. The data type indicates the operating environment that how much\u00a0physical storage to set aside for the column and the type of data that the column contains. It is similar to the type attribute of SAS variables.<\/p>\n

6. SAS Data Value<\/strong><\/p>\n

In SAS software, a unit of character or numeric information is present in a SAS data set. A data value represents one variable in an observation.<\/p>\n

7. SAS Database<\/strong><\/p>\n

SAS Database is an organized collection of related data. In most relational database management systems, a database contains objects such as tables, views, and indexes.<\/p>\n

8. Database Management System (DBMS)<\/strong><\/p>\n

An integrated software package that enables you to create and manipulate data in the form of databases.<\/p>\n

9. Engine<\/strong><\/p>\n

An engine is a part of SAS software that reads from a file or writes to a file. Each engine allows SAS software to access files that have a particular format. There are several types of engines.<\/p>\n

10. File<\/strong><\/p>\n

A file is a collection of related records that are treated as a unit. SAS files are processed and controlled through SAS software and are stored in a SAS data library.<\/p>\n

11. Format<\/strong><\/p>\n

The format is an instruction that SAS software uses to display or write each value of a variable. Some formats are supplied by SAS software. Other formats can be written by the user with the FORMAT procedure in base SAS software.<\/p>\n

\"SAS<\/a>

Part -2 SAS Terminology | Latest SAS Glossary<\/p><\/div>\n

12. Index<\/strong><\/p>\n

The purpose of SAS indexes is to optimize WHERE-clause processing and to facilitate BY-group processing. We also use these\u00a0indexes\u00a0to optimize WHERE-clause processing and join processing.<\/p>\n

13. Informat<\/strong><\/p>\n

An informat is a pattern that SAS software uses to determine how values that are entered in variable fields should be interpreted. SAS software provides a set of standard informats and also enables you to define your own custom informats.<\/p>\n

14. Libref<\/strong><\/p>\n

Libref is the name that is temporarily associated with a SAS data library. For example – In the name SASUSERS.ACCOUNTS, the name SASUSER is the libref. You assign a libref with a LIBNAME statement or with operating system control language.<\/p>\n

15. Member<\/strong><\/p>\n

Member is the SAS file in a SAS data library.<\/p>\n

16. Member Name<\/strong><\/p>\n

A\u00a0name that is given to a SAS file in a SAS data library.<\/p>\n

17. Member Type<\/strong><\/p>\n

A\u00a0name by SAS software that identifies the type of information in a SAS file. Member types include ACCESS, DATA, CATALOG, PROGRAM, and VIEW.<\/p>\n

18. Missing Value<\/strong><\/p>\n

A\u00a0value in SAS software that indicates that no data stores in the variable for the current observation. By default, SAS software represents a missing numeric value with a single period, and a blank space represents missing character value.<\/p>\n

19. Observation<\/strong><\/p>\n

The horizontal component of a SAS data file. An observation is a collection of data values that associate with a single entity, such as a customer or state. Each observation contains one data value for each variable in the data file. An observation is analogous to a row in a PC file.<\/p>\n

20. PROC SQL View<\/strong><\/p>\n

SQL procedure creates a SAS data set (of type VIEW). A PROC SQL view contains no data; instead, it stores the information that is for reading data values from its underlying files, which can include SAS data files, SAS\/ACCESS views, DATA step views, or other PROC SQL views.<\/p>\n

On execution, a PROC SQL view’s output can be either a subset or a superset of one or more underlying files.<\/p>\n

21. Record<\/strong><\/p>\n

It is analogous to a SAS observation.<\/p>\n

22. Relational Database Management System (RDBMS)<\/strong><\/p>\n

A database management system that organizes and accesses data according to relationships between data items.<\/p>\n

\"SAS<\/a>

SAS Terminology | Latest SAS Glossary<\/p><\/div>\n

23. Row<\/strong><\/p>\n

The horizontal component of a PC file. A row is analogous to a SAS observation.<\/p>\n

24. SAS Data File<\/strong><\/p>\n

A SAS data file contains both the data values and the descriptor information that associates with the data, such as the variable attributes.<\/p>\n

In previous releases of SAS software, all SAS data sets were SAS data files. SAS data files are of member type DATA. In SAS software, a PROC SQL table is a SAS data file.<\/p>\n

25. SAS Data Library<\/strong><\/p>\n

A\u00a0collection of one or more SAS files that SAS software recognizes and that references and stores as a unit. Each file is a member of the library.<\/p>\n

26. SAS Data Set<\/strong><\/p>\n

Descriptor information and its related data values, organized as a table of observations and variables that can be processed by SAS software. A SAS data set can be either a SAS data file or a SAS data view.<\/p>\n

A SAS data set arranges in a rectangular, two-dimensional format. Each item in a SAS data set is a data value. Data values in a row compose an observation, and those in a column compose a variable.<\/p>\n

27. SAS Data View<\/strong><\/p>\n

A SAS data view contains only the descriptor and other information to retrieve the data values from other data sources. PROC SQL views, SAS\/ACCESS views, and DATA step views are considered SAS data views. SAS data views are of member type VIEW.<\/p>\n

28. Structured Query Language (SQL)<\/strong><\/p>\n

The standardized, high-level query language that is used in relational database management systems to create and manipulate database management system objects. SAS software implements SQL through the SQL procedure.<\/p>\n

29. Table Alias<\/strong><\/p>\n

A\u00a0temporary, alternate name for a table that is specified in a FROM clause. We optionally use table aliases to qualify column names when table joins.<\/p>\n

30. Table Lookup<\/strong><\/p>\n

A\u00a0processing technique in which information retrieves from an auxiliary source, on the basis of values of variables in the primary source.<\/p>\n

31. Target Variable<\/strong><\/p>\n

The variable to which the result of a function or expression is assigned.<\/p>\n

32. Variable<\/strong><\/p>\n

A\u00a0column in a SAS data set. A variable is a set of data values that describe a given characteristic across all observations. In the ACCESS procedure, variables are created from the PC files’ columns or fields.<\/p>\n

33. View<\/strong><\/p>\n

View is a definition of a virtual dataset. This file contains no data but describes or defines the store data.<\/p>\n

This was all on SAS Terminology Tutorial. Hope you like our explanation of SAS Glossary.<\/p>\n

34. SAS Data Mining:<\/strong><\/p>\n

Methods for identifying trends and connections in data.<\/p>\n

35. SAS ETL Studio: <\/strong><\/p>\n

SAS ETL Studio is an extract, transform, and load (ETL) application for data warehousing and integration.<\/p>\n

36. SAS Forecast Studio: <\/strong><\/p>\n

A time series forecasting and modelling tool<\/p>\n

37. SAS Viya: <\/strong><\/p>\n

An extension of SAS’s capabilities for advanced analytics and machine learning is SAS Viya, a cloud-native platform.<\/p>\n

Summary<\/h3>\n

So, these were some of the most important as well as frequently used SAS terminology. Hope you all liked it. If you have any queries, post your doubts in the comments section below.<\/p>\n","protected":false},"excerpt":{"rendered":"

In this SAS Glossary tutorial, we will list down the important SAS Terminology, that you will come across while learning SAS. Before we start the SAS Terminology, you can first revise the concept of\u00a0SAS...<\/p>\n","protected":false},"author":6,"featured_media":12623,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[59],"tags":[11993,11995,12039,12290,12291],"class_list":["post-12602","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sas","tag-sas-data-value","tag-sas-database","tag-sas-glossary","tag-sas-terminology","tag-sas-terms"],"yoast_head":"\nSAS Terminology – Latest SAS Glossary For Data Science - DataFlair<\/title>\n<meta name=\"description\" content=\"Latest SAS Terminology consists Flash cards, Access Descriptor, column Function, SAS Data Type, SAS DBMS, SAS SQL, SAS RDMBS,SAS Tableau Alias\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sas-terminology\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SAS Terminology – Latest SAS Glossary For Data Science - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Latest SAS Terminology consists Flash cards, Access Descriptor, column Function, SAS Data Type, SAS DBMS, SAS SQL, SAS RDMBS,SAS Tableau Alias\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sas-terminology\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-04-07T01:36:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-08-17T17:16:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/SAS-Terminologies-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SAS Terminology – Latest SAS Glossary For Data Science - DataFlair","description":"Latest SAS Terminology consists Flash cards, Access Descriptor, column Function, SAS Data Type, SAS DBMS, SAS SQL, SAS RDMBS,SAS Tableau Alias","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:\/\/data-flair.training\/blogs\/sas-terminology\/","og_locale":"en_US","og_type":"article","og_title":"SAS Terminology – Latest SAS Glossary For Data Science - DataFlair","og_description":"Latest SAS Terminology consists Flash cards, Access Descriptor, column Function, SAS Data Type, SAS DBMS, SAS SQL, SAS RDMBS,SAS Tableau Alias","og_url":"https:\/\/data-flair.training\/blogs\/sas-terminology\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-04-07T01:36:24+00:00","article_modified_time":"2023-08-17T17:16:39+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/SAS-Terminologies-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SAS Terminology – Latest SAS Glossary For Data Science","datePublished":"2018-04-07T01:36:24+00:00","dateModified":"2023-08-17T17:16:39+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/"},"wordCount":1317,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/SAS-Terminologies-01.jpg","keywords":["SAS Data Value","SAS Database","SAS Glossary","SAS terminology","SAS Terms"],"articleSection":["SAS Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sas-terminology\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/","url":"https:\/\/data-flair.training\/blogs\/sas-terminology\/","name":"SAS Terminology – Latest SAS Glossary For Data Science - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/SAS-Terminologies-01.jpg","datePublished":"2018-04-07T01:36:24+00:00","dateModified":"2023-08-17T17:16:39+00:00","description":"Latest SAS Terminology consists Flash cards, Access Descriptor, column Function, SAS Data Type, SAS DBMS, SAS SQL, SAS RDMBS,SAS Tableau Alias","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sas-terminology\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/SAS-Terminologies-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/04\/SAS-Terminologies-01.jpg","width":1200,"height":628,"caption":"SAS Terminology | Latest SAS Glossary"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sas-terminology\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAS Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sas\/"},{"@type":"ListItem","position":3,"name":"SAS Terminology – Latest SAS Glossary For Data Science"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12602","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=12602"}],"version-history":[{"count":15,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12602\/revisions"}],"predecessor-version":[{"id":118507,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12602\/revisions\/118507"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/12623"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=12602"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=12602"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=12602"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}