SUPPORT / SAMPLES & SAS NOTES
Problem Note 44394: A Multivariate Statistical Driver analysis fails with the error 'Syntax error while parsing WHERE clause.' in macro ANL_MULTIVARIATECALC
 |  |  |  |  |
Columns with too many distinct values in SAS® Warranty Analysis might not be used in a Multivariate Statistical analysis. If all columns in the analysis are not used because of too many distinct values, the analysis fails and the job log might show multiple errors beginning with "ERROR: Syntax error while parsing WHERE clause."
*
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.
In the 4.3 release of SAS Warranty Analysis, the UI does show the analysis completed with errors and includes the following message:
The summarized data has too few rows to run Multivariate Statistical Drivers analysis.
In the 4.31 release, the UI might not update properly and the gear icon might incorrectly indicate the analysis is running. The messages tab might also display "reportAnalysisDS_empty_error".
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Warranty Analysis | Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 |
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| 64-bit Enabled AIX | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| 64-bit Enabled Solaris | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| HP-UX IPF | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||
| Linux for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M1 | ||