Resources

Retrieving SALE Data for Multiple GVKEYs

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

                    SAS Sample Library

        Name: xcmex02.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASEXCCM Interface Engine
    Title: Retrieving SALE Data for Multiple GVKEYs
  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. Use the following
           form of the libname statement:

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

title 'Retrieve Sales, Revenue, Liabilities, and Officer data for IBM and MSFT';
libname _all_ clear;

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

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

proc print data=recentannitems;
proc print data=crsp.offtitl;
run;