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
Creating Views of Time Series by Using SASEFAME LIBNAME Options
You can perform selection based on names of your time series simply by using Fame wildcard specifications in the SASEFAME engine WILDCARD= option.
You can limit the time span of time series data by specifying a beginning and ending date range in the SASEFAME engine RANGE= option.
It is also easy to use the SAS input data set INSET= option to create a specific view of your Fame data. You can create multiple views by using multiple LIBNAME statements with customized options that are tailored to the unique views that you want to create.
You can list the INSET variables that you want to keep in your SAS data set by using the KEEP= clause. When you use INSET variables in conjunction with the input data set that you specify in the INSET= option, the SASEFAME engine 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 KEEP= clause, as shown in Example 47.16.
The INSET variables define the BY variables that enable you to view cross sections (slices) of your data. When you use INSET variables in conjunction with the WHERE clause and the CROSSLIST= option, the SASEFAME engine can show any or all of your BY groups in the same view or in multiple views. When you use the INSET= option along with a WHERE clause that specifies the BY variables that you want to use in your view, you must also use the CROSSLIST= option, as shown in Example 47.10. You can use the CROSSLIST= option without using the INSET= option, as shown in Example 47.8 and Example 47.9.