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
Mapping Fame Frequencies to SAS Time Intervals
Table 41.4 summarizes the mapping of Fame frequencies to SAS time intervals. Fame frequencies often have a sample unit in parentheses following the keyword frequency. This sample unit is an end-of-interval unit. SAS dates are represented by beginning-of-interval notation.
For more information about SAS time intervals, see Chapter 4: Date Intervals, Formats, and Functions.
For more information about Fame frequencies, see the section “Understanding Frequencies” in the User’s Guide to Fame.
Table 41.4: Mapping Fame Frequencies
|
Fame Frequency |
SAS Time Interval |
|---|---|
|
WEEKLY (SUNDAY) |
WEEK.2 |
|
WEEKLY (MONDAY) |
WEEK.3 |
|
WEEKLY (TUESDAY) |
WEEK.4 |
|
WEEKLY (WEDNESDAY) |
WEEK.5 |
|
WEEKLY (THURSDAY) |
WEEK.6 |
|
WEEKLY (FRIDAY) |
WEEK.7 |
|
WEEKLY (SATURDAY) |
WEEK.1 |
|
BIWEEKLY (ASUNDAY) |
WEEK2.2 |
|
BIWEEKLY (AMONDAY) |
WEEK2.3 |
|
BIWEEKLY (ATUESDAY) |
WEEK2.4 |
|
BIWEEKLY (AWEDNESDAY) |
WEEK2.5 |
|
BIWEEKLY (ATHURSDAY) |
WEEK2.6 |
|
BIWEEKLY (AFRIDAY) |
WEEK2.7 |
|
BIWEEKLY (ASATURDAY) |
WEEK2.1 |
|
BIWEEKLY (BSUNDAY) |
WEEK2.9 |
|
BIWEEKLY (BMONDAY) |
WEEK2.10 |
|
BIWEEKLY (BTUESDAY) |
WEEK2.11 |
|
BIWEEKLY (BWEDNESDAY) |
WEEK2.12 |
|
BIWEEKLY (BTHURSDAY) |
WEEK2.13 |
|
BIWEEKLY (BFRIDAY) |
WEEK2.14 |
|
BIWEEKLY (BSATURDAY) |
WEEK2.8 |
|
BIMONTHLY (NOVEMBER) |
MONTH2.2 |
|
BIMONTHLY |
MONTH2.1 |
|
QUARTERLY (OCTOBER) |
QTR.2 |
|
QUARTERLY (NOVEMBER) |
QTR.3 |
|
QUARTERLY |
QTR.1 |
|
ANNUAL (JANUARY) |
YEAR.2 |
|
ANNUAL (FEBRUARY) |
YEAR.3 |
|
ANNUAL (MARCH) |
YEAR.4 |
|
ANNUAL (APRIL) |
YEAR.5 |
|
ANNUAL (MAY) |
YEAR.6 |
|
ANNUAL (JUNE) |
YEAR.7 |
|
ANNUAL (JULY) |
YEAR.8 |
|
ANNUAL (AUGUST) |
YEAR.9 |
|
ANNUAL (SEPTEMBER) |
YEAR.10 |
|
ANNUAL (OCTOBER) |
YEAR.11 |
|
ANNUAL (NOVEMBER) |
YEAR.12 |
|
ANNUAL |
YEAR.1 |
|
SEMIANNUAL (JULY) |
SEMIYEAR.2 |
|
SEMIANNUAL (AUGUST) |
SEMIYEAR.3 |
|
SEMIANNUAL (SEPTEMBER) |
SEMIYEAR.4 |
|
SEMIANNUAL (OCTOBER) |
SEMIYEAR.5 |
|
SEMIANNUAL (NOVEMBER) |
SEMIYEAR.6 |
|
SEMIANNUAL |
SEMIYEAR.1 |
|
YPP |
Not supported |
|
PPY |
Not supported |
|
SECONDLY |
SECOND |
|
MINUTELY |
MINUTE |
|
HOURLY |
HOUR |
|
DAILY |
DAY |
|
BUSINESS |
WEEKDAY |
|
TENDAY |
TENDAY |
|
TWICEMONTHLY |
SEMIMONTH |
|
MONTHLY |
MONTH |