The SASEXCCM Interface Engine

This example shows how to retrieve data on total assets (ATQ) and after tax gain or loss (GLAQ) with the global option for turning on footnote items, which uses the following syntax:

   ITEMLIST="f:itm_name1;itm_name2;....itm_nameN"

The default (standard) keyset is used for all items. For brevity, a subset of the data with the most recent figures is specified by the WHERE statement.

title 'Retrieve data for IBM with Footnotes';
libname _all_ clear;

libname crsp sasexccm "%sysget(CRSP_CCM)"
  setid=250
  gvkey=6066
  itemlist="f:atq;glaq";

data recent;
    set crsp.qtritem;
    where datadate >= '1jan2004'd;

proc print data=recent;
run;