Using Fiscal Date Range Restriction
/*----------------------------------------------------------------
SAS Sample Library
Name: crpex09.sas
Description: Example program from SAS/ETS User's Guide,
The SASECRSP Interface Engine
Title: Using Fiscal Date Range Restriction
Product: SAS/ETS Software
Keys: CCM data access, CRSPAccess, Fiscal date range
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 crsp1 sasecrsp "%sysget(CRSP_CST)"
setid=200
gvkey=6066 gvkey=12141 gvkey=10107
range='f19940101-19941231';
----------------------------------------------------------------*/
title 'Extract data for fiscal year 1994 for several companies';
libname _all_ clear;
libname crsp1 sasecrsp "%sysget(CRSP_CST)"
setid=200
gvkey=6066 gvkey=12141 gvkey=10107
range='f19940101-19941231';
data rnd_eps (keep = gvkey rcaldt fiscaldt iq4 iq9 iq19 iq69);
set crsp1.iqitems;
run;
proc print data=rnd_eps label;
run;