topic Re: PROC MEANS doubles % signs in label? in SAS Procedures

PROC MEANS doubles % signs in label?

Quentin — Wed, 13 Jun 2018 15:15:49 GMT

I'm running PROC MEANS on a labeled variable, that has a % in the label. The output (both listing and ODS HTML) shows two percent signs.

proc means data=sashelp.class ;
  var age ;
  label age='My % label with %' ;
run ;

Returns:

                        The MEANS Procedure

             Analysis Variable : Age My %% label with %%

  N            Mean         Std Dev         Minimum         Maximum
 19      13.3157895       1.4926722      11.0000000      16.0000000

Any particular reason this happens, or way to avoid it? PROC PRINT and PROC FREQ don't double the percent signs.

Above is from 9.4M4 on Win10.

Re: PROC MEANS doubles % signs in label?

FreelanceReinh — Wed, 13 Jun 2018 16:35:42 GMT

Hi @Quentin,

This 2013/2014 thread suggests that it started with SAS 9.2 and this is also the first version where I saw it in PROC FREQ cross-tabulations, but not in univariate tables (!), and later in PROC MEANS. My attempt to write the percent sign as %sysfunc(byte(37)) failed. However, in the old thread a user joejw84 stated he had more luck using a unicode representation for ODS output, which I haven't tried yet.

Re: PROC MEANS doubles % signs in label?

ballardw — Wed, 13 Jun 2018 17:35:24 GMT

This apparently is coming from the BASE.SUMMARY template in SASHELP.TMPLMST and the way the dynamic variable for labels is treated.

However I can't find anything in Proc Template documentation (which I hate digging through) for dynamic variables, which the Label is, for why this might happen as there is no actual manipulation of the label variable in the template.

You might be able to create a custom version of the template and change the code for the header to resemble the code for the LCLM and UCLM headers which do display a single %.

Or send the result to data set and use a Title statement to say the same thing with proc print.

Re: PROC MEANS doubles % signs in label?

Quentin — Thu, 14 Jun 2018 11:02:28 GMT

Wow, I'm shocked this bug could have survived since 9.2. I'll send it in to tech support, just in case the OP of that thread never did.

Re: PROC MEANS doubles % signs in label?

Quentin — Thu, 14 Jun 2018 11:12:37 GMT

Thanks @ballardw. In the older thread Cynthia Z pointed out this support note, http://support.sas.com/kb/18/708.html, also about % signs in labels being doubled in dynamic column headers, but the note suggests it's more limited scope.

Re: PROC MEANS doubles % signs in label?

Quentin — Thu, 14 Jun 2018 14:58:12 GMT

Tech support confirmed it is a known issue, and suggested the unicode workaround. I recommended they add a problem note to document this (or expand the current note since the problem is not limited to FILE PRINT ODS).

They sent:

ods escapechar='^';
ods listing close;
ods pdf file='ctest.pdf';
 
proc means data=sashelp.class ;
  var age ;
  label age='My ^{unicode 0025} label with ^{unicode 0025}' ;
run ;


proc freq data=sashelp.class;
  tables name*sex ;
  label name='Name with ^{unicode 0025}' ;
  label sex='sex with ^{unicode 0025}' ;
run ;

ods pdf close;