The SASEXCCM Interface Engine (Experimental)

Example 39.3 Retrieving Data in Different Keysets

This example shows how to retrieve several data items in different keysets. The ITEMLIST= option asks for data on research and development (R&D) expenses, XRD, and net income, NI, over all available keysets by using the itm_name.* syntax in the ITEMLIST= option. Note that data is not available for all items in all keysets. For brevity, a subset of the data with the most recent figures is specified by the WHERE statement.

title 'Retrieve R&D Expenses and Net Income for IBM';
libname _all_ clear;

libname crsp sasexccm "%sysget(CRSP_CCM)"
   setid=250
   gvkey=6066
   itemlist="xrd.*;ni.*";

data recent;
    set crsp.annitem;
    where datadate >= '1jan2001'd;

proc print data=recent;
run;