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.  INTRODUCTION  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

Something about SAS/ACCESS Software

Image Definition of SAS/ACCESS Software SAS/ACCESS software enables 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 B

something about SAS Catalog

Image Definition of a SAS Catalog SAS 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 libref is the logical name of the SAS library to which the catalog belongs. cata