Problem Note 1583: PROC REPORT may produce incorrect output when more than one statistic is
associated with an alias
If you stack multiple statistics with associated aliases under an
analysis variable or variables (similar to an ACROSS variable) and there
is a COMPUTED variable to the right of the statistics, the output will
be incorrect. In particular, the reported statistics will be equal to
the first stated statistic value. For example:
COL analysis,(statistic1=alias1...statisticN=aliasN) computed;
OR
COL analysis,statistic1=alias1 analysisN,statisticN=aliasN computed;
There are 2 possible workarounds.
1) State the analysis variable and the alias separately on the COLUMN
statement and then use the DEFINE statement to specify the statistic.
For example: COLUMN analysis1=a1 analysisN=aN computed;
Define a1 / statistic;
Define aN / statistic;
2) Use the NOALIAS option on the PROC REPORT statement. NOTE: if the
NOALIAS option is used then any reference to the alias in a COMPUTE
block will need to use analysis.statistic form (not the alias name).
Operating System and Release Information
| Product Family | Product | System | Reported Release | Fixed Release* |
| SAS System | Base SAS | Microsoft Windows 95/98 | 8 TS M0 | 8.1 TS1M0 |
| Microsoft Windows NT Workstation | 8 TS M0 | 8.1 TS1M0 |
| OpenVMS VAX | 8 TS M0 | 8.1 TS1M0 |
| Solaris | 8 TS M0 | 8.1 TS1M0 |
| IRIX | 8 TS M0 | 8.1 TS1M0 |
| 64-bit Enabled Solaris | 8 TS M0 | 8.1 TS1M0 |
| OS/2 | 8 TS M0 | 8.1 TS1M0 |
| ABI+ for Intel Architecture | 8 TS M0 | 8.1 TS1M0 |
| z/OS | 8 TS M0 | 8.1 TS1M0 |
| HP-UX | 8 TS M0 | 8.1 TS1M0 |
| OpenVMS Alpha | 8 TS M0 | 8.1 TS1M0 |
| CMS | 8 TS M0 | 8.1 TS1M0 |
| 64-bit Enabled HP-UX | 8 TS M0 | 8.1 TS1M0 |
| Tru64 UNIX | 8 TS M0 | 8.1 TS1M0 |
| 64-bit Enabled AIX | 8 TS M0 | 8.1 TS1M0 |
| AIX | 8 TS M0 | 8.1 TS1M0 |
*
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 |
| Topic: | SAS Reference ==> Procedures ==> REPORT
|
| Date Modified: | 2000-05-04 16:05:15 |
| Date Created: | 2000-01-11 08:43:38 |