Example 35.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 35.9.1 shows Earnings Per Share for several companies for the 1994 fiscal year.

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.