Resources

Retrieving All GVKEYs and Company Names

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

                    SAS Sample Library

        Name: xcmex05.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASEXCCM Interface Engine
    Title: Retrieving All GVKEYs and Company Names
  Product: SAS/ETS Software
     Keys: CCM Data Access, CRSPAccess, Expressfeed, ITEMLIST=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 Windows 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
  itemlist="company";
----------------------------------------------------------------*/

title 'Retrieve All GVKEYs and Company Names';
libname _all_ clear;

libname crsp sasexccm "%sysget(CRSP_CCM)"
  setid=250
  itemlist="company";

proc contents data=crsp.company;
proc print data=crsp.company(keep=kygvkey conm obs=20);
run;