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 SASEFAMEReading Other Fame Data Objects with the FAMEOUT= OptionRemote Fame Access Using Fame CHLISelecting Time Series Using CROSSLIST= Option and KEEP StatementSelecting Time Series Using CROSSLIST= Option and Fame NamelistSelecting Time Series Using 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
Creating Views of Time Series Using SASEFAME LIBNAME Options
You can perform selection based on names of your time series simply by using Fame wildcard specifications in your SASEFAME WILDCARD= option.
You can limit the time span of time series data by specifying a begin and end date range in your SASEFAME RANGE= option.
It is also easy to use the SAS input data set INSET= option to create a specific view of your Fame data. Multiple views can be created by using multiple LIBNAME statements with customized options tailored to the unique view that you want to create.
You can list the INSET variables that you want to keep in your SAS data set by using the KEEPLIST clause. When used in conjunction with the input data set that you specify in the INSET= option, SASEFAME can show any or all of your expression groups in the same view or in multiple views. The INSET= option defines the valid set of expression groups that you can reference in the KEEPLIST= clause, as shown in Example 41.16.
The INSET variables define the BY variables that enable you to view cross sections (slices) of your data. When INSET variables are used in conjunction with the WHERE clause and the CROSSLIST= option, SASEFAME can show any or all of your BY groups in the same view or in multiple views. When the INSET= option is used with a WHERE clause that specifies the BY variables you want to use in your view, it must also use the CROSSLIST= option, as shown in Example 41.10. The CROSSLIST= option can be used without using the INSET= option as shown in Example 41.8 and Example 41.9.