The SASECRSP Interface Engine

Data Elements Reference: SASECRSP Interface Engine

Data sets are made available based on the type of CRSP database that you open. Table 46.10 and Table 46.11 show summary views of the two types of CRSP databases (Stock and Indices) and the data sets that they make available. Tables that contain details about the data sets, including their specific fields, immediately follow the summary tables. You can also see the available data sets for an opened database via the SAS Explorer by opening a SASECRSP engine libref that you previously assigned.

Table 46.10: Summary of All Available Data Sets by CRSP Database Type

CRSP Database

Data Set Name

Reference Table Title

Reference Table

CRSP US Stock Database (STOCK)

STKHEAD

Header Identification and Summary Data

Table 46.12

 

NAMES

Name History Array

Table 46.13

 

DISTS

Distribution Event Array

Table 46.14

 

SHARES

Shares Outstanding Observation Array

Table 46.15

 

DELIST

Delisting History Array

Table 46.16

 

NASDIN

NASDAQ Information Array

Table 46.17

 

PRC

Price or Bid/Ask Average Time Series

Table 46.18

 

RET

Returns Time Series

Table 46.18

 

BIDLO

Bid or Low Price Time Series

Table 46.18

 

ASKHI

Ask or High Price Time Series

Table 46.18

 

BID

Bid Time Series

Table 46.18

 

ASK

Ask Time Series

Table 46.18

 

RETX

Returns Without Dividends Time Series

Table 46.18

 

SPREAD

Spread Between Bid and Ask

Table 46.18

 

ALTPRC

Price Alternate Time Series

Table 46.18

 

VOL

Volume Time Series

Table 46.18

 

NUMTRD

Number of Trades Time Series

Table 46.18

 

ALTPRCDT

Price Alternate Date Time Series

Table 46.18

 

PORT1

Portfolio Data for Portfolio Type 1

Table 46.19

 

PORT2

Portfolio Data for Portfolio Type 2

Table 46.19

 

PORT3

Portfolio Data for Portfolio Type 3

Table 46.19

 

PORT4

Portfolio Data for Portfolio Type 4

Table 46.19

 

PORT5

Portfolio Data for Portfolio Type 5

Table 46.19

 

PORT6

Portfolio Data for Portfolio Type 6

Table 46.19

 

PORT7

Portfolio Data for Portfolio Type 7

Table 46.19

 

PORT8

Portfolio Data for Portfolio Type 8

Table 46.19

 

PORT9

Portfolio Data for Portfolio Type 9

Table 46.19

 

GROUP16

Group Data for Group Type 16

Table 46.19


Table 46.11: Summary of All Available Data Sets by CRSP Database Type

CRSP Database

Data Set Name

Reference Table Title

Reference Table

CRSP Indices Database (IND)

INDHEAD

Index Header Data

Table 46.20

 

REBAL

Index Rebalancing History Arrays

Table 46.21

 

REBAL

Index Rebalancing History Group Arrays

Table 46.22

 

LIST

Index Membership List Arrays

Table 46.23

 

LIST

Index Membership List Groups Arrays

Table 46.24

 

USDCNT

Portfolio Used Count Array

Table 46.25

 

TOTCNT

Portfolio Total Count Array

Table 46.26

 

USDCNT

Portfolio Used Count Time Series Groups

Table 46.27

 

TOTCNT

Portfolio Total Count Time Series Groups

Table 46.28

 

USDVAL

Portfolio Used Value Array

Table 46.29

 

TOTVAL

Portfolio Total Value Array

Table 46.30

 

USDVAL

Portfolio Used Value Time Series Groups

Table 46.31

 

TOTVAL

Portfolio Total Value Time Series Groups

Table 46.32

 

TRET

Total Returns Time Series

Table 46.33

 

ARET

Appreciation Returns Time Series

Table 46.34

 

IRET

Income Returns Time Series

Table 46.35

 

TRET

Total Returns Time Series Groups

Table 46.36

 

ARET

Income Returns Time Series Groups

Table 46.37

 

IRET

Income Returns Time Series Groups

Table 46.38

 

TIND

Total Return Index Levels Time Series

Table 46.39

 

AIND

Appreciation Index Levels Time Series

Table 46.40

 

IIND

Income Index Levels Time Series

Table 46.41

 

TIND

Total Return Index Levels Groups

Table 46.42

 

AIND

Appreciation Index Levels Groups

Table 46.43

 

IIND

Income Index Levels Time Series Groups

Table 46.44