Retrieving SALE Data for One GVKEY

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

                    SAS Sample Library

        Name: xcmex01.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASEXCCM Interface Engine
    Title: Retrieving SALE Data for One GVKEY
  Product: SAS/ETS Software
     Keys: CCM Data Access, CRSPAccess, Expressfeed Data Access, 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.
           The physical path on Windows could look like this:
               \\bb04smb01\thirdparty\lnx\crspdata\CMZ201201\
           but on LAX could look like this:
               /thirdparty/crspdata/CMZ201201/

           Use the following form of the libname statement:

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

title 'Retrieve SALE data for IBM';
libname _all_ clear;

libname crsp sasexccm "/thirdparty/crspdata/CMZ201201/"
   setid=250
   gvkey=6066
   itemlist="sale";

data recentsales;
    set crsp.annitem;
    where datadate >= '1jan2000'd;

proc print data=recentsales;
run;