Problem Note 34539: PROC X12 stops processing when the number of missing values exceeds 80
If a variable listed on the VAR statement in PROC X12 is set to missing for all observations in the DATA= data set or within a given BY group, then the procedure should print the following errors and continue processing the remaining variables or BY groups:
ERROR: For variable VARNAME, all observations are equal to missing values.
ERROR: An error was found in PROC X12 input. Processing skipped for variable VARNAME.
The above correct behavior occurs if the number of missing values for a given variable in the DATA= data set or within a given BY group is 80 or less. However, if the DATA= data set or a BY group contains at least one variable with 81 or more missing values, then the X12 procedure prints the following error message and stops processing:
ERROR: Adding MV DATE exceeds the number of regression effects allowed in the model (80). Check the regression model.
If the above error is encountered and the OUT= option is specified in the OUTPUT statement, then the OUT= data set is not created by the X12 procedure.
To circumvent the problem, omit any variables that contain more than 80 missing values from the VAR statement.
Operating System and Release Information
| SAS System | SAS/ETS | Microsoft® Windows® for x64 | 9.1 TS1M3 | 9.2 TS2M2 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 | 9.2 TS2M2 |
| z/OS | 9.1 TS1M3 | 9.2 TS2M2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS2M2 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS2M2 |
| Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS2M2 |
| Windows Vista | 9.1 TS1M3 | 9.2 TS2M2 |
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS2M2 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS2M2 |
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS2M2 |
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS2M2 |
| Linux | 9.1 TS1M3 | 9.2 TS2M2 |
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS2M2 |
| Tru64 UNIX | 9.1 TS1M3 | 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
Analytics ==> Forecasting
Analytics ==> Time Series Analysis
Analytics
Data Management ==> Manipulation and Transformation ==> BY-group processing
Data Management ==> Manipulation and Transformation ==> Date and Time
Data Management ==> Manipulation and Transformation ==> Missing Values
SAS Reference ==> Procedures ==> X11
SAS Reference ==> Procedures ==> X12
|
| Date Modified: | 2009-11-24 14:03:00 |
| Date Created: | 2009-01-19 13:21:21 |
