SAS/ETS User's Guide Example Programs

Comparing Different Ways of Accessing CCM Data

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

                    SAS Sample Library

        Name: crpex07.sas
 Description: Example program from SAS/ETS User's Guide,
              The SASECRSP Interface Engine
    Title: Comparing Different Ways of Accessing CCM Data
  Product: SAS/ETS Software
     Keys: CCM data access, CRSPAccess, PERMNO, PERMCO, GVKEY
    Procs: SASECRSP
    Notes: Read this before you run this sample.
           The CRSP CCM database resides in the  CRSP_CST folder. You
           must install your CRSP COMPUSTAT Merged data
           and define your Windows system environment
           variable, CRSP_CST, to point to the physical path
           of your installed CRSP CCM database. Use the following
           form of the libname statement:

libname crsp1a sasecrsp "%sysget(CRSP_CST)"
        setid=200
        permno=10083
        range='19870101-19900101';
----------------------------------------------------------------*/
title1 'Comparing various access methods for CCM data';
libname _all_ clear;

/* assign libnames for the three different access methods */
libname crsp1a sasecrsp "%sysget(CRSP_CST)"
        setid=200
        permno=10083
        range='19870101-19900101';

libname crsp1b sasecrsp "%sysget(CRSP_CST)"
        setid=200
        permco=8026
        range='19870101-19900101';

libname crsp2 sasecrsp "%sysget(CRSP_CST)"
        setid=200
        gvkey=11947 gvkey=15495
        range='19870101-19900101';
title2 'PERMNO=10083 access of CCM data';
title3 'Sales (Net)';

data permnoaccess;
  set crsp1a.iqitems(keep=gvkey rcaldt fiscaldt iq2);
run;

proc print data=permnoaccess;
run;
title2 'GVKEY=11947 and GVKEY=15495 access of CCM data';
title3 'Sales (Net)';

data gvkeyaccess;
  set crsp2.iqitems(keep=gvkey rcaldt fiscaldt iq2);
run;

proc print data=gvkeyaccess;
run;
title3 'LINK: Link information';
proc print data=crsp2.link;
run;

/* Show how PERMNO and PERMCO access are the same */
title4 'Proc compare of PERMNO vs. PERMCO access of CCM data';
proc compare base=crsp1a.iqitems compare=crsp1b.iqitems brief;
run;
Resources

Comparing Different Ways of Accessing CCM Data
