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.
Full description of items to select, in the form
Optional section modifies all elements in the list_section. The following markers can be included:
Applicable and populated footnote items are added for every item selected. Example:
Selects sales, total assets, and common equity items with default keysets and available footnotes for the selected items. This is equivalent to:
Applicable and populated data codes items are added for every item selected. Example:
Selects sales, total assets, and common equity items with default keysets and available data codes for the selected items.
This is equivalent to:
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.
Semi-colon-delimited string of list elements, enclosed in double quotes, in the form:
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]
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
Where file_path is the path of a text file conitaining a list_element on each row.
Where itm_file.inp contains three lines:
and is equivalent to
Finds items and associated footnotes of those items. With the same input file as in Example 1 above, is equivalent to
2-letter shorthand code for selected groups, specified in the form print_opt[.keyset_list]
|/pa.1 /pq.* /ml “aperdes.1” /ml “qperdes.*”|
Printopt, /ml, and /mf options may be used within a single request in any combination.