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
| SAS Output Data Set |
You can use the SAS DATA step to write the selected time series from your Fame database to a SAS data set. This enables you to easily analyze the data by using the SAS System. You can specify the name of the output data set in the DATA statement. This causes the engine supervisor to create a SAS data set by using the specified name in either the SAS Work library or, if specified, the Sasuser library. For more information about naming your SAS data set, see the section "SAS Data Sets: Data Set Names" in the SAS Language Reference: Concepts.
The contents of the SAS data set that contains time series include the date of each observation, the name of each series read from the Fame database as specified by the WILDCARD= option, and the label or Fame description of each series. Missing values are represented as '.' in the SAS data set. You can see the available data sets in the SAS LIBNAME window of the SAS windowing environment by selecting the SASEFAME libref in the LIBNAME window that you have previously used in your LIBNAME statement. You can use PROC PRINT and PROC CONTENTS to print your output data set and its contents. You can use PROC SQL and the SASEFAME engine to create a view of your SAS data set. You can view your SAS output observations by double-clicking the desired output data set libref in the LIBNAME window of the SAS windowing environment.
The DATE variable in the SAS data set contains the date of the observation. For Fame weekly intervals that end on a Friday, Fame reports the date on the Friday that ends the week, whereas the SAS System reports the date on the Saturday that begins the week.
A more detailed discussion of how to map Fame frequencies to SAS time intervals follows. For other types of data such as Boolean case series, numeric case series, date case series, string case series, and extracting source for formulas, see Example 40.11, Example 40.12, Example 40.13, Example 40.14, and Example 40.15, respectively.