Miscellaneous Reporting Options

1. Convert Currency

/ct CUR

Monetary data may be converted to and extracted using a specified currency code. Values for CUR are:

REP  As reported by Compustat is the default.

USD  US dollars

2. Keyset Display

/kd DIS

Keyset information is displayed with the output. Possible values for DIS are:

a. TAG

The default value returns the CRSP-defined mnemonic keyset tag. In the example below the keyset tags are STD and SUMM.

/ml “sale.1,2” /kd tag

Year FYRA SALE

Ann_TS_Item
-----------
 
KEYSET = STD
2002 5 9475.0000
2003 5 10156.0000
2004 5 11799.0000
2005 5 14380.0000
2006 5 17996.0000
 
 
KEYSET = SUMM
Year FYRA SALE
2002 5 9475.0000
2003 5 10156.0000
2004 5 11799.0000
2005 5 14380.0000
2006 5 17996.0000

b. NUM

Returns the keyset number.

/ml “sale.1,2” /kd num

KEYSET = 1
Year FYRA SALE
2002 5 9475.0000
2003 5 10156.0000
2004 5 11799.0000
2005 5 14380.0000
2006 5 17996.0000
 
KEYSET = 2
Year FYRA SALE
2002 5 9475.0000
2003 5 10156.0000
2004 5 11799.0000
2005 5 14380.0000
2006 5 17996.0000

c. EXP

Expands the keyset to return the Compustat items and values used to define the keyset.

/ml “sale.1,2” /kd exp

CONSOL = C, DATAFMT = STD, INDFMT = INDL, POPSRC = D

Year FYRA SALE
2002 5 9475.0000
2003 5 10156.0000
2004 5 11799.0000
2005 5 14380.0000
2006 5 17996.0000
 
CONSOL = C, DATAFMT = SUMM, INDFMT = INDL, POPSRC = D
Year FYRA SALE
2002 5 9475.0000
2003 5 10156.0000
2004 5 11799.0000
2005 5 14380.0000
2006 5 17996.0000

Keysets are never displayed if there are no effective item-qualifying keys, unless they are in a group combined with other keysets having item-qualifying keys.