Problem Note 67741: The SGRENDER procedure might produce incorrect X-axis labels
 |  |  |  |  |
PROC SGRENDER might produce incorrect X-axis labels when formats are applied to the X-axis variable.
Here is an example:
data dat;
y = 1;
do tp = 0, 1, 123456789012, 1234567890123, 1234567890123456;
tp=int(tp);
y + 2;
output;
end;
run;
y = 1;
do tp = 0, 1, 123456789012, 1234567890123, 1234567890123456;
tp=int(tp);
y + 2;
output;
end;
run;
proc format;
value tpC 1 = 'TP1'
123456789012 = 'TP12'
1234567890123 = 'TP13'
1234567890123456 = 'TP16'
;
run;
value tpC 1 = 'TP1'
123456789012 = 'TP12'
1234567890123 = 'TP13'
1234567890123456 = 'TP16'
;
run;
proc sgrender template=tmpl data=dat;
format tp tpC.;
run;
format tp tpC.;
run;
The following graphic is produced:
The X axis incorrectly shows the values "1E12" and "1E15" instead of "TP13" and "TP16". The same problem can occur when using numeric formats.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.4 TS1M5 | 9.4 TS1M8 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows 10 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Microsoft Windows Server 2016 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Professional x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| 64-bit Enabled AIX | 9.4 TS1M5 | 9.4 TS1M8 | ||
| 64-bit Enabled Solaris | 9.4 TS1M5 | 9.4 TS1M8 | ||
| HP-UX IPF | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Linux for x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
| Solaris for x64 | 9.4 TS1M5 | 9.4 TS1M8 | ||
A fix for this issue for Base SAS 9.4_M7 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I9R.html#67741A fix for this issue for Base SAS 9.4_M5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B6Q.html#67741
PROC SGRENDER might produce incorrect X-axis labels when formats are applied to the X-axis variable.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-06-15 10:49:32 |
| Date Created: | 2021-04-08 03:23:47 |