The SASEFAME Interface Engine
- Overview
-
Getting Started
-
Syntax
-
Details
-
Examples
Converting an Entire Fame Database Reading Time Series from the Fame Database Writing Time Series to the SAS Data Set Limiting the Time Range of Data Creating a View Using the SQL Procedure and SASEFAME Reading Other Fame Data Objects with the FAMEOUT= Option Remote Fame Access Using Fame CHLI Selecting Time Series Using CROSSLIST= Option and KEEP Statement Selecting Time Series Using CROSSLIST= Option and Fame Namelist Selecting Time Series Using CROSSLIST= Option and WHERE=TICK Selecting Boolean Case Series with the FAMEOUT= Option Selecting Numeric Case Series with the FAMEOUT= Option Selecting Date Case Series with the FAMEOUT= Option Selecting String Case Series with the FAMEOUT= Option Extracting Source for Formulas Reading Time Series by Defining Fame Expression Groups in the INSET= Option with the KEEP= Clause Optimizing 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 40.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 40.10. The CROSSLIST= option can be used without using the INSET= option as shown in Example 40.8 and Example 40.9.