CRSP Item List Notation

CRSP has established a standard notation for specifying a set of data items. The notation includes a high level item descriptor comprised of item elements, global qualifiers, and keyset specifications. If an item/keyset combination is requested more than one time, it is honored in the first request and ignored in all subsequent requests.

1. Full_list

Full description of items to select, in the form

[global_section:]list_section
A. GLOBAL_SECTION

Optional section modifies all elements in the list_section. The following markers can be included:

f:

Applicable and populated footnote items are added for every item selected. Example:

/ml “f:sale;at;ceq”

Selects sales, total assets, and common equity items with default keysets and available footnotes for the selected items. This is equivalent to:

/ml “sale;sale_fn;at;at_fn;ceq;ceq_fn”

d:

Applicable and populated data codes items are added for every item selected. Example:

/ml “d:sale;at;ceq”

Selects sales, total assets, and common equity items with default keysets and available data codes for the selected items.

This is equivalent to:

/ml “sale;sale_dc;at;at_dc;ceq;ceq_dc”

k.keyset_list

The specified keyset _list is applied to all items in the list without a keyset already specified. keyset_list is one of the following:

* select all available keysets for each item selected.

#-#,#... select all indicated keysets in a numeric list. Examples include: k.3 or 1-2 or 1,3,7, or 2-4,8 and so on.

empty use default keysets for all items selected.

For example, the following two usages are equivalent, since keyset 1 is always the default keyset.

/ml “k:sale;at;ceq”
/ml “k.1:sale;at;ceq”
B. LIST_SECTION

Semi-colon-delimited string of list elements, enclosed in double quotes, in the form:

“list_element[;list_element…]”

list_element

Describes an element name, elem_name that can be either a CRSP item name (itm_name) or group name (grp_name) and keysets that are applied to it. It is in the form elem_name[.keyset_list]

Examples:

/ml “sale.1;at.1”
/ml “sale;at;ceq”

2. File + list

Variation of full_list, but allows for use of an input file to manage large data requests. It is specified in the form

[global_section:]file_path

Where file_path is the path of a text file conitaining a list_element on each row.

Examples:
Example 1
/mf itm_file.inp

Where itm_file.inp contains three lines:

sale
at
ceq

and is equivalent to

/ml “sale;at;ceq”
Example 2
/mf f:itm_file.inp

Finds items and associated footnotes of those items. With the same input file as in Example 1 above, is equivalent to

/ml “f:sale;at;ceq”

or

/ml “sale;sale_fn;at;at_fn;ceq;ceq_fn”

3. Printopt

2-letter shorthand code for selected groups, specified in the form print_opt[.keyset_list]

Example:

/pa.1 /pq.* /ml “aperdes.1” /ml “qperdes.*”

Printopt, /ml, and /mf options may be used within a single request in any combination.