Access to Financial and Economic Databases

The DATASOURCE procedure and the SAS/ETS data access interface LIBNAME Engines (SASECRSP, SASEFAME, SASEHAVR and SASEXCCM) provide seamless, efficient access to time series data from data files supplied by a variety of commercial and governmental data vendors.

The DATASOURCE procedure includes the following features:

  • support for data files distributed by the following data vendors:

    • DRI/McGraw-Hill

    • FAME Information Services

    • HAVER ANALYTICS

    • Standard & Poors Compustat Service

    • Center for Research in Security Prices (CRSP)

    • International Monetary Fund

    • U.S. Bureau of Labor Statistics

    • U.S. Bureau of Economic Analysis

    • Organization for Economic Cooperation and Development (OECD)

  • ability to select the series, frequency, time range, and cross sections of extracted data

  • ability to create an output data set containing descriptive information on the series available in the data file

  • ability to read EBCDIC data on ASCII systems and vice versa

The SASECRSP interface LIBNAME engine includes the following features:

  • enables random access to time series data residing in CRSPAccess databases

  • provides a seamless interface between CRSP and SAS data processing

  • uses the LIBNAME statement to enable you to specify which time series you would like to read from the CRSPAccess database, and how you would like to perform selection

  • enables you access to CRSP Stock, CRSP/COMPUSTAT Merged (CCM) or CRSP Indices Data.

  • provides convenient formats, informats, and functions for CRSP and SAS datetime conversions

The SASEFAME interface LIBNAME engine includes the following features:

  • provides SAS and FAME users flexibility in accessing and processing time series data, case series, and formulas that reside in either a FAME database or a SAS data set

  • provides a seamless interface between FAME and SAS data processing

  • uses the LIBNAME statement to enable you to specify which time series you would like to read from the FAME database

  • enables you to convert the selected time series to the same time scale

  • works with the SAS DATA step to perform further subsetting and to store the resulting time series into a SAS data set

  • performs more analysis if desired either in the same SAS session or in another session at a later time

  • supports the FAME CROSSLIST function for subsetting via BYGROUPS using the CROSSLIST= option

    • you can use a FAME namelist that contains your BY variables for selection in the CROSSLIST

    • you can use a SAS input dataset, INSET, that contains the BY selection variables along with the WHERE= option in your SASEFAME libref

  • supports the use of FAME in a client/server environment that uses the FAME CHLI capability on your FAME server

  • enables access to your FAME remote data when you specify the port number of the TCP/IP service that is defined for your FAME server and the node name of your FAME master server in your SASEFAME libref’s physical path

The SASEHAVR interface LIBNAME engine includes the following features:

  • enables Windows users random access to economic and financial data residing in a HAVER ANALYTICS Data Link Express (DLX) database

  • the following types of HAVER data sets are available:

    • United States Economic Indicators

    • Specialized Databases

    • Financial Indicators

    • Industry

    • Industrial Countries

    • Emerging Markets

    • International Organizations

    • Forecasts and As Reported Data

    • United States Regional

  • enables you to limit the range of data that is read from the time series

  • enables you to specify a desired conversion frequency. Start dates are recommended on the LIBNAME statement to help you save resources when processing large databases or when processing a large number of observations.

  • enables you to use the WHERE, KEEP, or DROP statements in your DATA step to further subset your data

  • supports use of the SQL procedure to create a view of your resulting SAS data set

The SASEXCCM interface LIBNAME engine includes the following experimental features:

  • enables random access to time series data residing in CRSPAccess databases

  • provides a seamless interface between CRSP, Compustat XpressFeed and SAS data processing

  • uses the LIBNAME statement to enable you to specify which data items, data groups and time series you would like to read from the CRSPAccess database, and how you would like to perform selection

  • supports data-item-handling access methods to CRSP Stock (STK), CRSP/COMPUSTAT Merged (CCM), CRSP Indices (IND) or CRSP Treasury (TRS) Data.

  • provides selection based on keys such as GVKEY, PERMNO, INDNO, TREASNO, and TCUSIP for efficient access to data items.