The SASEFAME Interface Engine
- Overview
-
Getting Started
-
Syntax
-
Details
-
ExamplesConverting an Entire Fame DatabaseReading Time Series from the Fame DatabaseWriting Time Series to the SAS Data SetLimiting the Time Range of DataCreating a View Using the SQL Procedure and the SASEFAME EngineReading Other Fame Data Objects with the FAMEOUT= OptionRemote Fame Access by Using Fame CHLISelecting Time Series by Using the CROSSLIST= Option and KEEP StatementSelecting Time Series by Using the CROSSLIST= Option and Fame NamelistSelecting Time Series by Using the CROSSLIST= Option and WHERE=TICKSelecting Boolean Case Series with the FAMEOUT= OptionSelecting Numeric Case Series with the FAMEOUT= OptionSelecting Date Case Series with the FAMEOUT= OptionSelecting String Case Series with the FAMEOUT= OptionExtracting Source for FormulasReading Time Series by Defining Fame Expression Groups in the INSET= Option with the KEEP= ClauseOptimizing Cache Sizes with the TUNEFAME= and TUNECHLI= Options
- References
The SASEFAME engine uses standard engine syntax. Table 41.1 summarizes the options used by the SASEFAME engine.
Table 41.1: Summary of LIBNAME libref SASEFAME Statement Options
|
Option |
Description |
|---|---|
|
CONVERT= |
Specifies the Fame frequency and the Fame technique |
|
WILDCARD= |
Specifies a Fame wildcard to match data object series names within the Fame database |
|
RANGE= |
Specifies the range of data to keep in format ’ddmmmyyy’d – ’ddmmmyyyy’d |
|
INSET= |
Uses a SAS data set named setname and KEEP= fame_expression_group as selection input variables or WHERE= fame_bygroup as selection input for BY variables |
|
CROSSLIST= |
Specifies a Fame crosslist fame_namelist to perform selection based on the crossproduct of two Fame namelists |
|
FAMEOUT= |
Specifies the Fame data object class/type that you want output to the SAS data set |
|
DBVERSION= |
Echoes the present version number of the Fame Work database in the SAS log |
|
TUNEFAME= |
Tunes the Fame database engine’s use of memory to reduce I/O in favor of a bigger virtual memory for caching database objects |
|
TUNECHLI= |
Tunes the CHLI database engine’s use of memory to reduce I/O in favor of a bigger virtual memory for caching database objects |