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;