The SASEXCCM Interface Engine
- Overview
- Getting Started
-
Syntax
-
DetailsSAS Output Data SetMissing ValuesData Reference: IntroductionCCM Data ItemsCCM KeysetsCCM Data GroupsDaily STK Data ItemsDaily STK Data GroupsMonthly STK Data ItemsMonthly STK Data GroupsIND Group Data Item NamesMonthly IND Group Data Group NamesDaily IND Group Data Group NamesIND Time Series Data Item NamesMonthly IND Time Series Data Group NamesDaily IND Time Series Data Group Names
-
ExamplesRetrieving SALE Data for One GVKEYRetrieving SALE Data for Multiple CompaniesRetrieving Data from Different KeysetsRetrieving Items by Using Global OptionsRetrieving All GVKEYs and Company NamesRetrieving Stock Time Series by PERMNORetrieving Stock and Indices Monthly Time Series by INDNORetrieving Stock and Indices Daily Time Series by INDNORetrieving Information for Availability of Group INDNOsRetrieving Daily Group Time Series by the INDNO= OptionRetrieving Monthly Group Time Series by the INDNO= Option
- References
In general, CRSP missing values are represented as ‘.’ in the SAS data set. When accessing the CCM database, the SASEXCCM engine interprets missing values according to the conditions and codes defined by Compustat and represents them as SAS missing codes, as shown in Table 40.3.
Table 40.3: Mapping of Compustat and SAS Missing Codes
|
Missing Value |
Missing Code |
Condition |
|---|---|---|
|
0.0001 |
. |
No data for data item |
|
0.0002 |
.S |
Data are available only on a semi-annual basis |
|
0.0003 |
.A |
Data are available only on an annual basis |
|
0.0004 |
.C |
Combined into other item |
|
0.0007 |
.N |
Data are not meaningful |
|
0.0008 |
.I |
Reported as insignificant |
Missing value codes conform with Compustat’s Strategic Insight and binary conventions for missing values. For more information about how CRSP handles Compustat missing codes, see the section “Notes on Missing Values” in the second chapter of the CRSP/Compustat Merged Database Guide.