Resources

Retrieving Data in Different Keysets

/*----------------------------------------------------------------

                    SAS Sample Library

        Name: xcmex03.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASEXCCM Interface Engine
    Title: Retrieving Data in Different Keysets
  Product: SAS/ETS Software
     Keys: CCM Data Access, CRSPAccess, Expressfeed, Keysets, ITMLIST= Option
    Procs: SASEXCCM
    Notes: Read this before you run this sample.
           The CRSP CCM database resides in the CRSP_CCM folder. You
           must install your CRSP COMPUSTAT Merged database
           and define your system environment
           variable, CRSP_CCM, to point to the physical path
           of your installed CRSP CCM database. Use the following
           form of the libname statement:

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

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

libname crsp sasexccm "/thirdparty/crspdata/CMZ201201/"
   setid=250
   gvkey=6066
   itemlist="xrd.*;ni.*";

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

proc print data=recent;
run;