You can generate a customized list of item names available in the daily stock database (SETID=10) by running the following sample statements for each group name in Table 40.8:
libname dstock sasexccm "\\bb04smb01\thirdparty\lnx\crspdata\DIZ201006\" setid=10 permno=12490 itemlist="group_name.*"; proc contents data=dstock.group_name; run;
The following statements generate an item list of all the item names available in the group named STKHDR_ID:
libname crsp sasexccm "\\bb04smb01\thirdparty\lnx\crspdata\DIZ201006\" setid=10 permno=12490 itemlist="STKHDR_ID.*"; proc contents data=crsp.stkhdr_id; run;
The item names in group STKHDR_ID are listed in Table 40.7.
Table 40.7: US Daily Stock Items in Group STKHDR_ID
Item Name |
Description |
---|---|
BEGDT |
Begdt |
COMPNO |
COMPNO |
CUSIP |
CUSIP |
ENDDT |
Enddt |
HCOMNAM |
Latest company name |
HDLSTCD |
DEL |
HEXCD |
EX |
HPRIMEXCH |
Ex1 |
HSECSTAT |
Sst |
HSHRCD |
SH |
HSICCD |
SIC |
HSNAICS |
Naics |
HSUBEXCH |
Ex2 |
HTICK |
Htick |
HTRDSTAT |
Tst |
HTSYMBOL |
Symbol |
ISSUNO |
Issuno |
KYPERMNO |
PERMNO |
PERMCO |
PERMCO |
PERMNO |
PERMNO |