Showing posts from 2013

TOP 10 (Most Powerful) PROC SQL Functions

TOP 10 PROC SQL Functions

PROC SQL is not only one of the many SAS procedures and also a distinctive subsystem with all common features from SQL (Structured Query Language). Equipped with PROC SQL, SAS upgrades to a full-fledging relational database management system. PROC SQL provides alternative ways to manage data other than the traditional DATA Step and SAS procedures. In addition, SAS’s built-in functions are the add-on tools to increase the power of PROC SQL. In this paper, we illustrate ten popular SAS functions, which facilitate the capacity of PROC SQL in data management and descriptive statistics.
Structured Query Language (SQL) is a universal computer language for all relational database management systems. PROC SQL is the implementation of the SQL syntax in SAS. It first appeared in
SAS 6.0, and since then has been widely used for SAS users. PROC SQL greatly increases SAS’s flexibility in handling data, especially for multiple-table joining and …

Something about SAS/ACCESS Software


Definition of SAS/ACCESS SoftwareSAS/ACCESS softwareenables you to read and write data to and from other vendors' database management systems (DBMS), as well as from some PC file formats. Depending on your DBMS, a SAS/ACCESS product might provide one or more of the following: a dynamic LIBNAME engine the SQL Pass-Through Facility the ACCESS procedure and interface view engine the DBLOAD procedure an interface DATA step engine. These interfaces are described in this section. Each SAS/ACCESS product provides one or more of these interfaces for each supported DBMS. See SAS Engines for more information about SAS engines. Note:   To use the SAS/ACCESS features described in this section, you must license SAS/ACCESS software. See the SAS/ACCESS documentation for your DBMS for full documentation of the features described in this section.
Dynamic LIBNAME Engine SAS/ACCESS LIBNAME Statement Beginning in Version 7, you can associate a SAS libref directly with a database, schema, se…

something about SAS Catalog


Definition of a SAS CatalogSAS catalogs are special SAS files that store many different kinds of information in smaller units called catalog entries. Each entry has an entry type that identifies its purpose to SAS. A single SAS catalog can contain several types of catalog entries. Some catalog entries contain system information such as key definitions. Other catalog entries contain application information such as window definitions, help windows, formats, informats, macros, or graphics output. You can list the contents of a catalog using various SAS features, such as SAS Explorer and PROC CATALOG.

SAS Catalog Names
Parts of a Catalog Name SAS catalog entries are fully identified by a four-level name in the following form: libref.catalog.entry-name.entry-type You commonly specify the two-level name for an entire catalog, as follows: libref.catalog librefis the logical name of the SAS library to which the catalog belongs. catalogis a valid SAS name for the file. The entry name …