Daily STK Data Items

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 39.9:

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 39.8.

Table 39.8 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


Note: This procedure is experimental.