Problem Note 18708: Column headers containing a percent sign (%) might generate double percent signs (%%)
 |  |  |  |
Specifying a single percent sign (%) as a character in a column header might result in double percent signs (%%). This can occur in any destination, including the traditional Listing output. It can occur when you use certain procedures, including PROC FREQ, PROC MEANS, or with FILE PRINT ODS.
The sample code below illustrates the problem.
ods listing;
ods pdf file='test.pdf';
data class;
set sashelp.class;
label age='Age %';
run;
proc freq data=class;
tables age*sex;
run;
proc means data=class;
var age;
run;
ods pdf close;
ods pdf file='test.pdf';
data class;
set sashelp.class;
label age='Age %';
run;
proc freq data=class;
tables age*sex;
run;
proc means data=class;
var age;
run;
ods pdf close;
One workaround is to use the Unicode symbol for a percent sign (%) which will affect the non-listing ODS destinations. For example:
ods escapechar='^';
data class;
set sashelp.class;
label age='Age ^{unicode 0025}';
run;
data class;
set sashelp.class;
label age='Age ^{unicode 0025}';
run;
Another workaround is to use PROC TABULATE, which will affect all ODS destinations:
proc tabulate data=class;
class sex age;
table age, sex;
run;
class sex age;
table age, sex;
run;
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft Windows XP Professional | 9.1 TS1M0 | |
| Microsoft Windows NT Workstation | 9.1 TS1M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M0 | |||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M0 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M0 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M0 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M0 | |||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M0 | |||
| 64-bit Enabled Solaris | 9.1 TS1M0 | |||
| Linux | 9.1 TS1M0 | |||
| z/OS | 9.1 TS1M0 | |||
| 64-bit Enabled AIX | 9.1 TS1M0 | |||
| OpenVMS Alpha | 9.1 TS1M0 | |||
| HP-UX IPF | 9.1 TS1M0 | |||
| 64-bit Enabled HP-UX | 9.1 TS1M0 | |||
| Tru64 UNIX | 9.1 TS1M0 | |||
| Type: | Problem Note |
| Priority: | medium |
| Topic: | SAS Reference ==> ODS (Output Delivery System) |
| Date Modified: | 2006-11-03 14:50:28 |
| Date Created: | 2006-10-04 15:57:06 |