Showing posts from August, 2013

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 …