Previous Page | Next Page

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 36, 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 36, The SASEFAME Interface Engine.

FILETYPE=FAME–FAME Information Services Databases

Table 11.25 FILETYPE=FAME–FAME Information Services Database Format

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.

Previous Page | Next Page | Top of Page