Problem Note 14664: Calendar Date Field (Caldt) may be incorrect when using SASECRSP to
access APERDES and QPERDES
The Calendar Date Field (CALDT) may be incorrect when directly using the
SASECRSP engine to access the Annual Period Descriptors Time Series
(APERDES) and the Quarterly Period Descriptors Time Series (QPERDES) in
the CRSP/COMPUSTAT Merged Database (CCM).
In order to correctly access APERDES and QPERDES, always store the data
in its own SAS data set by using the SAS DATA Step first. For example,
if you want to perform a PROC PRINT on QPERDES for a specific company,
you would use the following code. Note: gvkey=6066 identifies a
specific company.
/* Required. QPERDES data is only accessible as a SAS dataset */
data qperdes_data;
set libref.qperdes;
run;
/* Avoid using libref.qperdes or libref.aperdes directly */
/* Use the SAS data set that was created */
proc print data=qperdes_data;
run;
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#014664
For customers running SAS with Asian Language Support (DBCS), this
fix should be downloaded from:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#014664
Operating System and Release Information
SAS System | SAS/ETS | Microsoft Windows NT Workstation | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Microsoft Windows XP Professional | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Linux | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
64-bit Enabled Solaris | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Microsoft Windows 2000 Professional | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
Microsoft Windows 2000 Server | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
OpenVMS Alpha | 9.1 TS1M3 SP2 | 9.1 TS1M3 SP3 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | alert |
Date Modified: | 2005-10-21 14:32:08 |
Date Created: | 2005-02-25 13:52:59 |