Problem Note 62242: For some ORDER= and format combinations, PROC SURVEYMEANS generates an error or incorrect domain quantile standard errors using replication methods
 |  |  |  |
In 9.4 TS1M1 (SAS/STAT 13.1) or 9.4 TS1M2 (SAS/STAT 13.2), when all of the following conditions are met in PROC SURVEYMEANS:
- The PERCENTILE= , DECILES, MEDIAN, Q1, Q3, or QUARTILES option is specified
- VARMETHOD=BRR or VARMETHOD=JK
- A DOMAIN statement is specified
- The option ORDER=DATA is specified
- The input data set order and the internal order of the domain values are different
Then the domain percentile standard errors and confidence limits are incorrect.
To circumvent the problem, specify ORDER=INTERNAL.
If in addition to the first three qualifications above, a domain variable is formatted, PROC SURVEYMEANS issues:
To circumvent the problem, omit the format and specify ORDER=INTERNAL.
In 9.4 TS1M3 (SAS/STAT 14.1), 9.4 TS1M4 (SAS/STAT 14.2), or 9.4 TS1M5 (SAS/STAT 14.3), under the following conditions in PROC SURVEYMEANS:
- The PERCENTILE= , DECILES, MEDIAN, Q1, Q3, or QUARTILES option is specified
- VARMETHOD=BOOSTRAP*, VARMETHOD=BRR, or VARMETHOD=JK *The bootstrap variance estimation method is new in SAS/STAT 14.2.
- A DOMAIN statement is specified
And in addition:
- No domain variables are formatted, ORDER=DATA is specified, and
- The input data set order and the internal order of the domain values are different
Or
- A domain variable is formatted, ORDER=INTERNAL, or ORDER=DATA is specified, and
- Either of these orderings of the domain values is different from that of the formatted order of the domain values
Then the domain percentile standard errors and confidence limits are incorrect.
If no domain variables are formatted, you can circumvent the problem by specifying ORDER=INTERNAL. If a domain variable is formatted, you can circumvent the problem by specifying ORDER=FORMATTED.
In all cases where incorrect standard errors are generated, both the printed Domain Quantiles table and the ODS Output data set DomainQuantiles are affected.
Also note that the default replication variance estimates for quantiles is improved beginning SAS 9.4 TS1M3 (SAS/STAT 14.1). You can specify the BRR or JK method-option NAIVEQVAR to reproduce the results from earlier release. See Usage Note 62247 for details.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/STAT | z/OS | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 |
| Microsoft® Windows® for x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise 32-bit | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Enterprise x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro 32-bit | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 8 Pro x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Enterprise x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro 32-bit | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 8.1 Pro x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows 10 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2008 | 13.1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2008 R2 | 13.1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2008 for x64 | 13.1 | 9.4 TS1M1 | ||||
| Microsoft Windows Server 2012 Datacenter | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 R2 Std | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Microsoft Windows Server 2012 Std | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Windows 7 Enterprise 32 bit | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Windows 7 Enterprise x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Windows 7 Home Premium 32 bit | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Windows 7 Home Premium x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Windows 7 Professional 32 bit | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Windows 7 Professional x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Windows 7 Ultimate 32 bit | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Windows 7 Ultimate x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| 64-bit Enabled AIX | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| 64-bit Enabled Solaris | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| HP-UX IPF | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Linux for x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Solaris for x64 | 13.1 | 15.1 | 9.4 TS1M1 | 9.4 TS1M6 | ||
| Type: | Problem Note |
| Priority: | alert |
| Topic: | Analytics ==> Survey Sampling and Analysis SAS Reference ==> Procedures ==> SURVEYMEANS |
| Date Modified: | 2019-02-22 09:11:30 |
| Date Created: | 2018-05-01 10:17:49 |