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
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 41.11, Example 41.12, Example 41.13, Example 41.14, and Example 41.15, respectively.