Resources

Retrieving Items with Global Options

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

                    SAS Sample Library

        Name: xcmex04.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASEXCCM Interface Engine
    Title: Retrieving Items with Global Options
  Product: SAS/ETS Software
     Keys: CCM Data Access, CRSPAccess, Expressfeed, Global Options, Footnotes
    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="f:atq;glaq";
----------------------------------------------------------------*/

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

libname crsp sasexccm "/thirdparty/crspdata/CMZ201201/"
  setid=250
  gvkey=6066
  itemlist="f:atq;glaq";

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

proc print data=recent;
run;