 |
|
| The DATASOURCE Procedure |
| FAME Information Services Databases |
The DATASOURCE procedure provides access to FAME Information Services databases for UNIX-based systems only. For a more flexible FAME database access use the SASEFAME interface engine discussed in Chapter 34, The SASEFAME Interface Engine, which is supported for SAS 8.2 on Windows, Solaris2, AIX, and HP-UX hosts. SASEFAME for SAS 9 supports Windows, Solaris, AIX, and Linux.
The DATASOURCE interface to FAME requires a component supplied by FAME Information Services, Inc. Once this FAME component is installed on your system, you can use the DATASOURCE procedure to extract data from your FAME databases by giving the following specifications.
Specify FILETYPE=FAME in the PROC DATASOURCE statement and give the FAME database name to access with a DBNAME=’fame-database ’ option. The character string you specify in the DBNAME= option is passed through to FAME; specify the value of this option as you would in accessing the database from within FAME software.
Specify the output SAS data set to be created, the frequency of the series to be extracted, and other usual DATASOURCE procedure options as appropriate.
Specify the time range to extract with a RANGE statement. The RANGE statement is required when extracting series from FAME databases.
Name the FAME series to be extracted with a KEEP statement. The items in the KEEP statement are passed through to FAME software; therefore, you can use any valid FAME expression to specify the series to be extracted. Enclose in quotes any FAME series name or expression that is not a valid SAS name.
Name the SAS variable names you want to use for the extracted series in a RENAME statement. Give the FAME series name or expression (in quotes if needed) followed by an equal sign and the SAS name. The RENAME statement is not required; however, if the FAME series name is not a valid SAS variable name, the DATASOURCE procedure will construct a SAS name by translating and truncating the FAME series name. This process might not produce the desired name for the variable in the output SAS data set, so a rename statement could be used to produce a more appropriate variable name. The VALIDVARNAME=ANY option in your SAS options statement can be used to allow special characters in the SAS variable name.
For an alternative solution to PROC DATASOURCE’s access to FAME, see "The SASEFAME Interface Engine" in Chapter 34, The SASEFAME Interface Engine.
FILETYPE=FAME–FAME Information Services Databases
Metadata Field Types |
Metadata Fields |
Metadata Labels |
|---|---|---|
INTERVAL= |
YEAR |
correspond to FAME’s ANNUAL(DECEMBER) |
YEAR.2 |
correspond to FAME’s ANNUAL(JANUARY) |
|
YEAR.3 |
correspond to FAME’s ANNUAL(FEBRUARY) |
|
YEAR.4 |
correspond to FAME’s ANNUAL(MARCH) |
|
YEAR.5 |
correspond to FAME’s ANNUAL(APRIL) |
|
YEAR.6 |
correspond to FAME’s ANNUAL(MAY) |
|
YEAR.7 |
correspond to FAME’s ANNUAL(JUNE) |
|
YEAR.8 |
correspond to FAME’s ANNUAL(JULY) |
|
YEAR.9 |
correspond to FAME’s ANNUAL(AUGUST) |
|
YEAR.10 |
correspond to FAME’s ANNUAL(SEPTEMBER) |
|
YEAR.11 |
correspond to FAME’s ANNUAL(OCTOBER) |
|
YEAR.12 |
correspond to FAME’s ANNUAL(NOVEMBER) |
|
SEMIYEAR |
correspond to FAME’s SEMIYEAR |
|
QUARTER |
correspond to FAME’s QUARTER |
|
MONTH |
correspond to FAME’s MONTH |
|
SEMIMONTH |
correspond to FAME’s SEMIMONTH |
|
TENDAY |
correspond to FAME’s TENDAY |
|
WEEK |
corresponds to FAME’s WEEKLY(SATURDAY) |
|
WEEK.2 |
corresponds to FAME’s WEEKLY(SUNDAY) |
|
WEEK.3 |
corresponds to FAME’s WEEKLY(MONDAY) |
|
WEEK.4 |
corresponds to FAME’s WEEKLY(TUESDAY) |
|
WEEK.5 |
corresponds to FAME’s WEEKLY(WEDNESDAY) |
|
WEEK.6 |
corresponds to FAME’s WEEKLY(THURSDAY) |
|
WEEK.7 |
corresponds to FAME’s WEEKLY(FRIDAY) |
|
WEEK2 |
corresponds to FAME’s BIWEEKLY(ASATURDAY) |
|
WEEK2.2 |
correspond to FAME’s BIWEEKLY(ASUNDAY) |
|
WEEK2.3 |
correspond to FAME’s BIWEEKLY(AMONDAY) |
|
WEEK2.4 |
correspond to FAME’s BIWEEKLY(ATUESDAY) |
|
WEEK2.5 |
correspond to FAME’s BIWEEKLY(AWEDNESDAY) |
|
WEEK2.6 |
correspond to FAME’s BIWEEKLY(ATHURSDAY) |
|
WEEK2.7 |
correspond to FAME’s BIWEEKLY(AFRIDAY) |
|
WEEK2.8 |
correspond to FAME’s BIWEEKLY(BSATURDAY) |
|
WEEK2.9 |
correspond to FAME’s BIWEEKLY(BSUNDAY) |
|
WEEK2.10 |
correspond to FAME’s BIWEEKLY(BMONDAY) |
|
WEEK2.11 |
correspond to FAME’s BIWEEKLY(BTUESDAY) |
|
WEEK2.12 |
correspond to FAME’s BIWEEKLY(BWEDNESDAY) |
|
WEEK2.13 |
correspond to FAME’s BIWEEKLY(BTHURSDAY) |
|
WEEK2.14 |
correspond to FAME’s BIWEEKLY(BFRIDAY) |
|
WEEKDAY |
correspond to FAME’s WEEKDAY |
|
DAY |
correspond to FAME’s DAY |
|
BY Variables |
None |
|
Series Variables |
Variable names are constructed from the FAME series codes. Note that series names are limited to 32 bytes. |
|
|
|
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.