Problem Note 34706: FLATDATA statement may generate duplicate or missing values in the OUT= data set
If you use the FLATDATA statement to transform variables and under the rare circumstance have more than 1000 time period observations for some cross sections, then the transformed values in the OUT= data set may be incorrectly duplicated multiple times starting from the 1000th time period observation forward. The procedure may or may not run out of memory in this case. If the procedure does not run out of memory, then the procedure will produce estimation results that are incorrect using the incorrectly transformed data.
If you have less than 1000 time period observations for all cross sections and if the time period index goes beyond 1000 for some or all the time periods, for example, x_1980, x_1981, etc., then the transformed values in the OUT= data set will be incorrectly transformed into missing values for those observations with time period index greater than 1000.
If the number of time series observations is less than 1000 for all cross sections, then you may circumvent the problem by changing the time period index to start from 1 so that all time period indices are less than 1000. If the number of time series observations is greater than or equal to 1000 for some cross sections, then you will need to transform the variables yourself prior to the PROC PANEL step to avoid using the FLATDATA statement.
Operating System and Release Information
SAS System | SAS/ETS | z/OS | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft® Windows® for x64 | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | 9.2 TS2M2 |
Microsoft Windows XP Professional | 9.2 TS1M0 | 9.2 TS2M2 |
Windows Vista | 9.2 TS1M0 | 9.2 TS2M2 |
64-bit Enabled AIX | 9.2 TS1M0 | 9.2 TS2M2 |
64-bit Enabled HP-UX | 9.2 TS1M0 | 9.2 TS2M2 |
64-bit Enabled Solaris | 9.2 TS1M0 | 9.2 TS2M2 |
HP-UX IPF | 9.2 TS1M0 | 9.2 TS2M2 |
Linux | 9.2 TS1M0 | 9.2 TS2M2 |
Linux for x64 | 9.2 TS1M0 | 9.2 TS2M2 |
OpenVMS on HP Integrity | 9.2 TS1M0 | 9.2 TS2M2 |
Solaris for x64 | 9.2 TS1M0 | 9.2 TS2M2 |
*
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: | high |
Topic: | Analytics ==> Econometrics SAS Reference ==> Procedures ==> PANEL
|
Date Modified: | 2009-09-08 13:16:55 |
Date Created: | 2009-02-04 14:52:09 |