The SASEXCCM Interface Engine

This example shows how to retrieve the GVKEY and name for every company in the CCM database.

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;

For brevity, only the first 20 observations are shown, and only KYGVKEY and CONM are kept in Output 40.5.1.