Retrieving SALE Data for One GVKEY
/*----------------------------------------------------------------
SAS Sample Library
Name: xcmex01.sas
Description: Example program from SAS/ETS User's Guide,
The SASEXCCM Interface Engine
Title: Retrieving SALE Data for One GVKEY
Product: SAS/ETS Software
Keys: CCM Data Access, CRSPAccess, Expressfeed Data Access, ITMLIST= 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 system environment
variable, CRSP_CCM, to point to the physical path
of your installed CRSP CCM database.
The physical path on Windows could look like this:
\\bb04smb01\thirdparty\lnx\crspdata\CMZ201201\
but on LAX could look like this:
/thirdparty/crspdata/CMZ201201/
Use the following form of the libname statement:
libname crsp sasexccm "%sysget(CRSP_CCM)"
setid=250
gvkey=6066
itemlist="sale";
----------------------------------------------------------------*/
title 'Retrieve SALE data for IBM';
libname _all_ clear;
libname crsp sasexccm "/thirdparty/crspdata/CMZ201201/"
setid=250
gvkey=6066
itemlist="sale";
data recentsales;
set crsp.annitem;
where datadate >= '1jan2000'd;
proc print data=recentsales;
run;