The SASECRSP Interface Engine

Example 39.9 Using Fiscal Date Range Restriction

Fiscal date ranges give you the flexibility of selecting company data by using fiscal year range sepcifications instead of calendar year range specifications. This example shows how to use this feature to extract data such as the 'Earnings Per Share' time series for several companies for the 1994 fiscal year.

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;

Output 39.9.1 shows Earnings Per Share for several companies for the 1994 fiscal year.

Output 39.9.1: Earnings Per Share by GVKEY Access for the 1994 Fiscal Year.

Extract data for fiscal year 1994 for several companies

Obs	GVKEY	Raw Calendar Trading Date	Fiscal Trading Date	Research and Development Expense	Earnings Per Share (Diluted) - Excluding Extraordinary Items	Earnings Per Share (Basic) - Excluding Extraordinary Items	Net Income (Loss)
1	6066	19940331	19940331	1100.0000	0.6300	0.6400	392.0000
2	6066	19940630	19940630	1092.0000	1.1300	1.1400	688.0000
3	6066	19940930	19940930	1053.0000	1.1600	1.1800	710.0000
4	6066	19941230	19941230	1118.0000	2.0300	2.0600	1231.0000
5	12141	19930930	19940331	134.0000	0.7900	0.7900	239.0000
6	12141	19931231	19940630	150.0000	0.9500	0.9500	289.0000
7	12141	19940331	19940930	156.0000	0.8400	0.8400	256.0000
8	12141	19940630	19941230	170.0000	0.5900	0.5900	362.0000
9	10107	19940331	19940331	A	0.4600	0.4600	11.3890
10	10107	19940630	19940630	A	0.7100	0.7100	17.3670
11	10107	19940930	19940930	A	0.7600	0.7600	18.8070
12	10107	19941230	19941230	100.9630	0.5400	0.5400	13.4190

Note how two time ID variables are kept. Raw Calendar Trading Date provides the actual calendar date. Fiscal Trading Date provides the date according to the company’s fiscal calendar which is dependent upon when its fiscal year-end month is. For example, Observation 8 is Microsoft’s fourth fiscal quarter, hence a Fiscal Trading Date of December 30,1994. Since Microsoft’s fiscal year ends in June, its fourth fiscal quarter corresponds to the second calendar quarter of the year, so the Raw Calendar Trading Date shows June 30,1994. The shift calculation of six months (in this case) required to compute the Raw Calendar Trading Date is done automatically by the SASECRSP engine.Keep in mind that fiscal date ranges are applicable only to fiscal members. When fiscal date range restrictions are applied to nonfiscal members, they are ignored. The missing value '.A' seen in observations 9 through 12 indicate that the data is reported only on an annual basis.