The SASEXCCM Interface Engine

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