Input, Output and Formatting Options

ccm_print allows qualifiers that control database selection, input methods, and output formats.

1. Set Date Ranges

/dt range1 [-range2]

Each range can be in the form YYYY, YYYYMM, or YYYYMMDD. The earliest possible date implied by that range is used for the beginning date and the last possible date implied by that range is used for the end date.

Using YYYY: /dt2007
Annual data range: 2007 - 2007
Quarterly data range: 2007.1 - 2007.4

Using YYYYMM-YYYYMM: /dt200702-200803
Annual data range: 2007 - 2007
Quarterly data range: 2007.1 - 2008.1

Using YYYYMMDD-YYYYMMDD: /dt20070125-20080415
Annual data range: 2007 - 2007
Quarterly data range: 2007.1 - 2008.1

2. Change Date Display

/dd DATE_DISP

CCM data may be displayed as either fiscal or calendar-based data.. Compustat data are grouped and restricted by Data Year, which is determined by where a company’s fiscal year falls within the calendar year. CRSP’s default displays the Compustat data in the calendar year for which it is reported.

Possible values are:

CAL
Default calendar-based display. All filing data will be dated by the Compustat DATADATE, the ending date of the filing period. All non-filing data will be dated normally by calendar date.

FYR
Fiscal-based display. All filing data will be dated in terms of its fiscal year or quarter using the Compustat concept of a Data Year, where the filing data are reported in the year in which most activity occurs. All non-filing data will be dated normally.

The following table illustrates the difference in output between the CAL and FYR options. Sales reported for a fiscal year ending in May, where most activity occurs in the previous year, reports as follows under each option:

/dd cal (default) /dd fyr
DATADATE SALE Year FYRA SALE
  1999 5 10130.13  
20000531 10130.13 2000 5 10859.67
20010531 10859.67 2001 5 9673
20020531 9673 2002 5 9475
20030530 9475 2003 5 10156
20040528 10156 2004 5 11799
20050531 11799 2005 5 14380
20060531 14380 2006 5 17996